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-clicking.

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.

How to Hide Columns in Excel Without Right Click


How to Hide Columns Without Right Click in Excel: 3 Easy Ways

1. Using Keyboard Shortcut to Hide Columns

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

Steps:

  • First of all, select the columns that you want to hide. I have selected 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.

How to Hide Columns in Excel Without Right Click

Read More: How to Hide Columns with Button in Excel


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. Here I have selected 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.

How to Hide Columns in Excel Without Right Click

Read More: Hide Columns with No Data in Excel


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.

How to Hide Columns in Excel Without Right Click

  • 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 hide the columns without right-click.

How to Hide Columns in Excel Without Right Click

Read More: How to Hide and Unhide Columns in Excel


Practice Section

For more expertise, you can practice here.


Download Practice Workbook


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-clicking. 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. 


Related Articles


<< Go Back to Hide Columns | Columns in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo