Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I specify an end to a worksheet to eliminate empty rows?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I specify an end to a worksheet to eliminate empty rows?
Hi TexasUser, (I hope that isn't your real name)
Please take the time to ask the question in the body so we know there is a question, it might also avoid being so ambiguous that the real question is unknown. I am going to guess that Cntrl+End takes you past where you think your data actual is. For that I would suggest fixing the entire workbook at once with DeleteUnuseda macro. at Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish http://www.contextures.com/xlfaqApp.html#Unused I wouldn't even bother with instructions to delete rows/columns manually.. Upon completion of the macro, it would be a good idea to save the workbook. If you have a problem with empty rows between your good data Delete Cells/Rows in Range, based on empty cells, or cells with specific values Delete ALL rows that are Entirely Blank (#RemoveEmptyRows) http://www.mvps.org/dmcritchie/excel...emoveEmptyRows --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Texasuser" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I specify an end to a worksheet to eliminate empty rows
Thank you!
"David McRitchie" wrote: Hi TexasUser, (I hope that isn't your real name) Please take the time to ask the question in the body so we know there is a question, it might also avoid being so ambiguous that the real question is unknown. I am going to guess that Cntrl+End takes you past where you think your data actual is. For that I would suggest fixing the entire workbook at once with DeleteUnuseda macro. at Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish http://www.contextures.com/xlfaqApp.html#Unused I wouldn't even bother with instructions to delete rows/columns manually.. Upon completion of the macro, it would be a good idea to save the workbook. If you have a problem with empty rows between your good data Delete Cells/Rows in Range, based on empty cells, or cells with specific values Delete ALL rows that are Entirely Blank (#RemoveEmptyRows) http://www.mvps.org/dmcritchie/excel...emoveEmptyRows --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Texasuser" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet protection with grouped rows? | Excel Worksheet Functions | |||
how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
Automatically select empty rows | Excel Worksheet Functions | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Save As CSV saves empty rows | Excel Discussion (Misc queries) |