The Easiest Way to Hide And Unhide Columns In Excel
Sometimes, you may have a whole column in Excel that you don’t want to see – or maybe the whole column is visible, but it’s not what you’re looking for. Regardless of why you’d want to hide a column in Excel, it’s a surprisingly easy thing to do. In this article, we’ll learn how to either hide individual columns or all of them and also how to unhide them as well!
What is a Hidden Column?
A hidden column is a column that is not visible in the spreadsheet. You can hide a cell by entering Ctrl+9 or Ctrl+Shift+( in keyboard.
How To Hide Columns in Excel
If you need to hide a column in Excel and you don’t want to use the filters or disguise features, there is an easy way to do it. Just highlight the column that you want to hide and then press the F2 key.
Excel will display a dialog box asking if you want to hide the column or not. Simply click on the “Yes” button and the column will be hidden.
If you need to unhide the column later, just highlight the column again and press F2. Excel will display a dialog box asking if you want to unhide the column or not. Simply click on the “No” button and the column will be visible.
Unhide Columns Using a Keyboard Shortcut
The key combination for unhiding columns is Ctrl+Shift+0.
- Type the cell reference A1 into the Name Box.
- Press the Enter key on the keyboard to select the hidden column.
- Press and hold down the Ctrl and the Shift keys on the keyboard.
- Press and release the 0 key without releasing the Ctrl and Shift keys.
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.
If you need to hide a column in Excel, there is an easy way to do it. To hide a column, go to the column that you want to hide, and then click the “hide” button. This will hide the column from view, and you can’t see it unless you select it and show its contents again. To unhide a column, simply click the “show” button for that column.
Tips and Tricks for Hiding Columns in Excel
If you need to hide a column in Excel, there are a few simple steps you can take. Firstly, select the column you want to hide. Next, click the Columns tab and select Hide from the menu. Finally, select OK to apply the change.
If you need to unhide a column, follow the same steps above, but choose Unhide from the Columns tab menu.
Conclusion
Have you ever had a column in your spreadsheet that you wanted to hide but couldn’t because it was always visible? Well, here is the easiest way to hide and unhide columns in Excel. This tip will work with both Mac and PC versions of Excel. Just follow these simple steps: 1) Select the column you want to hide or show 2) Click on the little arrow next to the row number for the column you want 3) Choose “Hide” or “Show All” from the menu that pops up 4) Viola! The column is now hidden or shown.
Also Read: 7 most popular excel tips to learn