How do I remove redundant rows at end of sheet?
I'm cutting a larger Excel file into 2 smaller ones, and then converting to
csv. The original but now smaller file shows empty lines when converted, which causes a problem for the resultant application. Rather than cut and paste this into a new Excel file, can anyone tell me how to resolve these empty, but apparently 'in use' cells/rows? |
How do I remove redundant rows at end of sheet?
Refer the topic by Debra
Search for "To manually reset the used range: " in the below link http://www.contextures.com/xlfaqApp.html#Unused If this post helps click Yes --------------- Jacob Skaria "Perplexed of Worcs" wrote: I'm cutting a larger Excel file into 2 smaller ones, and then converting to csv. The original but now smaller file shows empty lines when converted, which causes a problem for the resultant application. Rather than cut and paste this into a new Excel file, can anyone tell me how to resolve these empty, but apparently 'in use' cells/rows? |
How do I remove redundant rows at end of sheet?
Many thanks Jacob. I was sure I tried something like this but.... Simple when
you know how! "Jacob Skaria" wrote: Refer the topic by Debra Search for "To manually reset the used range: " in the below link http://www.contextures.com/xlfaqApp.html#Unused If this post helps click Yes --------------- Jacob Skaria "Perplexed of Worcs" wrote: I'm cutting a larger Excel file into 2 smaller ones, and then converting to csv. The original but now smaller file shows empty lines when converted, which causes a problem for the resultant application. Rather than cut and paste this into a new Excel file, can anyone tell me how to resolve these empty, but apparently 'in use' cells/rows? |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com