Remove extra rows in Spreadsheet

[Gary]

I have an 2003 excel spreadsheet. I would like to reduce the number of rows
which my stroll bar would see. For a next sheet, I can get this. Once I
sroll for more row, they remain.

When I do a delete, the number of row down, I would like to reduce all of
the extra rows which my stroll bar will see.


Thank You,

Gary

 

[Pete_UK]

The number of rows is fixed (on XL2003 this is 65536), and you can't
remove unused ones. However, you can hide them - click on the row
identifier for the first unused row to highlight it, then hold down
the <shift> key and press <end> once followed by <down-arrow> and
release <shift>. Then click on Format | Rows and then on Hide.

Hope this helps.

Pete

 

[Bob Umlas]

If excel "thinks" the last row is 30000 but you know the last row is really
300, then select 301:30001 or 301:65536 and delete them. Then either
save/reopen or in the VBE's immediate window type
Activesheet.Usedrange
and it should be reset.