How to Hide Columns in Excel

Written by Nicole Levine, MFA

Last Updated: May 15, 2018 Tested

This wikiHow teaches you how to hide an entire column in Microsoft Excel.

Steps

1
Double-click your spreadsheet to open it in Excel.
- If Excel is already open, you can open your spreadsheet by pressing Ctrl+O (Windows) or ⌘ Cmd+O (macOS) and then selecting the file.
2
Click the letter above the column you want to hide. This selects the entire column.
- For example, to select the first column (column A), click the A at the top of the column.
- If you want to hide multiple columns at once, press Ctrl as you click additional column letters.
3
Click View. It’s at the top of the screen as either a button or tab.
- If you don’t see this option, you can right-click anywhere on the selected column(s) instead. This makes a pop-up menu appear.
4
Click Hide. It’s in the toolbar at the top of the screen, near the center. The selected columns are now hidden.
- If you right-clicked the selected area, click Hide in the pop-up menu.

You Might Also Like

About This Article

Written by:

Nicole Levine, MFA

Tech Specialist

This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 24,222 times.

How helpful is this?

Co-authors: 1

Updated: May 15, 2018

Views: 24,222

Categories: Microsoft Excel

Article SummaryX

1. Open your spreadsheet.
2. Click the column letter.
3. Click View.
4. Click Hide.

Did this summary help you?