The article today “Hide and unhide rows in Excel” is just a quick introduction to hide and unhide rows. The first section covers how to hide and show a continuous series of rows. There are several methods, but we keep it to one and a series of rows this time.

In addition is there attached a Excel spreadsheet to the article. The reason for this is to have a learning by doing session. The importance of this is the knowledge that it is easier to learn by trying. Therefore do the learning exercise witch is to hide and unhide January since it is not used.

4. After that should you move the mouse cursor over the last row number to hide and click on it with use of the left mouse button.
5. Right click then with the mouse either on the row numbers selected or inside the boundaries of the selected fields.
6. Select then [Hide] in the pop-up menu.
7. All rows selected should then be hidden.

4. Press and hold [Shift], select row 36 by clicking on the row number. Release [Shift] and all rows are selected.
5. Place the cursor anywhere between row 5 and row 36 inside the frame of the selected rows.
6. Right click with the mouse and select [Hide] in the pop-up menu.
7. All rows containing January should now be hidden.

3. Press and hold [Shift], select thereafter row 37 with the mouse. Row 37 should be next after row 4 (row 5 to 36 was hidden above).
4. Move the cursor inside the selected fields frame.
5. Right click with the mouse and select [Unhide] from the pop-up menu.
6. Your rows should now be visible again.

The step-by-step guide above to just unhide selected data row are quite complex. But Excel do have a faster way if you are sure that all hidden rows are to be shown.

One function that certainly is handy to know is how to move entire rows or columns in Excel. Easily done by drag and drop to the new position.

Stop fussing around when there is need to reorder rows or columns. Use our quick and neat method to drag and drop rows or columns.