|
How do I specify an end to a worksheet to eliminate empty rows?
|
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" |
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" |
| All times are GMT +1. The time now is 05:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com