Hide or Unhide a Row or Column in Excel
If you didn't know that in Excel there is a possibility that the Row or Column you do invisible ie. Hiding Rows (Row) and Columns (Column).
When would you like to Hide (make invisible) one Row or Column it is necessary to select the Row or Column, then click the 'HOME tab', in the 'Cells group' choose the command Format = > Hide & Unhide = > Hide Rows/Columns.
For the Unhide of Hidden Row or Column it is necessary to select two adjacent visible row or column, and then choose the command Format = > Hide & Unhide = > Unhide Rows/Columns.
You can get these commands from the pop-up menu, so that the selected rows or columns by clicking the right mouse button and then click the Hide/Unhide commands men .
If you want to select multiple adjacent rows, select the rows or columns by stretching the left mouse (on a drag-and-drop) from the first row to the last desired (or click on the first row, press the SHIFT key and hold it and then click on the last row). How to select Multiple a Rows or Columns, take a look at the respective link.
If you want to select only certain nonadjacent rows or columns, then click on the name of the (ordinal number or letter) of the first row/column, it select and then press the CTRL key, keep it well continue with clicking by following the desired rows/columns. Please see image below.
Hidden Rows and Columns in Excel
After successfully completed the actions you have hidden rows and columns as in the picture below.
Note: Never do not select the rows and columns at once, because you will not get the desired result. First select or highlight Rows and hide them, after this then select the columns to hide them well.
When you want to display (Unhide or Visible) a Column or Row, you need to select the first adjacent Row or Column before hidden Rows and the first following the Row or Column behind a Hidden Row or Column. Then you click the right mouse button on the selection, location and then select a command to Unhide.
Hiding and Unhiding nonadjacent rows in Excel
If you want to Unhide (make visible) more nonadjacent hidden Rows, select the according to the above mentioned hidden Rows or the range, and then click the right mouse button on a number of the selected Row. From the pop-up menu, click the Unhide that Invisible Rows do Visible.
Hide all the Rows and Columns on the Worksheet, Excel
If you want to Hide all the Rows and Columns in an Excel Worksheet, then select all of the Rows and Columns by clicking on Row headers/column my date in the upper left corner (bellow the NameBox) well then, use the Hide command from the pop-up menu. See image below.