Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE
unwanted rows: select unwanted rows, then FormatRowsHide Regards, Stefi €˛Jessica Donadio€¯ ezt Ć*rta: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
Not ALWAYS, 2007 has 1M+ <bg
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE unwanted rows: select unwanted rows, then FormatRowsHide Regards, Stefi "Jessica Donadio" ezt ķrta: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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: Not ALWAYS, 2007 has 1M+ <bg -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE unwanted rows: select unwanted rows, then FormatRowsHide Regards, Stefi "Jessica Donadio" ezt Ć*rta: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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)? "Jessica Donadio" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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) "Bob Phillips" wrote in message ... Not ALWAYS, 2007 has 1M+ <bg -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE unwanted rows: select unwanted rows, then FormatRowsHide Regards, Stefi "Jessica Donadio" ezt ķrta: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
Just to confirm you saved the spreadsheet after the delete. For the rows to
be truely deleted requires a save... -- HTH... Jim Thomlinson "Jessica Donadio" wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
"Chip Pearson" wrote in message ... Strictly speaking, an XL 2007 sheet does, in fact, always have 65536 rows. LOL! |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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) "Chip Pearson" wrote in message ... 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) "Bob Phillips" wrote in message ... Not ALWAYS, 2007 has 1M+ <bg -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Stefi" wrote in message ... An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE unwanted rows: select unwanted rows, then FormatRowsHide Regards, Stefi "Jessica Donadio" ezt ķrta: 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
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 "Jim Thomlinson" wrote: Just to confirm you saved the spreadsheet after the delete. For the rows to be truely deleted requires a save... -- HTH... Jim Thomlinson "Jessica Donadio" wrote: 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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Excess Rows Again
Thank you that works perfectly!
"Stefi" wrote: An Excel sheet ALWAYS has 65536 rows, you can't delete them, but you can HIDE unwanted rows: select unwanted rows, then FormatRowsHide Regards, Stefi €˛Jessica Donadio€¯ ezt Ć*rta: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excess rows/columns | Excel Discussion (Misc queries) | |||
Removing excess rows in excel | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
Deleting excess data in a macro | Excel Discussion (Misc queries) | |||
Deleting excess rows and columns | New Users to Excel |