Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format column of several columns in several tabs (2003)

    Is there an easy way to format column width of several columns in several worksheets so they are the same format as a master tab rather than format each column in each worksheet in turn.
    See attachment for example. I would like to format the column width of all the columns in worksheet Bechir the same as the tab ‘Open RFS’.
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format column of several columns in several ta

    Simplest way is to record a macro or click the top left grey square next to A and above 1 to highlight the whole sheet and double click between the Gey A and B, this will auto adjust the column widths.
    Jerry

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format column of several columns in several ta

    That’s great thanks

Posting Permissions

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