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