Hide Unused Rows and Columns : Make your worksheet look neat

Hide Unused Rows and Columns  Make your worksheet look neat

Hide Unused Rows and Columns Make your worksheet look neat

Hide Unused Rows and Columns : Make your worksheet look neat

Most Excel worksheets use only a very tiny portion of work area (10,48,576 Columns & 16,384 Rows). It may be useful to hide the area that you aren’t using to keep from scrolling off the edge of your work area.

1) Select a cell in a row beneath the work area of your worksheet.
2) While holding down the CTRL + SHIFT keys press the down arrow on your keyboard. This will select a range of cells from the cell you selected down to the last row of the worksheet (i.e. row 10,48,576).
3) Right click on selected area, Select “Hide” option from menu

3) Next, select a cell in a column to the right of the work area of your worksheet.
4) While holding down the CTRL + SHIFT keys press the right arrow on your keyboard. This will select a range of cells from the cell you selected over to the last column on the far-right side of your worksheet (i.e. Column XFD).
3) Right click on selected area, Select “Hide” option from menu

Bonus Tip: To adjust the row heights or column widths without unhiding the other rows and columns, select only the visible row or column headings first. If you “Select All” and adjust the column width or row height, it unhide the previously hidden rows or columns.

No Responses

Show all responses

Write a response