Hiding a Column in Excel

How to Hide Columns in Excel? (Using Top 4 Methods)

Below mentioned are the top 4 methods that can easily help you to hide the columns in excel

  1. Hide Column using Right Click Option
  2. Hide Column using Shortcut Cut Key
  3. Hide Column using Column Width
  4. Hide Column using VBA Code

Now let us discuss each of the methods in detail along with an example –

#1 Hide Columns using Right Click

In the below-displayed worksheet, in Employee Data, We need to hide the B and C column as it consists of First and Last Name individually, and we have concatenated (merged) the names in the D column, and we want only that to be displayed.

Unhide Column

  • Step 1: We need to click on B (Column Label) with the mouse (when we move the pointer to the label of the columns that gets converted to the downward arrow) and then while pressing Ctrl+Shift, we need to press ‘Right Arrow Key‘ also to select the right-side column (C).

Unhide Column step 1

  • Step 2: Right-click to open the context menu and then choose the ‘Hide.’

Unhide Column step 2

#2 Hide Column in Excel using Shortcut Key (CTRL+0)

  • For example, Select Column B and C (Ctrl+Spacebar could also be used to select a column) and use the Shortcut key Ctrl + 0 (Zero) to hide a column in excel.

Hide Column Shortcut - (Cntrl + 0)

#3 Hide Column in Excel using Column Width

  • Select column B and C, right-click to open the context menu, and then choose ‘Column Width’ and specify the width to be ‘0’.

Hide Column using Column Width

#4 Hide Column in Excel using VBA

  • Step 1: On the Developer tab, click on ‘Visual Basic’ to open the window for writing VBA Code

 Unhide Column step 3

  • Step 2: After double clicking on the ‘Sheet 1’, Click on ‘Insert’ Menu->‘Procedure’->Specify the procedure name and paste the following code: Worksheets(“Sheet1”).Columns(“C”).Hidden = True
  • Step 3: Before clicking on ‘Run’ Menu->Run Sub/User Form, Save the file with .xlsm extension as this is for ‘Macro-Enabled Workbook.’

 Unhide Column step 4

  • Step 4: After hiding column B and C, the sheet will look like as below. There is ‘Double Line’ between A and D as column B and C is hidden between them.

Unhide Column step 8

Recommended Articles

This has been a guide to hiding columns in excel. Here we discuss the top 4 methods to hide columns in excel, including right-click, shortcut (CTRL+0), column width, and VBA Code. You can learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion