How to Hide and Unhide Columns and Rows in Excel

How to Hide and Unhide Columns and Rows in Excel.

How to Hide and Unhide Columns and Rows in Excel: You can easily hide columns when working within an Excel spreadsheet and just as easily unhide them. Keep reading if you want to continue.

If you want to prevent users from wandering into parts of a worksheet you don’t want them to see, then hide such rows from their view.

This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information.

Excel is great for sorting large amounts of data, whether it involves alphabetizing, adding, or merging cells.

While organizing this data, you may find it helpful to hide columns you are no longer using, but don’t want to delete from your document.

You can hide, and later unhide, columns by right-clicking in the spreadsheet. You can also achieve this by using the drop-down menu in the Home tab.

READ ALSO:

Methods to Hide or Unhide Columns and Rows

To hide a row:

  • Select the row (or a cell in the row) you want to hide.
  • On the Home tab, in the Cells group, click Format.
  • In the Format submenu, click Hide & Unhide.
  • Choose Hide Rows.

To hide a column:

  • Select the column (or a cell in the column) you want to hide.
  • On the Home tab, in the Cells group, click Format.
  • In the Format submenu, click Hide & Unhide.
  • Choose Hide Columns.

To unhide a row:

  • Select the rows (or cells in the rows) above and below the hidden row.
  • On the Home tab, in the Cells group, click Format.
  • In the Format submenu, click Hide & Unhide.
  • Choose Unhide Rows.

To unhide a column:

  • Select the columns (or cells in the columns) to the left and right of the hidden column.
  • On the Home tab, in the Cells group, click Format.
  • In the Format submenu, click Hide & Unhide.
  • Choose Unhide Columns.
  • Also, see using Data validation in Excel.

How to Unhide All Rows in Excel

  1. To unhide all hidden rows in Excel, navigate to the “Home” tab.
  2. Click “Format,” which is located towards the right-hand side of the toolbar.
  3. Navigate to the “Visibility” section. You’ll find options to hide and unhide both rows and columns.
  4. Hover over “Hide & Unhide.”
  5. Select “Unhide Rows” from the list. This will reveal all hidden rows, a feature especially helpful if you’ve hidden multiple rows throughout a large spreadsheet.

Hide Rows Using the Ribbon

If you enjoy working with the ribbon, you can hide rows in this way:

  • Go to the Home tab > Cells group, and click the Format button.
  • Under Visibility, point to Hide & Unhide, and then select Hide Rows.
  • Alternatively, you can click Home tab >Format > Row Height… and type 0 in the Row Height box.
  • Either way, the selected rows will be hidden from view straight away.

Hide/Unhide Rows Or Columns With Plus Or Minus Sign

Please do as follows to hide or unhide rows or columns with plus or minus sign in Excel.

  1. Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. See screenshot:
  2. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns.
  3. Click the minus sign, the selected rows or column are hidden immediately. And click the Plus sign, the hidden rows or columns are showing at once.

Add a Comment

Your email address will not be published. Required fields are marked *