Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintaining Column Widths in CSV Format File
I have to send data to my users that eventually are
importing it into Excel. I create the files in a CSV format but the users still have to expand the column widths to show the headers and other data properly. Is there a way to get Excel to open these CSV files so the columns are as wide as the widest data in the file? Is there a way to add something to CSV file direclty so Excel will make the column widths the correct width? thanks to anyone that replies. You can reply directly to my elmail if you like. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintaining Column Widths in CSV Format File
No, but you can click at the intersection of the row and column headers and
then do format=Column=Autofit or after selecting the whole sheet as above, go to any column label and double click on the right border -- Regards, Tom Ogilvy John Boris wrote in message ... I have to send data to my users that eventually are importing it into Excel. I create the files in a CSV format but the users still have to expand the column widths to show the headers and other data properly. Is there a way to get Excel to open these CSV files so the columns are as wide as the widest data in the file? Is there a way to add something to CSV file direclty so Excel will make the column widths the correct width? thanks to anyone that replies. You can reply directly to my elmail if you like. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
column widths keep changing in shared file | Excel Discussion (Misc queries) | |||
Renaming a file while maintaining links | Excel Worksheet Functions | |||
Maintaining Cell Format in Query | Excel Discussion (Misc queries) | |||
Problem Maintaining Cell Format After Query | Excel Worksheet Functions | |||
CSV File and Maintaining Quotation Marks in TXT | Excel Discussion (Misc queries) |