Removing blank rows at end

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
 
G

Gord Dibben

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
 
S

ShaneDevenshire

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)
 
R

Richard Fangnail

 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.
 
G

Gord Dibben

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
 
Top