How do I remove redundant rows at end of sheet?
in [General]
|
Prev: Pivot Table Expand Collapse not showing for Cube
Next: Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes
From: Perplexed of Worcs on 1 Oct 2009 07:23 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?
From: Jacob Skaria on 1 Oct 2009 07:31 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?
From: Perplexed of Worcs on 1 Oct 2009 08:22
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? |