How do I get rid of a blank row at bottom of Excel spreadsheet?
 

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?

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?