How to Hide Columns Without Right Click in Excel (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

In terms of using Microsoft Excel, we can keep unnecessary or confidential data hidden. We can even hide the entire data. While hiding the entire column or row, we need to click on the Hide option after right clicking on the mouse. I am going to explain 3 very fascinating ways to hide columns in Excel without right click.

For more explanation, I am going to use a dataset of personal information of a company decorated in the Employee ID, Name, Department, and State columns.

Table of Contents hide

Download Practice Workbook

3 Fascinating Ways to Hide Columns Without Right Click in Excel

1. Using Keyboard Shortcut to Hide Columns

2. Hide Columns by Applying Hide & Unhide Feature

3. Using VBA to Hide Columns Without Right Click

Practice Section

Conclusion

Download Practice Workbook

Hide Columns Without Right Click.xlsm

3 Fascinating Ways to Hide Columns Without Right Click in Excel

1. Using Keyboard Shortcut to Hide Columns

Keyboard Shortcut is the simplest way to hide columns without right-click. You just need to follow the following instructions.

Steps:

First of all, select the columns that you want to hide. I have selected here columns B and F to hide.
Then, press CTRL + 0 to hide the columns.

Thus, we can simply hide the columns using the keyboard shortcut.

Similar Readings

2. Hide Columns by Applying Hide & Unhide Feature

We can also use the Hide & Unhide feature from the Home tab to hide multiple columns.

Steps:

Select the columns first that you want to hide. I have selected here the B and D columns to hide.
Then, go to the Home tab.
Choose Format from the ribbon.
Next, click on the Hide & Unhide feature.
Finally, click on the Hide Columns option

This is how we can simply hide the selected columns.

3. Using VBA to Hide Columns Without Right Click

Visual Basic for Applications (VBA) is the most advanced way to hide columns without right-clicking on the mouse.

Steps:

Go to the Developer tab.
Then, click on Visual Basic from the ribbon.

Double click on the Worksheet name to have the space for writing VBA Code.

Now, input your VBA Code.

Sub Obscure_the_Columns()
    Columns("E:F").Hidden = True
End Sub

Here, I have the Sub_procedure named Obscure_the_columns. I have mentioned the Columns.Hidden property to hide columns E and F.

Press F5 or the Run button to run the code.

Thus, we can have hidden the columns without right-click.

Practice Section

For more expertise, you can practice here.

Conclusion

That’s all for the article. In this article, I have tried to elaborate on 3 very fascinating ways to hide columns in Excel without right click. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.