Re: 64,000 extra rows, never a good answer

On 10/24/08 7:20 PM, in article 59b5c71a.9@xxxxxxxxxxxxxxxxxxxxxxx,
"kevs1@xxxxxxxxxxxxxxxx" <kevs1@xxxxxxxxxxxxxxxx> wrote:

It doesn't work Bob, that's what frustrating.

I select row 800,
I control shift down arrow, and now everything below is selected.
I edit, delete, and all 65000 rows below are still there?

Thats why I'm still posting about this issue.
Kevs1,

Excel 2004 has 65536 rows. Period. You can not change this. However, if you
must, you can hide the unused rows so you don't see them. Follow Cybertaz's
instructions for this. But, I don't think this is your problem. If, as you
say, the scroll bar indicates that your work*** is 65536 rows making
scrolling difficult because you are only using a few hundred rows then you
can also fix this.

Follow my instructions in a previous post about deleting the extra rows.
Yes, the *** will still show 65K rows when you are done. However, if you
followed my instructions exactly, when the workbook is reopened, moving the
scroll bar to the bottom will bring you to the bottom of your data, NOT the
bottom of the ***. The exact same situation exists with columns, and you
can use either solution for that also.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.

Quantcast