How to hide columns in Excel ?
|
Excel
|
5 months ago
|
Excel
6 Steps
This document will teach you how to hide columns in Excel. Hiding columns is a great way to declutter your spreadsheet and focus on the information that is most important to you. We will show you two different ways to hide columns in Excel: using the right-click menu and using the ribbon. We will also show you how to unhide columns if you need to.
How to hide columns in Excel ?
|
Excel
|
Excel
6 Steps
1
Start your Microsoft Excel and open the workbook containing the sheet where you want to hide columns.
2
Click on the lettered "Header" of the column you want to hide.
The column header is the labeled area at the top of each column (e.g., B, C,D). Selecting the header select the entire column.
3
Click on the "Home" tab in the Excel ribbon at the top of the window.
This tab contains many common tools and options for formatting and editing.
4
Click on the "Format" button in the "Cells" group.
A dropdown menu will appear with various cell formatting options.
5
Hover over or click on "Hide & Unhide" in the dropdown menu and Click on "Hide Columns" from the submenu.
6
Now, the selected "Columns" will be hidden.
By following these steps you can hide columns in Excel
