Then, right-click and pick “Unhide” in the shortcut menu. You can do this easily by dragging through them. Fortunately, there are two simple tricks for unhiding it. After you hide column A, it might seem like it's gone forever. Select the columns on each side of the hidden column(s). The secret to unhiding column A in an Excel worksheet. When you’re ready to view those hidden columns, unhiding them is just as simple as hiding them. RELATED: How to Freeze and Unfreeze Rows and Columns in Excel Unhide Columns in Microsoft Excel If you’d like to keep certain columns on screen while you scroll through your spreadsheet, learn how to freeze columns and rows in Excel. This is a good thing to keep in mind if you’re looking for data you don’t see. If you’re using a Mac, this indicator may appear as a bold green line. Right-click one of them and pick “Hide” in the shortcut menu.Īfter you hide columns in Excel, you’ll see a thick white line indicator between the remaining column headers. Once you choose the columns you want to hide, they’ll be highlighted. I've tried right-clicking unhide, select all unhide, visibility, reformatting all the column widths: nothing works. To select multiple non-adjacent columns, click the first column header, hold Ctrl, and click the remaining column headers. Windows 10 My column C which I hid last week now won't unhide.But now when it comes to unhide these columns, there are few complications. The format command on the home tab of the ribbon doesn’t let you unhide worksheet. And Excel 2011 for Mac: From the main menu > select format option > sheet > unhide. Or you can click the first column header, hold Shift, and click the last column header in the range. Excel 2003 and earlier: Select Format > Sheet > and Unhide. To select multiple adjacent columns, drag through them.To select a single column, click the column header.When the Unhide window appears, select the sheet that you wish to unhide. To unhide a sheet, simply right-click on the name of any sheet and select Unhide from the popup menu. And, you can select the columns you want to hide in a few different ways. Answer: You can view all of the sheet names as tabs along the bottom of the document.

How to unhide a column in excel mac