Deleting Excess Rows Again

[Jessica Donadio]

I know this question has been asked numerous times, but my excel sheet is
being horribly stubborn so that the last row remains to be 65000 something.
I've tried everything, I've read the article on microsoft's page, tried
deleting the content, plus delete the rows, plus cancel all from the edit
menu, plus referencing the range to delete first through F5, plus any of the
macros that I found on the contexture website and other places online, and
nothing. I've tried copying and pasting the range I want to a new workbook,
everything, and nothing has worked. Is there anything else I can do?? Thank
you.

Jessica

 

[Jessica Donadio]

Also I should mention that I am operating on the Italian version of Excel, so
that add-in offered by Microsoft doesn't work., and sadly, there is no way I
can change it to the English version because it is my work computer

 

[Stefi]

An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE
unwanted rows: select unwanted rows, then Format>Rows>Hide

Regards,
Stefi

„Jessica Donadio†ezt írta:

 

[Bob Phillips]

Not ALWAYS, 2007 has 1M+ <bg>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Stefi]

Yes, I was not exact. The right statement should be: An Excel version ALWAYS
has its predefined number of rows.

Stefi

„Bob Phillips†ezt írta:

 

[Duke Carey]

If you truly deleted all the rows below your used cells and Excel continues
to think you've used the entire sheet, then I'm not sure what else to offer
you.

The part where you've described copying just the desired range to a new
workbook and STILL Ctrl-End takes you to the last row, that just sounds
fishy. Do you have any problems with other workbooks?

Do you ever select the entire worksheet and apply formatting (a real no-no)?

 

[Chip Pearson]

Strictly speaking, an XL 2007 sheet does, in fact, always have 65536 rows.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Jim Thomlinson]

Just to confirm you saved the spreadsheet after the delete. For the rows to
be truely deleted requires a save...

 

[Bob Phillips]

Strictly speaking, an XL 2007 sheet does, in fact, always have 65536 rows.

LOL!

 

[Bob Phillips]

Okay, but an Excel sheet doesn't always have 65536 rows, Excel 95 (which I
still have, not now loaded) only has 16,384 <g>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jessica Donadio]

Yes I had saved and closed. But I also have selected entire rows and
centered them or whatnot, so that probably has caused the effect. But I'm a
little confused based on the previous posts, is it therefore not possible to
delete excess rows and columns so that just your range is present? At any
rate, hiding the rows worked perfectly, thank you so much!

Jessica Donadio

 

[Jessica Donadio]

Thank you that works perfectly!

An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE
unwanted rows: select unwanted rows, then Format>Rows>Hide

Regards,
Stefi

„Jessica Donadio†ezt írta: