How to Unhide Multiple Hidden Rows or Columns at Once in Excel

How to Unhide Multiple Hidden Rows or Columns at Once in Excel

If you have hidden multiple rows or columns in Excel and want to unhide them, you can do it individually, but using a method to unhide them all at once is more efficient. This article explains how to unhide hidden rows or columns in bulk.

Steps to Unhide

The most basic method involves using mouse operations to unhide the hidden sections.

Procedure

1. Select the rows or columns that include the hidden sections.
   This refers to the row numbers (1, 2, 3) or column letters (A, B, C).
2. Right-click on the selected range.
3. From the menu, choose “Unhide.”

Result

All hidden rows or columns within the selected range will be unhidden.

Additional Notes

• To accurately select hidden sections, drag between the row numbers or column letters that indicate hidden areas.

Points to Note

• If there are many hidden rows or columns and you want to unhide them all, using Ctrl+A to select everything and then unhiding can save time and improve efficiency.