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.
- First, choose one or more columns, and then press Ctrl to confirm extra columns that aren’t touching.
- Second, right-click the chosen columns, and then press Hide.
Note: The double line between two columns indicates that you’ve hidden a column.
- Firstly, select the adjacent columns for the hidden columns.
- Next, right-click the selected columns. After this, select Unhide.
Alternatively, double-click the double line between the two columns where hidden columns exist.