Make data analysis easy in Excel by hiding columns
Complex spreadsheets can be hard to navigate when you want to check or compare the data in columns. Simplify the process by hiding irrelevant columns using this process:
Select the column you would like to Hide and then right click.
After you click on Hide and you’ll see the column disappear leaving a green line so you can see where the hidden columns are located. You can hide multiple columns at a time by highlighting more than one column at a time. Or select them individually.
To Unhide the column, click on the line indicating a hidden column and then select Unhide.