Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: wrap txt

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    when i wrap text some rows are wide and some are not wide i have to go and do each one auto fit how to do all autofit at once

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not sure if this is what you are looking for, but try the following:

    Selection.Columns.AutoFit

    It autofits the column width of your entire selection.

    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yes thats what i am looking for thanks

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    thats in vba, you can do it manually by selecting the "all sheets" button which is in the corner to the left of the column A heading and above the Row 1 label. This selects all the sheets, then double click the edge of one of the column headers it will autofit all columns on the sheet.

Some videos you may like

User Tag List

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
  •