Hide rows or columns
In Excel, a row or column can hide/ unhide among other rows or columns, for this, do the following steps:
1- Select a column to hide.
- Press Ctrl + 0 (Zero).
- Click Right and press Hide.
To show the hidden column, do the following steps:
1- Select either side of hidden column.
- Click Right and press Unhide.
To show all hide rows or columns, to the following to select data:
- Click the Select All Or
After selecting, do the same as learned before in this article.
Note: For rows, same steps will be followed after selection of a pertinent row.