| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Phantom" Rows in Excel
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Phantom" Rows in Excel
Debra Dalgleish can:
http://contextures.com/xlfaqApp.html#Unused Merlyn wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Phantom" Rows in Excel
Dave,
This solution worked perfectly. Thanks! Merlyn "Dave Peterson" wrote: Debra Dalgleish can: http://contextures.com/xlfaqApp.html#Unused Merlyn wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
