How Excel Bulk cancels rows and columns hiding

The general approach:

1. Drag to select all column areas with hidden columns, right-click menu-Unhide

2. Drag to select all row areas with hidden rows, right-click menu-Unhide

The quickest way:

Click the Select All button in the upper left corner, press CTRL + Shift not loose, press 9 and then press the 0 key

Evaluation:

The 1th method, if the table area is large, drag selection is time-consuming, and both rows and columns need to be manipulated. Relative to the 2nd method, click, press 2 times to complete the key.