+ Reply to Thread
Results 1 to 5 of 5

Can I save a spreadsheet including formulas

  1. #1
    Registered User
    Join Date
    07-10-2007
    Posts
    12

    Can I save a spreadsheet including formulas

    I have spent several hours creating a spreadsheet which includes formulas, headings, calculations, etc. Is it possible to save this spread sheet without the data I have entered? As a blank spreadsheet but containing all my formulas? So that I can use it again next year with all new data?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    07-10-2007
    Location
    Portland, OR USA
    Posts
    135
    Delete your data and 'Save As' the file with a different name. Call it template or something that makes sense to you.

  3. #3
    Registered User
    Join Date
    07-10-2007
    Posts
    12

    Saving Spreadsheet

    no dice

    I am new to Excel. How do I delete my data and not the formulas?

  4. #4
    Registered User
    Join Date
    08-27-2003
    Location
    Melbourne, Australia
    Posts
    75
    Have the cursor over the cells you want to clear. Press the "delete" key.
    Don't delete info in cells that contain formulas. When you delete the cells you entered info into, it should clear the results in the cells with formulas.


    Paul

  5. #5
    Registered User
    Join Date
    07-10-2007
    Posts
    12

    Deleting data

    Paul

    Thanks. That worked. This was very much appreciated.

    Sandra

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1