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

K

Kathy

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?
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top