How do I get rid of a blank row at bottom of Excel spreadsheet?
Select the first blank row below you data
Press CTRL-SHIFT-DOWN ARROW keys together
Choose Edit-Clear All
Save your file
Export
Your problem should be fixed...
If not then select the first column to the right of your data
Press CTRL-SHIFT-RIGHT ARROW keys together
Choose Edit-Clear All
Save your file
Export
"Kathy" wrote:
When I save my spreadsheet as a .txt file (to be imported into General
Ledger), it ends up with a blank row at the bottom and that causes error on
importing. How do I get rid of this row?
|