How to Hide Columns in Excel: 7 Methods Every User Should Know

Method 1: The Keyboard Shortcut (Fastest)

Shortcut: Ctrl + 0 (Windows) or Command + 0 (Mac)

This is the quickest way to hide a column in Excel. The following steps explain how:

1. Click any cell in the column to be hidden, or click the column header at the top to select the entire column.

2. Press the control key together with the key on Windows, or Cmd + 0 on Mac.

3. The column disappears immediately.

To hide several adjacent columns in one shot, click the first column letter, hold the Shift key, then click the last column letter to highlight a range. Pressing the key combination once hides all of them together. The same shortcut works for a single column or for multiple columns at the same time.

A common trip-up: pressing Ctrl + Shift + 0 used to be the keyboard shortcut for unhiding columns, but Microsoft disabled it on most Windows installations because it conflicted with a system shortcut that switches keyboard layouts. Unhiding usually requires the right-click menu or the ribbon instead.

Method 2: Right-Click Context Menu

The right-click method is the most discoverable option, which is why so many tutorials lead with it. It also happens to be the easiest one to remember without practice. The following steps work on any version of Microsoft Excel:

1. Click the column header at the top of the first column to select the entire column. The cursor should turn into a small black down-arrow before clicking.
2. Right-click anywhere inside the highlighted column.
3. Select Hide from the context menu that appears.

To hide multiple columns, select them first by clicking and dragging across the column headers for adjacent columns, or hold ctrl while clicking individual column letters to select non-adjacent columns. Right-clicking and choosing Hide will hide multiple columns at once.

This approach works identically in Excel for the web, though the right-click menu in browsers occasionally takes a second longer to load.

Method 3: The Home Tab Ribbon

The ribbon method is helpful when working on a touchscreen or when keyboard shortcuts aren't available, such as when using a stylus on a Surface or a tablet running Excel.

1. Select the column or columns to hide by clicking the column letter(s).

2. Go to the Home tab in the ribbon.

3. Click Format in the Cells group (toward the right side of the ribbon, near Format Cells).

4. Hover over Hide & Unhide.
5. Click Hide Columns.

The same submenu also includes Hide Rows, Hide Sheet, Unhide Columns, Unhide Rows, and Unhide Sheet. Bookmarking this menu mentally is useful because it consolidates every visibility-related action for both rows and columns in one place.

Method 4: Hiding Non-Adjacent Columns

Hiding one or more columns that aren't side by side, such as columns B, D, and F while leaving columns C and E visible, is a frequent request when sanitizing reports for external sharing. The trick is selecting numerous columns at once before applying the hide command.

1. Click the column header for the first column to hide (column B).

2. Hold the control key (or Cmd on Mac) and click each additional column letter (D and F).

3. With all three columns selected, right-click any of the highlighted column letters and choose Hide Columns, or press Ctrl + 0.

All selected columns will be hidden simultaneously. This trick to hide non adjacent columns saves significant time compared to hiding each one individually, particularly when working with wide spreadsheets that contain dozens of helper columns.

Method 5: Hide Columns Using the Name Box

The Name Box is the small input field to the left of the formula bar. It can target a single column or a range directly without the user needing to scroll across the spreadsheet.

1. Click inside the Name Box.
2. Type the column reference, such as H:H for the first column to target, or H:K to capture columns H through K (where K becomes the last column in the selection).
3. Press Enter.
4. Press Ctrl + 0 or right-click and choose Hide.

This method shines when working with spreadsheets that scroll past column ZZ. Typing AB:AB and pressing Enter is faster than scrolling sideways through a hundred columns to find the right header letter.

Method 6: Group Columns for Collapsible Hiding

The grouping feature is the better choice when columns need to be hidden temporarily and toggled back into view often. It adds a small + or − button above the column headers, allowing anyone to expand or collapse the group with a single click.

1. Select the columns to group.

2. Go to the Data tab.

3. Click the Group button in the Outline section.

4. A bracket appears above the selected columns with a − button to collapse them and a + to expand.

Grouped columns behave like hidden columns when collapsed, but they also leave a clear visual indicator that something is collapsed, which prevents the common confusion of colleagues wondering why letters skip from C to G in the column header row. Groups can also be nested, allowing detailed and summary views of the same data set. The same grouping feature also works to group rows, which is handy for collapsing repeated detail blocks in financial models.

To remove a group, select the columns and click Ungroup on the Data tab.

Method 7: VBA Macro for Repeatable Hiding

Spreadsheets that get updated weekly often have the same set of helper columns that need to be hidden before sending out a clean version. Recording a macro removes that chore entirely. The following steps show how to create one:

1. Press Alt + F11 to open the Visual Basic Editor.

2. Click Insert > Module.
3. Paste the following code:

Sub HideHelperColumns()
    Columns("H:K").EntireColumn.Hidden = True
    Columns("Q:R").EntireColumn.Hidden = True
End Sub

Sub HideHelperColumns()
    Columns("H:K").EntireColumn.Hidden = True
    Columns("Q:R").EntireColumn.Hidden = True
End Sub

Sub HideHelperColumns()
    Columns("H:K").EntireColumn.Hidden = True
    Columns("Q:R").EntireColumn.Hidden = True
End Sub

1. Close the editor and assign the macro to a button or keyboard shortcut.

To unhide, simply change True to False in the relevant line and run the macro again, or create a separate ShowHelperColumns macro that does the reverse. The macro can be saved in the Personal Macro Workbook so it runs across every spreadsheet on the same computer.

