How To Unhide All Rows And Columns In Microsoft Excel Or Google Sheets

Determining whether or not or not an Excel spreadsheet comprises hidden rows or columns is pretty easy: Search for a double line between the 2 sections (usually you may solely see one), or if the sections are labeled with letters, search for gaps within the order (i.e. A, B, D, F, and many others). If you happen to do have hidden areas to disclose:

1. Choose the rows or columns on both aspect (or above and beneath) the hidden ones — maintain Shift and click on every part one after the other to pick multiples.
2. Proper-click the chosen sections to open a drop-down menu.
3. Click on Unhide from the drop-down menu to disclose all hidden sections in-between those you’ve got chosen.
4. Alternatively, double-click the double line that signifies a hidden row or column to disclose it instantly.

The revealed columns or rows will stay seen in your spreadsheet except you choose to cover them once more (or shut with out saving). They may also seem in printouts so long as they’re seen.