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?