Excel Sheet Unhide All Columns

If you want to unhide all hidden columns on an excel spreadsheet click on the select all button which is the blank rectangle to the left of column a and above row 1 you can then proceed with the remaining steps in this article to unhide those columns.

Excel sheet unhide all columns. In this picture column a and row 1 are hidden. Select the columns before and after the hidden columns like columns c and f in our example. Now navigate to the review tab and click on the protect sheet icon. To unhide row 1 right click the row 2 header or label and pick unhide rows.

To see the hidden data unhide those columns or rows. Click the home tab. Select hide unhide on the menu. Kutools for excel s unhide all hidden sheets feature could help you display all of the hidden sheets easily with only one click.

To unhide one or more columns highlight at least one cell in the columns on either side of the hidden column s with the mouse pointer. A quick way to do this is to click the select all button at the top left corner of the worksheet. Select them right click and pick the hide option from the pop up menu. To unhide all columns click and drag with the mouse to highlight columns a to g.

Sub unhide allcolumns activesheet cells entirecolumn hidden false end sub this small macro will unhide all the hidden columns in your active worksheet. The excel add in professor excel tools provide a function for unhiding all hidden rows and columns on all sheets with one click. Whether your data is in a range or a table here s how to unhide columns or rows. To use the function click on hidden rows and columns in the professor excel ribbon.

Alternatively only unhide the rows or columns on the selected or current sheet. Unhide columns in excel using a macro. Kutools for excel includes more than 300 handy tools for excel. A menu will expand.

Click the format button in the cells section of the toolbar. For example you want to unhide columns b d and f. When you see the format cells window navigate to the protection tab and tick the locked checkbox. These double lines mean that some columns and rows are hidden.

The secret to unhiding column a in an excel worksheet by susan harkins in microsoft office in software on march 15 2009 5 00 pm pst after you hide column a it might seem like it s gone forever. If you want to unhide your spreadsheet columns by using a code then you can use the following macro for this task. If you don t see the first column column a or row row 1 in your worksheet it might be hidden. Click kutools show hide unhide all hidden sheets see screenshot.

Click ok to save the changes. To unhide column a right click the column b header or label and pick unhide columns. Select all data in the worksheet. Here s how to unhide it.