"Phantom" Rows in Excel

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
 
D

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

Merlyn

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Cannot delete empty cells/rows 4
Cannot delete extra rows 5
reduce excel file size by deleting blank rows and columns?? 4
Delete values in sheet 2 that arre found in sheet 1 1
Unhiding rows in Excel 2007 5
To many rows in worksheet in 2007 1
Adding more than 65,536 rows in Excel 2007 5
Deleting extra rows in Excel 07 2

Top