How to add new sheet and retain formulas

Discussion in 'Windows 7 Software' started by kevphil, Mar 11, 2013.

  1. kevphil

    kevphil Senior Member

    Joined:
    Jun 28, 2011
    Messages:
    67
    Likes Received:
    0
    I have a combination Check Register/Expenses Excel 2010 Workbook. I would like to add a new Sheet (for 2013) which retains formulas, but has no content. How do I do this?

    I tried just copying 2012 into a new sheet for 2013, but when I try to delete the content, all the formulas also disappear.

    Thanks!

    _kevin
     
  2. Pauli

    Pauli Extraordinary Member
    Premium Supporter

    Joined:
    Mar 1, 2012
    Messages:
    2,499
    Likes Received:
    211
    Well, if you delete the content, you delete it - off it goes. Everything goes.

    I'm not sure about your problem, but all programs have the possibility of a "New Document", or something. That is, at least, if you have the full version of the program. In many cases you are offered a seemingly full version of a program, but it's actually a limited one - very common in accounting: you can do everything BUT...

    This probably isn't any help, might help you forward, though. :)
     
  3. kevphil

    kevphil Senior Member

    Joined:
    Jun 28, 2011
    Messages:
    67
    Likes Received:
    0
    I have a document which has formulae and content in the cells. I want to duplicate the 'sheet while retaining the same formulae, but without content in the cells, so I can start adding NEW content. This is a spreadsheet for annual expenses. I have one for 2012. Now I want to start a new one for 2013. I don't want to have to re-enter formulae that I already have in the 2012 'sheet. I know there's a way to do this, but the person who showed me is no longer around.

    Thanks!
     
  4. Pauli

    Pauli Extraordinary Member
    Premium Supporter

    Joined:
    Mar 1, 2012
    Messages:
    2,499
    Likes Received:
    211
    I guess you need to create a macro, like Excel Macro Tutorial

    Sorry if I have no direct answers... but it seems there aren't any available, freely or in abundance. Best of wishes.
     

Share This Page

Loading...