Excel batch unhide row and column operation graphic tutorial

 

There are two ways to unhide rows and columns in excel in batches. You only need to perform a simple operation, as shown below.

General solution

1. Drag and select all columns with hidden columns, right-click the menu, and choose unhide.

2. Drag and select all rows with hidden rows, right-click the menu and choose unhide.

Quick Solution

Click the Select All button in the upper left corner, press ctrl + shift, press 9 first, and then press 0

The above section summarizes all the operations for hiding columns and rows in the excel list. I hope this article will help you.