Unhide Columns In Excel 2011 How To Unhide Columns

Hold down the Shift key while you click the letter above the column to the left and then the column to the right of the hidden column.

The columns will be highlighted when you successfully select them.

For example, if column B is hidden, you should click A and then C while holding down Shift.; If you want to unhide column A, select.

This control over what can be seen or not can be helpful in hiding content such as: Content that needs to be used in a formula, but need not be visible Content that.

This will open a popup menu, select the unhide option and the hidden columns will be visible.

Now you should be able to see column A in your Excel spreadsheet.

Unhide Columns In Excel 2011 How To Unhide Columns

Whether your data is in a range or a table, heres how to unhide columns or rows: Select the columns before and after the hidden columns (like.

This is the easiest way to unhide columns in Excel: Open the Excel document that has hidden columns in it.

If the hidden column is D then select Column C and E on both sides while.

Press the Enter key on the keyboard to select the hidden column.

Unhide Columns In Excel 2011 For Mac