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 WidthColumn Using Column WidthA user can set the width of a column in an excel worksheet between 0 and 255, where one character width equals one unit. The column width for a new excel sheet is 8.43 characters, which is equal to 64 pixels.read more
  4. Hide Column using VBA CodeVBA CodeVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more

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.

Emp IDFirst NameLast NameFull NameGenderAgeDepartment
00001SnehaKumariSneha KumariFemale25Sales
00002SonamGuptaSonam GuptaFemale28Sales
00003VijayKumarVijay KumarMale35Support
00004VaibhavBansalVaibhav BansalMale45Product Development
00005ManojBhardwajManoj BhardwajMale38Operations
00006DiwakarGaurDiwakar GaurMale39Sales
00007ShaketBihariShaket BihariMale46Support
00008SumitDasSumit DasMale25Operations

Following are the steps used to hide columns using right click-

  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

  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

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

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