Excel Hide Shortcut

Updated on December 27, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Hide Shortcut in Excel

When the data is large, or the summary table includes a drill-down summary, we choose to group the columns and rows so that, if required, we can expand or collapse things to dig deep. However, in certain cases, we cannot group rows or columns. Rather, we need to hide those rows and columns, so this task is often regular for regular excel users, so maintaining an efficient way of doing this is very important. This article will show you how to hide rows and columns in Excel, using the shortcut keys to work efficiently.

Hiding Rows and Columns in Excel

Excel has rows and columnsExcel Has Rows And ColumnsA cell is the intersection of rows and columns. Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell.read more so that we can hide these two things apart from hiding worksheets. In the end, we will also show you how to hide worksheets.

In a worksheet containing data, we need first to decide what the row is and the column we need to hide accordingly; we can hide those rows and columns. We have several methods to hide rows and columns. First, let us show you a manual way of hiding rows and columns in Excel.

For example, look at the below data table.

Shortcut for Hide Example 1

Assume we need to hide a column in excelHide A Column In ExcelThe methods to hide columns in excel are - hide columns using right-click option, hide columns using shortcut cut key, hide columns using column width, hide columns using VBA code.read more “E,”  then first we need to select the column to hide the column.

Shortcut for Hide Example 1-1

Now, go to the “Home” tab and click on the “Format” option.

Home tab- Format Option

Now, we can see many different “Format” options. For example, under “Visibility,” choose “Hide & Unhide,” and then select “Hide Columns.”

Shortcut for Hide (Hide columns)

Now, it will hide the selected column.

Shortcut for Hide (Hidden E column)

Similarly, we must first choose the row we wish to hide for rows, then follow the same steps and select “Hide Rows” instead of “Hide Columns.”

Shortcut for Hide (Hide rows)

This option looks lengthy. Going through all the above steps is frustrating, but we have next-level options. First, we need to hide after selecting the column. Click on that column header and choose the “Hide” option.

Shortcut for Hide (Hide through right click)

Consequently, it will hide the selected Excel column.

Shortcut for Hide (Hidden E column)

Now, assume we need to hide row number 5, select that row and right-click.

Shortcut for Hide (Hide row through right click)

Now, it will hide the selected row.

Shortcut for Hide (No Row)

This option looks much better.

We will show you an even quicker Excel option by using shortcut keys.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Hide Rows & Columns Using Shortcut Keys in Excel

A shortcut is very important to save time, and hiding rows and columns is no different either. Of course, we need to select the row or column in earlier cases before choosing the hide option, but we need not do all of these using excel shortcutsExcel ShortcutsAn Excel shortcut is a technique of performing a manual task in a quicker way.read more, we need not do all these.

The shortcut keys to hide rows and columns in Excel are as below.

To Hide Excel Column: “Ctrl + 0”

Shortcut for hide Column

To Hide Excel Row: “Ctrl + 9”

shortcut for hide Row

We need to keep in mind that we should press 0 and 9 from keyboard numbers, not from the keyboard’s number pad.

Onscreen keyboard

Now we know about Excel shortcut keys.

Assume we need to hide column “D,” so select any of the cells in this column first.

Select cell D

We have selected cell D3. Now hold the Ctrl key and press 0. As soon as we press the shortcut key, column “D” is hidden.

Shortcut for Hide (column D)

Now assume we need to hide row number 5, so select any of the cells in this row.

Select row no 5

We have selected a C5 cell, so row number 5 is active now by holding the Ctrl key press number 9 from keyboard numbers.

hide row

Here we can see the overview of rows and columns.

Shortcut for Hide (Column and row hidden)

We have seen how to use shortcut keys effectively now, assuming we need to hide multiple rows and columns which are not in continuous rows or columns.

Hide Multiple Rows and Columns in Excel

For example, if we need to hide columns “E” and “F,” we can select these continuous columns and hide them. Similarly, if we want to hide rows 5 and 6, we can choose these endless rows and hide them if we are going to hide column “E,” column “B,” column “G,” and rows like row number “4”, row number “6”, row number 2 we need to use a different strategy.

Let us select one cell in each column that we need to hide.

hide row

Note: Hold the “Ctrl” key and select each cell in the respective columns to select multiple cells.

We have selected B3, E3, and G3 cells in the above image. After selecting the cells, press the shortcut key Ctrl + 0.

Hide multiple column

As we can see above, all the selected cell columns are hidden.

Similarly, select row numbers.

Shortcut for Hide (Hide multiple row)

We have chosen A2, A4, and A6 cells. Now press Ctrl + 9 to hide selected cell rows.

Shortcut for Hide (hide rows shortcut)

There you go, the shortcut key has hidden rows of selected Excel cells.

Things to Remember

  • We should press numerical values 0 and 9 from keyboard numbers, not from a separate number pad of the keyboard.
  • In the case of multiple rows and columns hiding, we must select respective rows and columns cells and then use the shortcut key to hide.

This article has been a guide to Excel hide shortcuts. Here, we discuss how to hide rows and columns in Excel using the shortcut keys to work easily, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –