Hide and show columns and rows in Excel

Content
  1. Learn a few ways to do it
  2. Using data in hidden columns and rows
  3. Hide Columns in Excel with Shortcut Key
  4. Hide columns using the context menu
  5. Hide one column
  6. Hide Adjacent Columns
  7. Hide individual columns
  8. Hide and show columns in Excel with name field
  9. Show columns with hotkey
  10. Show columns with context menu
  11. Hide rows with keyboard shortcuts
  12. Hide rows using the context menu
  13. Hide one line
  14. Hide adjacent rows
  15. Hide individual lines
  16. Hide and show rows using the name field
  17. Display strings with hotkey
  18. Display strings with keyboard shortcuts and name field
  19. Display strings with hotkey
  20. Show rows with context menu

Learn a few ways to do it

You can hide columns and rows in Excel to make your spreadsheet more organized without removing data you’ll need later. However, you cannot hide individual cells. As with all Microsoft programs, there are several ways to perform a task.

The instructions below cover three ways to hide and show columns and rows in an Excel worksheet:

  • Using keyboard shortcuts

  • Using the right-click context menu

  • Using formatting options on tab ribbons.

These instructions apply to Excel 2019, 2016, 2013, 2010, 2007, and Excel for Office 365.

Using data in hidden columns and rows

Hiding columns and rows that contain data doesn’t delete the data and you can still reference it in formulas and charts. Hidden formulas that contain cell references are updated when the data in the referenced cells changes.

Hide Columns in Excel with Shortcut Key

Shortcut to hide columns:

 Ctrl + 0 
  1. Click to the cell in the column you want to hide to make it active.

  2. Press and hold key ctrl on keyboard.
  3. press and release key 0 without letting go of the key ctrl .
  4. The column with the active cell should be hidden from view.

To hide multiple columns using a keyboard shortcut, select at least one cell in each column you want to hide, then repeat step two and three above.

Hide columns using the context menu

The options available in the context menu or the shortcut menu vary depending on the object selected when the menu was opened. If the parameter Hide as shown in the image below, is not available in the context menu, most likely you did not select the whole column before right clicking.

Hide one column

  1. Click column header the column you want to hide to select the entire column.

  2. Right click in the selected column to open the context menu.
  3. Select Hide .

  4. The selected column, the column letter and all data in the column are hidden from view.

Hide Adjacent Columns

  1. V column header Click and sleep mouse pointer to select all three columns.

  2. Right click on the selected columns.
  3. Select Hide .

  4. The selected columns and column letters are hidden from view.

Hide individual columns

  1. V column header Click on the first column to be hidden.

  2. Press and hold a key ctrl on keyboard.

  3. Continue hold down a key ctrl and click once on each additional column to hide it to select them.

  4. Release the key ctrl .

  5. V column header Click right click on one of the selected columns.

  6. Select Hide .

  7. The selected columns and column letters are hidden from view.

When hiding individual columns, if the mouse pointer is not over the column header when the right mouse button is pressed, the hide option is not available.

Hide and show columns in Excel with name field

This method can be used to display a single column. In our example we use column A .

  1. Enter cell clutch A1 in the field name .

  2. Press key Enter on the keyboard to select a hidden column.

  3. Press House tab on the adhesive tape .

  4. Click Format icon on the adhesive tape to open the drop-down list.

  5. In the Visibility section of the menu, select Hide and show > Hide columns or Show column .

Show columns with hotkey

Shortcut for displaying columns:

 Ctrl + Shift + 0 
  1. Enter cell clutch A1 in the field name .

  2. Press key Enter on the keyboard to select a hidden column.

  3. Press and hold keys ctrl and Shift on keyboard.

  4. Press and release the button 0 without letting go of the keys Ctrl and Shift .

To display one or more columns, use the mouse pointer to select at least one cell in the columns on either side of the hidden columns. For example, you want to show columns B, D and F :

  1. To display all columns, Click and drag use mouse to mark columns A to G .

  2. Press and hold keys ctrl and Shift on keyboard.

  3. Press and release the button 0 without letting go of the keys ctrl and Shift .

  4. Hidden columns are visible.

The Ctrl + Shift + 0 keyboard shortcut may not work depending on the version of Windows you are using, for reasons not explained by Microsoft. If this shortcut doesn’t work, use another method from the article.

Show columns with context menu

Similar to the shortcut method above, you must select at least one column on either side of a hidden column or columns to display them.

For example, to display columns D, E, and G:

  1. float mouse pointer to column C in the column header.
  2. Click and drag use mouse to mark columns C to H to display all columns at once.
  3. Right click on the selected columns.
  4. Select Show .

  5. Hidden columns are visible.

Hide rows with keyboard shortcuts

Shortcut to hide rows:

 Ctrl + 9 
  1. Click the cell in the row you want to hide to make it active.

  2. Press and hold key ctrl on keyboard.
  3. press and release key 9 without letting go of the key ctrl .
  4. The row containing the active cell should be hidden from view.

To hide multiple rows with a keyboard shortcut, highlight at least one cell in each row you want to hide and then repeat two steps and three . above.

Hide rows using the context menu

The options available in the context menu – or right-clicking – vary depending on the object selected when you open it. If the parameter Hide as shown in the image above, is not available in the context menu, this is because you probably did not select the entire row.

Hide one line

  1. Click the header of the row to be hidden to select the entire row.

  2. Right click on the selected line to open the context menu.
  3. Select Hide .

  4. The selected string, the letter of the string, and all data in the string are hidden from view.

Hide adjacent rows

  1. Click and drag in the row header to select all three rows.

  2. Right click on the selected lines.
  3. Select Hide.

  4. The selected rows are hidden from view.

Hide individual lines

  1. In the row header, click the first row to be hidden.

  2. Press and hold while holding down the key ctrl on keyboard.

  3. Keep holding the key ctrl and click once on each additional row to hide it to highlight them.

  4. Right click on one of the selected lines.
  5. Select Hide .

  6. The selected rows are hidden from view.

Hide and show rows using the name field

This method can be used to display a single line. In our example we use line 1 .

  1. Enter cell clutch A1 in the field Name .

  2. Press key Enter on the keyboard to select the hidden row.

  3. Press tab “Home” on the adhesive tape .

  4. Click Format icon on the adhesive tape to open the drop-down menu.

  5. In the Visibility section of the menu, select Hide and show > Hide rows or Show line.

Display strings with hotkey

Shortcut for displaying strings:

 Ctrl + Shift + 9 

Display strings with keyboard shortcuts and name field

  1. Enter link to cell A1 in the field Name .

  2. Click key Enter on the keyboard to select the hidden row.

  3. Press and hold keys ctrl and Shift on keyboard.

  4. Click and release the number key 9 without letting go of the keys ctrl and Shift .

  5. Line 1 will become visible.

Display strings with hotkey

To display one or more rows, use the mouse pointer to select at least one cell in the rows on either side of the hidden rows.

For example, you want to display: lines 2, 4, and 6 .

  1. To display all rules, Click and drag use mouse to mark lines 1 to 7 .

  2. Press and hold keys ctrl and Shift on keyboard.

  3. Press and release a number key 9 without letting go of the keys ctrl and Shift .

  4. The hidden row(s) become visible.

Show rows with context menu

Similar to the shortcut method above, you must select at least one row on either side of a hidden row or row to display them.

For example, to display: lines 3, 4 and 6 :

  1. float mouse pointer to line 2 in the control head.
  2. Click and drag to select lines 2-7 to display all rows at once.

  3. Right click on the selected lines.
  4. Select Show .

  5. The hidden row(s) become visible.

Leave a Reply

Your email address will not be published.