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

Similar Threads

Excel 2007 spreadsheet - blank rows 2
How do I get rid of a series of hyperlinks in a column or row 4
How do I get rid of duplicate rows? 5
How do I insert a row between every line in my spreadsheet? 3
get rid of drop down boxes in excel 2007 6
Having Blank Cells, etc. ? 1
How do I get Rid of the Circumflex Accent (Caret) 2
How do I insert a row after every row of data in XL? 5

Top