Hide or show rows or columns

In Excel, you can hide or show rows and columns to make your worksheet more organized and streamline your data presentation. Here’s how to do it:

1. Hide Rows or Columns

Hide a Single Row or Column:

1. Select the Row or Column:
   • To hide a row, click the row number on the left side of the worksheet.
   • To hide a column, click the column letter at the top of the worksheet.
2. Right-Click to Hide:
   • Right-click the selected row number or column letter.
   • Choose Hide from the context menu.

Hide Multiple Rows or Columns:

1. Select Multiple Rows or Columns:
   • To hide multiple rows, click and drag over the row numbers to select them.
   • To hide multiple columns, click and drag over the column letters to select them.
2. Right-Click to Hide:
   • Right-click the selected rows or columns.
   • Choose Hide from the context menu.

Hide a Range of Rows or Columns Using the Ribbon:

1. Select the Rows or Columns you want to hide.
2. Go to the Home tab on the ribbon.
3. In the Cells group, click the Format dropdown.
4. Under Visibility, choose Hide & Unhide, then select Hide Rows or Hide Columns.

2. Show Hidden Rows or Columns

Show a Single Hidden Row or Column:

1. Select the Rows or Columns Around the Hidden Ones:
   • For hidden rows, select the row numbers above and below the hidden row.
   • For hidden columns, select the columns to the left and right of the hidden column.
2. Right-Click to Unhide:
   • Right-click the selected rows or columns.
   • Choose Unhide from the context menu.

Show Multiple Hidden Rows or Columns:

1. Select the Rows or Columns Around the Hidden Ones.
2. Right-Click the selection and choose Unhide.

Show Hidden Rows or Columns Using the Ribbon:

1. Select the Rows or Columns Around the Hidden Ones.
2. Go to the Home tab on the ribbon.
3. In the Cells group, click the Format dropdown.
4. Under Visibility, choose Hide & Unhide, then select Unhide Rows or Unhide Columns.

3. Keyboard Shortcuts for Hiding/Unhiding Rows or Columns:

• Hide Rows: Select the rows and press Ctrl + 9 (Windows) or Command + 9 (Mac).
• Hide Columns: Select the columns and press Ctrl + 0 (Windows) or Command + 0 (Mac).
• Unhide Rows: Select the rows surrounding the hidden ones, then press Ctrl + Shift + 9 (Windows) or Command + Shift + 9 (Mac).
• Unhide Columns: Select the columns surrounding the hidden ones, then press Ctrl + Shift + 0 (Windows) or Command + Shift + 0 (Mac).

Tips:

• Hidden rows and columns are not deleted, they are just not visible. The data in them remains intact and can be accessed later.
• You can hide rows or columns to focus on specific data or to prevent the accidental modification of certain data while working.

By hiding or showing rows and columns in Excel, you can make your worksheets cleaner and more manageable while focusing on the most relevant data.