Buzz
Do you need to hide specific columns in your spreadsheet? Concealing columns in Excel is a fantastic way to enhance data readability, particularly when printing. We’ll walk you through the process of hiding columns in Microsoft Excel and how to reveal them later.
Steps
Double-click the spreadsheet to open it in Excel.
- If Excel is already open, you can access your spreadsheet by pressing Ctrl + O (on Windows) or Cmd + O (on macOS), then selecting the file.
Click the letter above the column you want to hide. This action will select the entire column.
- For example, to select the first column (column A), click the letter A at the top of the column.
- If you want to hide multiple columns at once, click and drag your cursor over the letters of the columns you wish to hide.
- You can also select non-adjacent columns by holding down Ctrl while clicking each column letter.
Right-click on the selected column(s). A menu will appear.
- If you don’t have a multi-button mouse, hold down the Ctrl key while clicking on the column(s).
Click Hide in the menu. The selected columns will now be hidden.
Unhide columns (optional). To reveal hidden columns, simply click on any column adjacent to the hidden ones to select them, then choose Unhide.
