How to Hide Multiple Columns in Excel (5 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

You might want to hide multiple columns in Microsoft Excel to conceal personal or perplexing data. We can easily hide multiple columns in Excel by using the keyboard shortcuts, Mouse Right-Click, Format command, and VBA Macros. In this article, we’ll learn five quick and suitable ways to hide multiple columns in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


5 Suitable Ways to Hide Multiple Columns in Excel

Let’s say, we have a dataset that contains information about 12 different students of ABC School. The Name of the students and ID of those students and their marks in Physics, Chemistry, and Mathematics are given in Columns B, C, D, E, and F respectively. We might hide rows and columns in Excel using the keyboard shortcuts, Mouse Right-Click, Format command, and VBA Macros also. Here’s an overview of the dataset for today’s task.

hide multiple columns in excel


1. Keyboard Shortcuts to Hide Multiple Columns in Excel

To hide multiple columns in Excel by using keyboard shortcuts is the easiest way. From our dataset, we will hide marks in Physics, and Chemistry that has been given in columns D, and E respectively. Let’s follow the instructions below to hide multiple columns!

Steps:

  • First, select columns D, and E that contain marks in Physics, and Chemistry.

Perform Keyboard Shortcuts to Hide Multiple Columns in Excel

  • Hence, press Ctrl + 0 simultaneously on your keyboard.
  • As a result, you will be able to hide columns D, and E that have been given in the below screenshot.

Read More: How to Hide and Unhide Columns in Excel (7 Quick Methods)


2. Use Mouse to Hide Multiple Columns in Excel

Another easiest way is to hide multiple columns in Excel by using the mouse Right-Click. Now, we will hide the columns containing the Physics and Mathematics information. Please follow the steps below to learn!

Steps:

  • First, select columns D, and F.

Use Mouse to Hide Multiple Columns in Excel

  • After that, place your cursor upon any selected columns, and press right-click on your mouse.
  • Then, a window will appear in front of you.
  • From that window select the Hide option.

Use Mouse to Hide Multiple Columns in Excel

Read More: Excel Hide Columns Based on Cell Value without Macro


Similar Readings


3. Apply Format Command to Hide Multiple Columns in Excel

To hide multiple columns, we will apply the Format command. This is the easiest and time-saving way in Excel. Now, we will hide the columns that contain the information on Physics and Chemistry. Please follow the steps below to learn!

Steps:

  • First, select columns D, and E.

Apply Format command to Hide Multiple Columns in Excel

  • Hence, from your Home ribbon, go to,

Home → Cells → Format → Hide & Unhide → Hide Columns

Apply Format command to Hide Multiple Columns in Excel

Read More: How to Hide Columns with Button in Excel (4 Suitable Methods)


4. Use Group Feature to Hide Multiple Columns

In this method, we’ll learn how to hide multiple columns in Excel by using the Group feature. From our dataset, we will hide the columns that contain the information on Identification Number, Physics, and Chemistry. Please follow the instructions below to learn!

Step 1:

  • First, select columns C to E.

Use Group Feature to Hide Multiple Columns in Excel

  • After that, from your Data ribbon, go to,

Data → Outline → Group → Group

Step 2:

  • Hence, a Group dialog box will appear in front of you.
  • From the Group window, firstly select Columns.
  • At last, press OK.

Use Group Feature to Hide Multiple Columns in Excel

  • Further, the Minus(-) sign will appear on the top-most side of the columns.
  • After that, press on the Minus(-) sign like the below screenshot to hide columns.

Use Group Feature to Hide Multiple Columns in Excel

  • Finally, you will get your desired output that has been given below screenshot.

Use Group Feature to Hide Multiple Columns in Excel

Read More: How to Hide Columns in Excel with Minus or Plus Sign (2 Quick Ways)


5. Run Excel VBA Code to Hide Multiple Columns

Last but not the least, I’ll show how to hide multiple columns in Excel by using a simple VBA code. It’s very helpful for some particular moments and a time-saving way also. From our dataset, we will hide multiple columns. Let’s follow the instructions below to hide multiple columns!

Step 1:

  • First of all, select cells C4 to E16.

Run Excel VBA Code to Hide Multiple Columns in Excel

  • Hence, open a Module.
  • To do that, firstly, from your Developer tab, go to,

Developer → Visual Basic

  • After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Hide Multiple Columns will instantly appear in front of you.
  • From that window, we will insert a module for applying our VBA code.
  • To do that, go to,

Insert → Module

Run Excel VBA Code to Hide Multiple Columns in Excel

Step 2:

  • Then, type the VBA code in the created Module.
Sub Hide_Multiple_Columns_VBA()
Columns("C:E").Hidden = True
End Sub

  • Further, we run the code, to do that, go to,

Run → Run Sub/UserForm

Run Excel VBA Code to Hide Multiple Columns in Excel

Step 3:

  • Thereafter, run the code and the output will be like the following.

Run Excel VBA Code to Hide Multiple Columns in Excel

Read More: Excel VBA to Hide Columns Based on Criteria (6 Useful Examples)


Things to Remember

↪  If the Developer Menu does not appear in the Menu  Bar, press ALT + F11 keys on your keyboard to open the Microsoft Visual Basic for Applications window.


Conclusion

I hope all of the suitable methods mentioned above to hide multiple columns will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo