43+ How To Hide & Unhide Column In Excel Trending. Press ctrl + space to select the entire column of selected cells. Select the columns to the left and right of the hidden column.
Now navigate to the review tab and click on the protect. Press the shortcut “alt h o u l.” press one key at a time. You can do this easily by dragging through them.
Select Any Cell In The Column Next To The Hidden Column.
This will open the macro window, where you will find the names of all the macros that you have created so far. Now, press the 0 (zero) key without releasing the ctrl key. Press shift + → (right arrow key) to select the column numbers on both sides of the hidden column.
For Example, To Select The First Column (Column A), Click The A.
This looks like the first method, but it is good to know all the methods to become a master. In format choose hide & unhide in visibility. Click on one of the highlighted columns and select the format cells… option again.;
Click On Format > Hide & Unhide > Unhide Columns.
The column width dialog box will appear. If you don’t see the first column (column a) or row (row 1) in your worksheet, it might be hidden. This selects the entire column.
Click Ok To Save The Changes.;
When you see the format cells window, navigate to the protection tab and tick the locked checkbox.; Once you click on the unhide column, column a will be unhidden. You should see all the columns marked with an x in row 8 hidden (columns b and d).
Now Column A Will Not Appear On The Screen.
Press the shortcut “alt h o u l.” press one key at a time. You can then click the mouse pointer on any cell in the worksheet to deselect the columns. In hide & unhide select hide columns.
