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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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 worksheet 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 sheet 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 sheet. The exact same situation exists with columns, and you
can use either solution for that also.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.



Relevant Pages

  • Re: Going up or down
    ... You need to think of your document not as an 8.5*11 sheet but father as ... towards bottom of document. ... This is convention. ... It would have room for a scroll bar. ...
    (comp.sys.mac.system)
  • Re: Viewing the lower section of the spreadsheet --tabs, scroll ba
    ... -Pulling down on the scroll bar takes me to the last populated row. ... -Decreasing the size of the sheet makes the empty columns and rows come into ... if you go to the bottom of the spreadsheet ... That's normal because Excel remembers the size and position of your window ...
    (microsoft.public.excel.misc)
  • Re: Excels scroll bar
    ... Microsoft MVP - Excel ... | If I then delete say 900 rows, the scroll bar does not adjust itself. ... | Now, the scroll moves just a nudge, and I am at the bottom the sheet. ...
    (microsoft.public.excel.misc)
  • Re: Excels scroll bar
    ... Microsoft MVP - Excel ... | If I then delete say 900 rows, the scroll bar does not adjust itself. ... | Now, the scroll moves just a nudge, and I am at the bottom the sheet. ...
    (microsoft.public.excel.misc)
  • Re: Can this be done
    ... There's a link at the bottom for more instructions from the MS site. ... Jonathan wrote: ... > I need to create a front sheet for files. ...
    (microsoft.public.excel.programming)