Re: 64,000 extra rows, never a good answer
- From: Bob Greenblatt <bob@xxxxxxxxxx>
- Date: Mon, 27 Oct 2008 08:06:18 -0400
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.Kevs1,
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.
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
.
- References:
- 64,000 extra rows, never a good answer
- From: kevs1
- Re: 64,000 extra rows, never a good answer
- From: kevs1
- 64,000 extra rows, never a good answer
- Prev by Date: Re: 64,000 extra rows, never a good answer
- Next by Date: Re: Download not working
- Previous by thread: Re: 64,000 extra rows, never a good answer
- Next by thread: Re: 64,000 extra rows, never a good answer
- Index(es):
Relevant Pages
|
