ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   selecting text area (https://www.excelbanter.com/excel-worksheet-functions/127519-selecting-text-area.html)

dave7

selecting text area
 
I am trying to select an area of an excel document, say A1 to F18 ,to a
CSV file.
The touble is when I open it up in another programb a bigger area
appears say A1 - K50 wjich included empty cells. How do I just save A1
to F18 please


Dave Peterson

selecting text area
 
Copy and paste A1:F18 to a new worksheet in a different workbook.

Then save from there.

If you do it lots, take a look at Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

dave7 wrote:

I am trying to select an area of an excel document, say A1 to F18 ,to a
CSV file.
The touble is when I open it up in another programb a bigger area
appears say A1 - K50 wjich included empty cells. How do I just save A1
to F18 please


--

Dave Peterson


All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com