Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
For whatever reason my worksheet goes on to row 1048576 while actual data
ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
You can't delete rows (or columns) as such.
You can delete the contents (in which case they get replaced by blank rows or columns), and/or you can hide the rows or columns, but they still exist. -- David Biddulph "jmj713" wrote in message ... For whatever reason my worksheet goes on to row 1048576 while actual data ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
I have hidden them for now. But I'd prefer to do whatever is necessary to
make the vertical scrollbar reflect the actual number of rows. As it stands, if unhidden, I cannot grab the slider on the vertical scrollbar to quickly move throughout the sheet because it is so tiny and will move me outside my data. So how can I set the end of data for the worksheet so the scrollbar stops there? "David Biddulph" wrote: You can't delete rows (or columns) as such. You can delete the contents (in which case they get replaced by blank rows or columns), and/or you can hide the rows or columns, but they still exist. -- David Biddulph "jmj713" wrote in message ... For whatever reason my worksheet goes on to row 1048576 while actual data ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
Hi,
I think you can clear up one issue - when you press Ctrl+End you are moving to row 504. Select rows 205-504 (or all the way down to 1048576) and choose the command Home, Delete, Delete Rows. Then save the file. Ctrl+End will take you to row 204. Instead of Delete Rows you can press Ctrl+- (control minus). You ARE deleting the rows and Excel is moving rows up to fill the deleted rows locations. -- If this helps, please click the Yes button Cheers, Shane Devenshire "jmj713" wrote: I have hidden them for now. But I'd prefer to do whatever is necessary to make the vertical scrollbar reflect the actual number of rows. As it stands, if unhidden, I cannot grab the slider on the vertical scrollbar to quickly move throughout the sheet because it is so tiny and will move me outside my data. So how can I set the end of data for the worksheet so the scrollbar stops there? "David Biddulph" wrote: You can't delete rows (or columns) as such. You can delete the contents (in which case they get replaced by blank rows or columns), and/or you can hide the rows or columns, but they still exist. -- David Biddulph "jmj713" wrote in message ... For whatever reason my worksheet goes on to row 1048576 while actual data ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
and if the suggestion from Shane is not good enough, copy the rows that you
need to a new spreadsheet. "jmj713" wrote: I have hidden them for now. But I'd prefer to do whatever is necessary to make the vertical scrollbar reflect the actual number of rows. As it stands, if unhidden, I cannot grab the slider on the vertical scrollbar to quickly move throughout the sheet because it is so tiny and will move me outside my data. So how can I set the end of data for the worksheet so the scrollbar stops there? "David Biddulph" wrote: You can't delete rows (or columns) as such. You can delete the contents (in which case they get replaced by blank rows or columns), and/or you can hide the rows or columns, but they still exist. -- David Biddulph "jmj713" wrote in message ... For whatever reason my worksheet goes on to row 1048576 while actual data ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
Just tried this and it doesn't help, unfortunately, even if selecting all the
way down to 1048576. The sheet does end at 254 now, which still amounts to a whole screen of blank space. Trying to delete 205:254 via this method does nothing apparently. "Shane Devenshire" wrote: Hi, I think you can clear up one issue - when you press Ctrl+End you are moving to row 504. Select rows 205-504 (or all the way down to 1048576) and choose the command Home, Delete, Delete Rows. Then save the file. Ctrl+End will take you to row 204. Instead of Delete Rows you can press Ctrl+- (control minus). You ARE deleting the rows and Excel is moving rows up to fill the deleted rows locations. -- If this helps, please click the Yes button Cheers, Shane Devenshire "jmj713" wrote: I have hidden them for now. But I'd prefer to do whatever is necessary to make the vertical scrollbar reflect the actual number of rows. As it stands, if unhidden, I cannot grab the slider on the vertical scrollbar to quickly move throughout the sheet because it is so tiny and will move me outside my data. So how can I set the end of data for the worksheet so the scrollbar stops there? "David Biddulph" wrote: You can't delete rows (or columns) as such. You can delete the contents (in which case they get replaced by blank rows or columns), and/or you can hide the rows or columns, but they still exist. -- David Biddulph "jmj713" wrote in message ... For whatever reason my worksheet goes on to row 1048576 while actual data ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot delete extra rows
Did you remember to save the file after you'd done your deletion? Then close
the file and reopen. -- David Biddulph jmj713 wrote: Just tried this and it doesn't help, unfortunately, even if selecting all the way down to 1048576. The sheet does end at 254 now, which still amounts to a whole screen of blank space. Trying to delete 205:254 via this method does nothing apparently. "Shane Devenshire" wrote: Hi, I think you can clear up one issue - when you press Ctrl+End you are moving to row 504. Select rows 205-504 (or all the way down to 1048576) and choose the command Home, Delete, Delete Rows. Then save the file. Ctrl+End will take you to row 204. Instead of Delete Rows you can press Ctrl+- (control minus). You ARE deleting the rows and Excel is moving rows up to fill the deleted rows locations. -- If this helps, please click the Yes button Cheers, Shane Devenshire "jmj713" wrote: I have hidden them for now. But I'd prefer to do whatever is necessary to make the vertical scrollbar reflect the actual number of rows. As it stands, if unhidden, I cannot grab the slider on the vertical scrollbar to quickly move throughout the sheet because it is so tiny and will move me outside my data. So how can I set the end of data for the worksheet so the scrollbar stops there? "David Biddulph" wrote: You can't delete rows (or columns) as such. You can delete the contents (in which case they get replaced by blank rows or columns), and/or you can hide the rows or columns, but they still exist. -- David Biddulph "jmj713" wrote in message ... For whatever reason my worksheet goes on to row 1048576 while actual data ends on row 204. I tried various methods of deleting rows 205-1048576, but they won't go away. I enter 205:1048576 into the Name Box and hit Delete, but the same rows return. It's a vicious circle. I can do this over and over. Also, hitting Ctrl+Shift+Down takes me down to 1048576, yet hitting Ctrl+End takes me down to only 504. My worksheet is very screwed up, so I need a surefire method of absolutely eliminating anything from 205 on. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Extra Pages | Excel Discussion (Misc queries) | |||
Delete extra pages | Excel Worksheet Functions | |||
How to delete extra rows from bottom? | Excel Discussion (Misc queries) | |||
delete extra columns and rows | Excel Discussion (Misc queries) | |||
how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) |