Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting (Excel 2000/2003)

    I have a standard format I use for the header row in all my spreadsheets. Is there a way to create a custom sytle or format that would be avaiable in any new workbokk that is created. Or even a macro that would format the selected cells.



    Thanks for any help
    Richard

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

    Re: Formatting (Excel 2000/2003)

    If you create a template named Book.xlt and a single-worksheet template named Sheet.xlt with the formatting you want, and store them in your XLSTART folder, they will be used as the model for all new workbooks and new worksheets.

Posting Permissions

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