If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the row headers), then column B and everything to its left, including the hidden column A, are selected. Choose Column from the Format menu, then choose Unhide.Īnother way to display the first column is to click on the header for column B, and then drag the mouse to the left.Cell A1 is now selected, even though you cannot see it on the screen. In the Reference field at the bottom of the dialog box, enter A1.
Choose Go To from the Edit menu, or press F5.To unhide the left-most columns of a worksheet when they are hidden, follow these steps: If you later want to unhide column A, the solution isn't so obvious. For instance, if you hide column A, Excel will dutifully follow out your instructions. What isn't so easy is displaying a hidden column if that column is the left-most column in the worksheet.
Unhide first column in excel 2003 how to#
Here in this example, hidden Columns are Column B and Column C.Īn animation about how to unhide hidden Columns in Excel worksheet is copied below.Īnother method to achieve the same result described above is to select left-side and right-side Columns of the hidden Columns and then run command "Unhide Columns" from Excel Ribbon > "Home" Tab > "Cells" Group > "Format" > "Hide & Unhide", as shown in below image.Excel makes it easy to hide and unhide columns. You can see from below image that the hidden Columns between Column A and Column D are unhidden. Left-side and right-side Columns of the hidden Columns are Column A and Column D. In this example, Columns B and C are hidden. After selecting left-side and right-side Columns of the hidden Columns, right-click on selected Columns and select "Unhide" from the context menu. To unhide hidden Columns, select left-side and right-side Columns of the hidden Columns. How to unhide hidden Columns in Excel worksheet
That means, Column B and Column C are hidden.Īn animation about how to hide Columns in Excel worksheet is copied below.Īnother method to achieve the same result described above is to select the Columns you want to hide first and then run command "Hide Columns" from Excel Ribbon > "Home" Tab > "Cells" Group > "Format" > "Hide & Unhide", as shown in below image. The skipped Column letters between Column A and Column D are hidden. You can see from below images that the selected Columns in above example are hidden.Ī double-line between Column letter A and Column letter D shows that there are Columns hidden between those Columns.
After selecting the Columns, right-click on the selected Columns and click "Hide" from the context menu as shown below. To hide Columns from Excel worksheet, first select the Columns which you want to hide. Hiding Columns from Excel worksheet is very useful if you do not want to display some Columns of Excel worksheet containing sensitive/unwanted information to other users or if you do not want some Columns of sensitive/unwanted information appear in Excel worksheet's printouts. After you hid Columns from Excel worksheet, the hidden Columns are not printed. You can hide a Column or a Range of Columns from Excel worksheet. Sometimes you may want to hide some sensitive or unwanted columns from your Excel worksheet.