How to Hide and Unhide Columns in Excel
This guide provides a step-by-step process for hiding and unhiding columns in Excel. By following these instructions, users can easily manipulate their data and customize their spreadsheets to their liking. Whether you need to temporarily remove certain columns or bring them back into view, this guide will help you navigate Excel's formatting options efficiently.
Lynette Amador
|
5 steps
|
30 seconds
1
To begin, open your workbook in Excel.
Hiding Columns
2
Click the Column Header you want to hide.
3
In the Home tab, click "Format" to open a drop down menu.\ Under "Visibility," hover over "Hide & Unhide" then click "Hide Columns."
Unhiding Columns
4
Click the Select All cell in the top left of the spreadsheet.
5
In the Home tab, click "Format" to open a drop down menu. Under "Visibility," hover over "Hide & Unhide" then click "Unhide Columns"