How to Hide and Unhide Columns and Rows in Excel

– Unhide Columns and Rows in Excel – 

Get to know 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.

Unhide Columns and Rows in Excel

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

‣ To unhide all hidden rows in Excel, navigate to the “Home” tab.

‣ Click “Format,” which is on the right-hand side of the toolbar.

‣ Navigate to the “Visibility” section. You’ll find options to hide and unhide both rows and columns.

‣ Hover over “Hide & Unhide.”

‣ 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 hide or unhide rows or columns with plus or minus signs in Excel.

‣ Select the entire rows or columns you need to hide or unhide with a plus or minus sign, then click Group in the Outline group under the Data tab. See screenshot:

‣ Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns.

‣ Click the minus sign. The selected rows or columns are hidden immediately. And click the Plus sign. The hidden rows or columns are shown at once.

We hope this article has been helpful to you. Please share it with anyone you think will appreciate the information and kindly drop your comment below.

Similar Posts

Leave a Reply

Your email address will not be published.