Removing blank rows at end

  • Thread starter Thread starter Richard Fangnail
  • Start date Start date
R

Richard Fangnail

I have a sheet which had 600 rows of content but then I changed it so
that it only has 100 rows of content. But it still scrolls down to
row 600. How can I totally eliminated the unneeded rows now?

It does have cell borders on, if that matters.

Thanks
 
Did you save the workbook after deleting(not clearing contents) the extra
rows and columns?

In older versions you had to save, close and re-open to see changes.


Gord Dibben MS Excel MVP
 
Hi,

I haven't read the instructions you said didn't work but here's the way:

1. Select row number 101 (assuming you want all rows below 100 to be
cleared)
2. Press Ctrl+Shift+Down Arrow (this highlights to the bottom of the
worksheet.)
3. Press Ctrl+- (ctrl + minus) (shortcut key for Edit, Delete)
4. Press Ctrl S (shortcut key for Save)
 
 Hi,

I haven't read the instructions you said didn't work but here's the way:

1.  Select row number 101     (assuming you want all rows below 100to be
cleared)
2.  Press Ctrl+Shift+Down Arrow  (this highlights to the bottom of the
worksheet.)
3.  Press Ctrl+-  (ctrl + minus)    (shortcut key for Edit, Delete)
4.  Press Ctrl S            (shortcut key for Save)
Click to expand...


Yes, but the extra blank rows are still at the end.
 
They will always be there.

You cannot delete the rows, you can only reduce the usedrange that Excel
estimated.

Where does CTRL + End take you after following the instructions?


Gord
 
Back
Top