How do I hide all unused rows in Excel? I hate that if I scroll to fast I do not stop at the end of the data.
I am running Excel 15.
Here is an example. I want every row after 263
hidden so when I scroll down the data scrolling stops at 263
. I also want every column after E
hidden.
Best Answer
Taken from this article on TekReview
Make sure to leave room for expansion, if necessary.
Shift
key and then pressCommand + Right Arrow
. This will jump you to the end of the spreadsheet while theShift
key automatically selects every cell in between.Format > Column > Hide
. You’ll now see all the cells to the right of your data disappear.Shift
and then pressCommand + Down Arrow
. This will jump you to the very bottom of the spreadsheet and select all the rows in between.Format > Row > Hide
. You’re now left with a spreadsheet that features only cells containing your data, resulting in a much cleaner look.If you need to expand your table, or simply don’t like the new look, you can easily unhide the cells. First, click the top-left heading cell that looks like a white arrow pointing to the bottom-right corner. Clicking this cell will select all cells in your spreadsheet, both hidden and not. Once selected, go to Excel’s Menu Bar and choose both
Format > Column > Unhide
andFormat > Row > Unhide
. Your spreadsheet will now be restored to the default look.