With the entire spreadsheet selected, right click and select unhide.Select the entire spreadsheet by clicking in the gray rectangle in the upper left corner of the spreadsheet.If you have several hidden columns and/or rows and want to unhide all columns and rows in the entire spreadsheet simply:
#How unhide first column in excel how to
See Also: How to Add in Excel How to Unhide All Columns and Rows in Excel When the columns that surround the hidden column are selected, right click.Continue to hold down the mouse key and drag the cursor to the column header to the right of the missing column.Click on the column header to the left of the hidden column.
Now that you know how to hide columns, how do you get them back? What if you receive an excel file from someone and you notice that some columns are hidden? How do you view the hidden columns? See Also: How to create a Password Keeper in Excel (with a Free Template) How to Unhide Columns in Excel Where’s “H”? That column is hidden in this Excel spreadsheet. For example, in the spreadsheet below we see column A, B, C, D, E, F, G and then I. See Also: Excel 101, An Introduction to Excel Basics How to Know if a Column is Hidden in ExcelĪn easy way to see if a column is hidden in Excel is to scan across the column headers and see if any letters are missing.