Results 1 to 5 of 5

Importing a csv file and need to format the column width

This is a discussion on Importing a csv file and need to format the column width within the Excel Questions forums, part of the Question Forums category; I've created a csv text file that I'm opening directly into excel. The data is opened into the correct cells ...

  1. #1
    New Member
    Join Date
    Jul 2002
    Location
    Utah
    Posts
    2

    Default

    I've created a csv text file that I'm opening directly into excel. The data is opened into the correct cells and everything looks fine, but for the column width. All of the columns come up in there standard width and I would like them to adjust so all of the text is visible. I'm not that familiar with importing into excel beyond basic formats. Any help is greatly appreciated!!

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330

    Default

    On 2002-07-09 10:51, Cory wrote:
    I've created a csv text file that I'm opening directly into excel. The data is opened into the correct cells and everything looks fine, but for the column width. All of the columns come up in there standard width and I would like them to adjust so all of the text is visible. I'm not that familiar with importing into excel beyond basic formats. Any help is greatly appreciated!!
    Select all the cells in the file (the grey box beside column A and above row 1), and Format|Column|AutoFitSelection.

    Hope this helps
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Board Regular texasalynn's Avatar
    Join Date
    May 2002
    Location
    Houston, TX
    Posts
    8,237

    Default

    I'm sure there is a fancier way but what I do is click on the area between column A and row 1 (the little gray box). This highlights the whole worksheet then put your mouse between one of the columns (say between column A & B) and when the mouse pointer turnes to a double arrow double click the mouse. This formats each column to the widest width required for each column.

    Hopes this helps!

    texasalynn

  4. #4
    New Member
    Join Date
    Jul 2002
    Location
    Utah
    Posts
    2

    Default

    Thanks for the information. I should have been more informative on my description of the problem. I was hoping to include sometype of formatting record in the text csv file so the users wouldn't have to do any of the formatting manually. When they open the csv file I want it to automatically display correctly. Again, any help is greatly appreciated!

  5. #5
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330

    Default

    On 2002-07-09 13:47, Cory wrote:
    Thanks for the information. I should have been more informative on my description of the problem. I was hoping to include sometype of formatting record in the text csv file so the users wouldn't have to do any of the formatting manually. When they open the csv file I want it to automatically display correctly. Again, any help is greatly appreciated!
    Sorry , can't be done within the CSV file. You could accomplish this via a macro, but you'd have to invoke the macro each time you open the file (instead of simply opening the file).

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com