Remove extra rows in Spreadsheet

  • Thread starter Thread starter Gary
  • Start date Start date
G

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
 
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
 
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.
 
Back
Top