Skip to main content

Microsoft Excel: Unhide all rows and columns

Unhide all hidden rows and columns at the same time
Apply to: Microsoft Excel 2010, Microsoft Excel 2013

Select all cells on a worksheet: Press CTRL + A
On the Home tab, in the Cells group, click Format.
Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns.

Microsoft Excel: Unhide Rows and Columns
Microsoft Excel: Unhide Rows and Columns

Popular posts from this blog

Docker: Commonly Used Commands

Repeat to remember Remember to repeat

Data Recovery Softwares

Follow 3-2-1 backup rule so you do not need these data recovery softwares.

Windows 10: Install SuSE Linux Enterprise - SLES

With Microsoft-Windows-Subsystem-Linux feature enabled, we can install Linux distributions on Windows 10.