Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

New Excel Documents

  • 23-11-2012 10:59AM
    #1
    stargazer 68
    Registered Users, Registered Users 2 Posts: 5,203 ✭✭✭


    I have a large excel document with lots of worksheets. I have the same trouble every year so this year Im trying to solve it early!

    I need to create a new one for 2013 so what I would normally do is create a copy of 2012 and rename it 2013 and then delete the contents so its blank to start in Jan. However what tends to happen is some of the formulas and drop down lists get deleted too.

    How can I create a new document but keep all the formulas etc?


Comments

  • #2
    hullaballoo
    Administrators, Entertainment Moderators, Social & Fun Moderators, Society & Culture Moderators, Paid Member Posts: 18,829 Admin ✭✭✭✭✭hullaballoo


    Hi,

    If you like, you can send me a copy at hullaballoo{at}bmail.ie and I'll see if I can generate a template that you can save and then just change the year.


  • #3
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 96,006 Mod ✭✭✭✭Capt'n Midnight


    click on the bit at the very top right of the sheet to highlight it all
    copy

    on to new sheet

    right click in cell A1

    paste special - untick the options you don't want like values


  • #4
    stargazer 68
    Registered Users, Registered Users 2 Posts: 5,203 ✭✭✭stargazer 68


    Capt'n Midnight wrote: »
    click on the bit at the very top right of the sheet to highlight it all
    copy

    on to new sheet

    right click in cell A1

    paste special - untick the options you don't want like values

    Tried that. It will let me paste all or one option (wont let me tick multiple) so I lose the drop down lists and keep the formulas or vice versa


  • #5
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 96,006 Mod ✭✭✭✭Capt'n Midnight


    Dovies wrote: »
    Tried that. It will let me paste all or one option (wont let me tick multiple) so I lose the drop down lists and keep the formulas or vice versa
    you could try pasting again with the bits you are missing


Advertisement