"Phantom" Rows in Excel

[Merlyn]

Hello [World],

I'm running Excel 2000 SP-3 -- Sorry, my company has yet to upgrade to
anything newer.

I have a legacy spreadsheet that I use weekly which has ~ 53000 unnecessary
rows--when I SHIFT-CTRL-END from cell A-1, the program selects 53000+ rows.
I only use 100 - 200 rows on this sheet.

When I try to grab the lower, right-hand corner to collapse the box, I get
"out of memory" alert.

When I try to scroll-select-delete rows on the left column, I can't delete
them either.

I've also tried un-setting print area. That didn't seem to do anything,
either.

Can anyone tell me how to re-set the sheet so that SHIFT-CTRL-END only
selects the rows I need, instead of 10000 times what I really need?

Thanks

 

[Dave Peterson]

Debra Dalgleish can:
http://contextures.com/xlfaqApp.html#Unused

Hello [World],

I'm running Excel 2000 SP-3 -- Sorry, my company has yet to upgrade to
anything newer.

I have a legacy spreadsheet that I use weekly which has ~ 53000 unnecessary
rows--when I SHIFT-CTRL-END from cell A-1, the program selects 53000+ rows.
I only use 100 - 200 rows on this sheet.

When I try to grab the lower, right-hand corner to collapse the box, I get
"out of memory" alert.

When I try to scroll-select-delete rows on the left column, I can't delete
them either.

I've also tried un-setting print area. That didn't seem to do anything,
either.

Can anyone tell me how to re-set the sheet so that SHIFT-CTRL-END only
selects the rows I need, instead of 10000 times what I really need?

Thanks

 

[Merlyn]

Dave,

This solution worked perfectly. Thanks!

Merlyn

Debra Dalgleish can:
http://contextures.com/xlfaqApp.html#Unused

Hello [World],

I'm running Excel 2000 SP-3 -- Sorry, my company has yet to upgrade to
anything newer.

I have a legacy spreadsheet that I use weekly which has ~ 53000 unnecessary
rows--when I SHIFT-CTRL-END from cell A-1, the program selects 53000+ rows.
I only use 100 - 200 rows on this sheet.

When I try to grab the lower, right-hand corner to collapse the box, I get
"out of memory" alert.

When I try to scroll-select-delete rows on the left column, I can't delete
them either.

I've also tried un-setting print area. That didn't seem to do anything,
either.

Can anyone tell me how to re-set the sheet so that SHIFT-CTRL-END only
selects the rows I need, instead of 10000 times what I really need?

Thanks