"Phantom" Rows in Excel

  • Thread starter Thread starter Merlyn
  • Start date Start date
M

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
 
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
Click to expand...
 
Dave,

This solution worked perfectly. Thanks!

Merlyn

Dave Peterson said:
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
Click to expand...
Click to expand...
 
Back
Top