Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adjust column width
I have a command file that creates a .csv spreadsheet. The information in
some of the cells/colums are larger than the column width, so I get #####. I know I can just go up to the format tab and correct things that way, but what I would really like to happen is when I open the spreadsheet, all the columns autofix automatically. Is this possible? |
#2
|
|||
|
|||
There's nothing that you can put in the .csv file that will help excel autofit
those columns. The .csv file is just plain old text--it doesn't contain formatting (including columnwidth). If your offending column is C (say), you could doubleclick on that vertical line between the column header between C and D. To to get all columns, hit ctrl-a (twice in xl2003) and then double click on any of those vertical lines. coolbeans wrote: I have a command file that creates a .csv spreadsheet. The information in some of the cells/colums are larger than the column width, so I get #####. I know I can just go up to the format tab and correct things that way, but what I would really like to happen is when I open the spreadsheet, all the columns autofix automatically. Is this possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Task Bar View of Column Width | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Column Width | Excel Discussion (Misc queries) | |||
Excel should let me adjust the left to right (width) margin for a. | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |