Hide or show rows or columns

With Excel, you have the option to hide or show rows or columns which enables you to display only the essential data to view or print.


Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac.

Hide columns

  1. First, choose one or more columns, and then press Ctrl to confirm extra columns that aren’t touching.
  1. Second, right-click the chosen columns, and then press Hide.

Note: The double line between two columns indicates that you’ve hidden a column.

Unhide columns

  1. Firstly, select the adjacent columns for the hidden columns.
  1. Next, right-click the selected columns. After this, select Unhide.

Alternatively, double-click the double line between the two columns where hidden columns exist.

Leave a Reply

%d bloggers like this: