How to Hide Columns in Excel

How to hide columns in excel

In this short tutorial, we’re gonna have a look at how to hide columns in an Excel spreadsheet – simple and easy! Thanks to this, you’ll be able to hide information you don’t want to share in the table.

Hope you’re ready to begin!

See the video tutorial and transcription below: 

See this video on YouTube: 
https://www.youtube.com/watch?v=xN7Mmg8A3P8

There are more ways to hide a column or columns in a spreadsheet. Here, I’ll introduce two of them.

Let’s crack on with the first one!

The First Way How to Hide Columns in Exel

First, highlight the column you’d like to hide. This can be done through a click on the bar of letters, selecting the relevant column. If you wish to hide more columns at once, press the Shift key and click on each of the columns you want to hide. If the columns you want to hide are not consecutive, which means they do not lie next to each other, use the Ctrl key instead of Shift.

How to hide columns in excel - selected columns

Once you’ve selected all the necessary columns, use the right-click button to see the Hide option.

How to hide columns in excel - hide option

The hidden columns are not visible in the table on the screen. They also won’t be printed out if you were to do so with the spreadsheet. But they’ve not been deleted! You can ‘unhide’ them anytime.

How to hide columns in excel - hidden columns

Alright! Let’s undo the changes now and let’s have a look at the other way to hide columns, too.

The Other Way How to Hide Columns in Exel

Select the columns again, this time by dragging, then go to Home tab, Cells section (or group), use Format button to get to the Format menu. Find Hide & Unhide option and select Hide Columns.

How to hide columns in excel - more ways how to hide columns 1

And the work’s done!

Are you wondering:

If you’ve found this video helpful, like us and subscribe to receive more videos from EasyClick Academy. Learn more from tutorials that help you use Excel quick and easy!

See you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.