Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Column widths in multiple worksheets (all)

    I don't use Excel much, which will account for the naivety of this question.

    I require to create a small number of very similar worksheets in a workbook, which contain data for subsequent days.

    Once I've set up the column widths for the worksheet for the first day, I would like to make all subsequent worksheets take identical column widths to the first one.

    Is there a "copy column widths" command?

    I tried using the Format Painter, but it changed my time values (as in "03:27" ) to decimal values in the new worksheets... <img src=/S/hosed.gif border=0 alt=hosed width=73 height=24>
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Column widths in multiple worksheets (all)

    Some possibilities:

    (1) You can select multiple worksheets: click on a sheet tab, then Shift+Click on another to select a contiguous range; Ctrl+Click to select multiple individual worksheets; the right click menu of a sheet tab has an option to select all sheets. Actions like changing column widths apply to all selected sheets.

    (2) If you select one or more entire columns using the column headers, Copy and Paste (or Paste Special...) will copy column widths. In particular, if you want to copy the formatting of some columns, including column widths, but not the data, you can select the columns, copy them to the clipboard, select a cell in the destination sheet and then select Edit/Paste Special..., Format option.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Column widths in multiple worksheets (all)

    Set up your first sheet as you want and then copy the sheet as many times as you want (right-click on the sheet tab name etc or hold the [Ctrl] key down and 'drag' the master sheet to create copies)

    zeddy

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Column widths in multiple worksheets (all)

    Another method is to save and reuse the formatted worksheet.

    Create a single sheet workbook with all the formatting as required and save this workbook to your Templates folder (NOT XLStart). The file you save does not have to be a template, but if you select Save as type Template, Excel should point you to your templates folder.

    Whenever you require to create a new sheet with the same format all you have to do is right click on any Sheet tab, select Insert and you should see an entry for the saved worksheet which you can then click to insert a copy. Or it can be done via code as follows :

    Sheets.Add Type:= "PathNameFileName"

    Andrew C

Posting Permissions

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