If you want to hide or unhide columns in Microsoft Excel, there are a few ways to do it. Here are three methods: Method 1: Use the Format Cells command. This command will change the formatting of all cells in a row or column, including the cell that contains the column name. To hide a column, use this command: Format Cells(1) = “N/A”; Method 2: Use the Group By command. This command will group all cells in a row or column together and then use the Group By function to select only those cells that have been group by. To hide a column, use this command: Group By(column_name) = “N/A”; Method 3: Use the Filter button on the ribbon. This button will allow you to filter out specific data from your spreadsheet. To hide a column, use this button: Filter(column_name) = “N/A”;
Just because you have a spreadsheet full of data doesn’t mean you want to see it all at once. You can hide columns in Microsoft Excel that you don’t need at the moment. Then simply unhide them when you’re ready.
Hide Columns in Microsoft Excel
Hiding columns in Excel is super easy. And, you can select the columns you want to hide in a few different ways.
To select a single column, click the column header. To select multiple adjacent columns, drag through them. Or you can click the first column header, hold Shift, and click the last column header in the range. To select multiple non-adjacent columns, click the first column header, hold Ctrl, and click the remaining column headers.
Once you choose the columns you want to hide, they’ll be highlighted. Right-click one of them and pick “Hide” in the shortcut menu.
After you hide columns in Excel, you’ll see a thick white line indicator between the remaining column headers. If you’re using a Mac, this indicator may appear as a bold green line. This is a good thing to keep in mind if you’re looking for data you don’t see.
If you’d like to keep certain columns on screen while you scroll through your spreadsheet, learn how to freeze columns and rows in Excel.
RELATED: How to Freeze and Unfreeze Rows and Columns in Excel
Unhide Columns in Microsoft Excel
When you’re ready to view those hidden columns, unhiding them is just as simple as hiding them. Select the columns on each side of the hidden column(s). You can do this easily by dragging through them. Then, right-click and pick “Unhide” in the shortcut menu.
Another way to unhide columns is by double-clicking the line indicator for the hidden columns.
Keep in mind that you can hide rows in Excel the same way as hiding columns. And if you have an older version of the application, the process is the same, but the appearance differs. Take a look at the screenshots in our how-to for hiding and unhiding rows and columns in Excel 2013.
