View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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?