Note: Files containing macros must be saved as .XLSM rather than .XLSX. Saving as the standard format will strip the macro out without warning.

How to Unhide Columns in Excel

Hiding is only half of the workflow. Here are three reliable ways to bring hidden columns back. The same logic applies to unhide rows: simply substitute "row" for "column" in each method.

Method A: Select adjacent columns and unhide. Click the column letter to the left of the hidden range, hold the Shift key, and click the column letter to the right. Right-click the selection and select Unhide.

Method B: Select all columns. Press Ctrl + A to select the entire sheet, right-click any column letter, and choose Unhide Columns. Every hidden column reappears at once.

Method C: Use the ribbon. Select the surrounding columns, go to Home > Format > Hide & Unhide > Unhide Columns.

How to Unhide Column A (The Tricky One)

Column A is a special case because there is no column to its left. The standard "select adjacent columns" trick fails because only column B can be selected.

The reliable fix:

1. Click inside the Name Box to the left of the formula bar.

2. Type A1 and press Enter. The cell is now selected even though the column is hidden.
3. Go to Home > Format > Hide & Unhide > Unhide Columns.

Column A will reappear immediately. The same trick works for any single hidden column where selecting both neighbors is awkward.

What About Rows? Same Methods, Different Direction

Microsoft Excel makes hiding rows in Excel just as simple as hiding columns. Every technique above works the same way for the row direction. The keyboard shortcut to hide rows is Ctrl + 9, and the right-click menu shows a Hide option whenever a full row is selected by clicking its row number on the left edge of the worksheet. The ribbon path is identical: Home > Format > Hide & Unhide > Hide Rows or Unhide Rows.

To quickly hide rows in bulk, select multiple row numbers using the Shift key for adjacent rows or the control key for non-adjacent ones, then apply any of the methods above. The grouping feature also supports group rows through the same Data tab button, with collapse brackets appearing on the left side of the worksheet rather than above the header.

In short, anything that works for one direction works for the other. Knowing both directions doubles the value of every shortcut already memorized for managing rows and columns.

Common Issues and Troubleshooting

When to Hide vs. Delete vs. Group

Choosing the right approach depends on what happens to the spreadsheet next. The table below summarizes the decision:

| Goal | Best Method | | --- | --- | | Temporarily declutter a view | Hide or use the grouping feature | | Permanently remove confidential data | Delete the columns | | Allow viewers to expand/collapse on demand | Group | | Hide intermediate calculations referenced by formulas | Hide (deleting breaks formulas) | | Sanitize a spreadsheet before sending to other users | Delete plus Inspect Document |

A frequent mistake is hiding columns that contain sensitive information before sending the file outside a company. Hidden does not mean removed. Anyone with basic Excel knowledge can unhide every column in under five seconds. Any genuinely confidential data should be deleted before the file leaves the building, or a sanitized copy should be exported.

For Developers: Hiding Columns Programmatically with IronXL

For teams that generate Excel files from .NET applications, hiding columns by hand isn't practical. A weekly export of 500 customer reports needs to hide the same internal columns every time, automatically. IronXL is a C# library from the team at Iron Software that handles the job in a few lines of code. It runs on .NET without requiring Microsoft Office or Excel to be installed on the server.

using IronXL;
WorkBook workbook = WorkBook.Load("report.xlsx");
WorkSheet sheet = workbook.WorkSheets.First();
// Hide a single column (column C)
sheet.GetColumn(2).Hidden = true;
// Hide a range of columns (columns H through K)
for (int i = 7; i <= 10; i++)
{
    sheet.GetColumn(i).Hidden = true;
}
workbook.SaveAs("report-cleaned.xlsx");

using IronXL;
WorkBook workbook = WorkBook.Load("report.xlsx");
WorkSheet sheet = workbook.WorkSheets.First();
// Hide a single column (column C)
sheet.GetColumn(2).Hidden = true;
// Hide a range of columns (columns H through K)
for (int i = 7; i <= 10; i++)
{
    sheet.GetColumn(i).Hidden = true;
}
workbook.SaveAs("report-cleaned.xlsx");

Imports IronXL

Dim workbook As WorkBook = WorkBook.Load("report.xlsx")
Dim sheet As WorkSheet = workbook.WorkSheets.First()
' Hide a single column (column C)
sheet.GetColumn(2).Hidden = True
' Hide a range of columns (columns H through K)
For i As Integer = 7 To 10
    sheet.GetColumn(i).Hidden = True
Next
workbook.SaveAs("report-cleaned.xlsx")

The same library reads, edits, and saves .XLSX, .XLS, and .CSV files, supports formulas and styling, and works in console apps, web APIs, and desktop applications. Server-side spreadsheet generation pipelines that previously required Interop or third-party plugins can usually be migrated to IronXL with minimal rewriting.

Final Thoughts

Hiding columns in Excel is one of those tasks that seems trivial until a deadline hits and the keyboard shortcut suddenly stops working, or column A vanishes and refuses to come back. This post has covered every realistic situation: the Ctrl + 0 key combination for speed, the right-click context menu for clarity, the grouping feature for collapsible views, the Name Box trick for column A, and a small VBA macro for repeatable cleanups. Each of these several ways to hide and unhide columns exists for a reason, and knowing which one to reach for in a given moment is what separates an Excel user who finishes the report on time from one who's still hunting through menus.

For automation at scale, the IronXL library gives developers the same column-hiding capability through a clean .NET API, with no Office dependency required. More walkthroughs and code samples are available on the Iron Software documentation site.