Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    new template from old w/sheet?

    I seems to recall in older versions a simple step-wise way to save a worksheet as a template, retaining all layout, print, column widths and formulae etc., but first stripping out or zeroing the data in numeric cells. Help in EXL97 seems not to make any mention of readying a w/sheet for saving as a new template. What am I missing, or where do I look? Thanks, Peter

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: new template from old w/sheet?

    If I wanted to see at a glance what cells had formula in them so I didn't delete the formula by accident I'd use CTRL + ~. It will quickly toggle the worksheet to displaying formulas instead of results. Don't worry about column widths. Just use CTRL + ~ again and the columns will resize.
    Then I'd delete all non-formula data and save as a template. I can't think of any more steps, unless you intend on applying cell protection?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: new template from old w/sheet?

    Wow! - that was quick. One more Q: what's the trick for making a blank copy of a sheet, but such that customized various column widths in the sheet are retained in the new blank?
    Thanks, Peter

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: new template from old w/sheet?

    Unfortunately, there is no easy way that I know of. You can easily find all of the cells on a sheet that contain formulas by selecting GoTo from the Edit menu, clicking on Special in the dialog box, then click on Formulas and OK. That will select all cells that contain formulas. Likewise, you can select all cells that contain constants by clicking on Constants. However, that will also select all cells containing labels as well.
    Legare Coleman

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: new template from old w/sheet?

    Copy the entire sheet by clicking the blank square in the upper left corner and then Edit/Copy. Select the upper left cell of a blank sheet and select Edit/Paste. Column widths and row heights will be pasted in the new sheet.
    Legare Coleman

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: new template from old w/sheet?

    But it makes a good basis for a solid procedural method. Thanks - and thanks also for the reminder about the 'whole sheet' role of the top-left square. Peter

Posting Permissions

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