This guide is going to show you how to hide more than one column in your Excel spreadsheet.
- Open your file in Excel.
- Hold down the Ctrl key on your keyboard.
- Click the column letter of the first column you wish to hide.
- Click additional column letters to select them, then release the Ctrl key when you’re done.
- Right-click one of the selected column letters, then choose the Hide option.
Microsoft Excel for Office 365 gives you the ability to hide more than one column at a time. This is helpful if you are trying to consolidate your data to make it easier for readers to understand, but you don’t want to delete that data.
Our guide below is going to show you how to use the Hide functionality in Microsoft Excel for Office 365 so that you can hide more than one column at a time.
Can I Hide More than One Column at a Time in Excel?
The steps in this article were performed in Microsoft Excel for Office 365, but will work in most other versions of Excel as well.
Step 1: Open the Excel file containing the columns you want to hide.
Step 2: Hold down the Ctrl key on your keyboard, then click the column letter of the first column you want to hide.
Step 3: Continue holding down the Ctrl key, then click the column letters of other columns you want to hide.
Step 4: Right-click one of the selected column letters, then choose the Hide option.
Note that you can also quickly select multiple columns that are next to one another by clicking the leftmost letter of the column you want to hide, holding down the Shift key, then clicking the rightmost letter of the column you want to hide.
Find out how to remove borders in Excel if you currently have borders but don’t want them.
Matt has been writing about Microsoft Windows and other Microsoft products since the days of Windows XP. He spends much of his time writing for sites like WindowBrain.com