How to Hide Columns in Excel - Compute Expert

How to Hide Columns in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Hide Columns in Excel





In this tutorial, you will learn how to hide columns in excel completely.

When working on our data tables in excel, we might sometimes need to hide some particular columns we have in them. We may want to make our data tables look leaner or we may want to hide our data processing columns.

There are several methods we can use if we want to hide columns in excel. If you have mastered them, you should be able to make your columns hidden easily!

Want to learn those methods you can use to hide columns in excel? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Learn Excel Dashboard Course






How to Hide Columns in Excel 1: Format Button

First of all, let us learn how to hide columns in excel by using the button that excel provides in its ribbon. Here are the step-by-step to implement this first method.

  1. Highlight the column you want to hide by clicking on its letter note on the top

    How to Hide Columns in Excel - Screenshot of Step 1, Format Button Method

  2. Go to the Home tab in your Excel ribbon and click the Format button there

    How to Hide Columns in Excel - Screenshot of Step 2, Format Button Method

  3. Highlight Hide & Unhide in the Format button dropdown list and choose Hide Columns

    How to Hide Columns in Excel - Screenshot of Step 3, Format Button Method

  4. Done!

    How to Hide Columns in Excel - Screenshot of Step 4, Format Button Method




How to Hide Columns in Excel 2: Right-Click

Another method we can use to hide columns in excel is by using right-click. Here are the steps if you want to implement this method instead.

  1. Highlight the column you want to hide by clicking on its letter note on the top

    How to Hide Columns in Excel - Screenshot of Step 1, Right-Click Method

  2. Right-click on the highlighted column and click Hide

    How to Hide Columns in Excel - Screenshot of Step 2, Right-Click Method

  3. Done!

    How to Hide Columns in Excel - Screenshot of Step 3, Right-Click Method






How to Hide Columns in Excel 3: Shortcut Buttons

You can also hide columns in excel without needing to use a mouse or touchpad. Here is the way to do it.

  1. Move your cell cursor until it is in the column you want to hide

    How to Hide Columns in Excel - Screenshot of Step 1, Shortcut Method

  2. Press Ctrl + Space (Control + Space in Mac) buttons on your keyboard

    How to Hide Columns in Excel - Screenshot of Step 2, Shortcut Method

  3. Press Ctrl + 0 (Control + 0 in Mac) buttons on your keyboard
  4. Done!

    How to Hide Columns in Excel - Screenshot of Step 4, Shortcut Method




How to Hide Multiple Columns in Excel

The steps we discuss in those methods above seem to only be applicable if we want to hide just one column at a time.

What about if we want to hide multiple columns at the same time? Well, we just need to highlight multiple columns before we hide the columns.

To highlight multiple adjacent columns, click the most left/right column letter note of the adjacent columns. Then, press and hold the Shift button while clicking the most right/left column letter note of the adjacent columns.

You can also just click and drag on column letter notes until you have highlighted all the adjacent columns you want to highlight. Another way is to highlight the most left/right column of the adjacent columns and press the right/left directional button while holding the Shift button. Do that until you have highlighted all the adjacent columns you want.

The result should be like this.

How to Hide Columns in Excel - Screenshot of an Example of the Result of Highlighting Multiple Adjacent Columns

If you want to hide multiple non-adjacent columns, hold the Ctrl (Command in Mac) button while clicking on the columns letter notes you want to highlight. The result should be like this.

How to Hide Columns in Excel - Screenshot of an Example of the Result of Highlighting Multiple Non-Adjacent Columns

Then, you just need to implement the steps from the three methods above after you highlight the columns you want to hide. You should be able to hide multiple columns at once by doing that!



Exercise

After you have learned how to hide columns in excel, let’s do a simple exercise. This is so you can understand better the lessons you have learned.

Open an excel file you have and try to hide the columns it has by using the three methods we have discusses above. What is the result? Can you do it?

If you still can’t hide the columns, read again the steps we have provided for you!



Additional Note

If you have large data tables in excel, then hiding columns in them can be handy.

You can show only the columns you want to show at the moment and hide the rest. That way, you don’t have to skim through your data tables just to see each of the columns you want.



Related tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Learn Excel Dashboard Course

Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Things

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2024 Compute Expert