This is a totally trivial problem but it's making me crazy. I'm
working with a number of very long lists in Excel, and every time I
open one, the spreadsheet is about 70000 cells long, no kidding. So
the scrollbar is basically dysfunctional; the slightest move of the
scrollbar makes it hop about 500 cells. I've tried deleting rows and
trying to format the spreadsheet. Can a more experienced Excel user
help me out?

Thanks so much,

lotf629

---

Request for Question Clarification by pafalafa-ga on 26 Jan 2006 16:05 PST

I don't have Excel right in front of me now, but I think that if you
highlight the range you're working with, and save just the range as a
file, then it will open up with just the resized dimensions.

Try it, and let me know what happens,

pafalafa-ga

---

Clarification of Question by fieldlily-ga on 10 Feb 2006 12:44 PST

Hi everybody,

Sure it's obvious, Rajesh, but also maddening. :) It just occurred to
me that I had to clarify something important. The lists I am using are
only 5000-6000 cells long. The bottom 60,000 cells or so are totally
empty, but even when I delete them, the spreadsheet doesn't resize.

I've had some good luck figuring out ways to work around the fact that
the spreadsheet is 70,000 cells long--thank you all!--but am still
looking for a way to get rid of these tens of thousands of empty
cells.

Thanks again everybody,

lotf629

---

Request for Question Clarification by pafalafa-ga on 10 Feb 2006 13:04 PST

I'm not sure if you saw my Jan 26 comment (above) about saving the range?


Did you try it?  What happened?

paf

---

Request for Question Clarification by hummer-ga on 11 Feb 2006 20:04 PST

Hi fieldlily,

Perhaps this will work?

How to reset the last cell in Excel
Method 1
"To reset the last cell by manually deleting excess rows and columns."
Method 2
"An Excel add-in to remove excess formatting and reset the last cell
is now available for download."
http://support.microsoft.com/?kbid=244435

Good luck,
hummer

This may help:

http://www.cpearson.com/excel/deleting.htm

Best regards,
Rainbow

Don't move the scroll bar.  Click below it instead.

Hi,
   It is obvious the excel will move 500 rows when u move the
scrollbar in the excel sheet which has 70,000 cells.

   you can try the "goto" optiin in the excel to work around that excel sheet.
that "Goto" option is located under "Edit" Menu.

if u want to goto a cell A20, then type A20 in that and u will be
moved to that cell. It also has more features like going to the last
cell, etc...

hope this will help you

regards,
Rajesh

I'm not sure if you saw my Jan 26 comment (above--in "Clarifications"
section) about saving the range?


Did you try it?  What happened?

paf