To create a new tab in the spreadsheet

Discussion in 'Lantus / Levemir / Biosimilars' started by Squeaky and KT (GA), Dec 30, 2015.

Thread Status:
Not open for further replies.
  1. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011
    For USA users:

    As we reach a new year, many people want to create a new tab on their spreadsheets. It becomes a huge file to open for others if the same sheet is continued for a long time. It's not hard to create a new tab. It takes as long to type/read this as it does to actually do it.

    This link in Tech Support provides step by step easy instructions:

     
    Last edited: Jan 1, 2016
  2. suki & crystal (GA)

    suki & crystal (GA) Well-Known Member

    Joined:
    May 4, 2014
    Perhaps you could also add the different instructions for us Europeans/Aussies. Thanks Lyresa, much appreciated.
     
  3. Lynn & Rupert

    Lynn & Rupert Well-Known Member

    Joined:
    Jul 15, 2015
    Thank you for the link Squeaky!
     
  4. Wendy&Neko

    Wendy&Neko Senior Member Moderator

    Joined:
    Feb 28, 2012
    I like to keep the US conversions from the previous year, so it's easier to just create a new file since I am using the World spreadsheet. If you save a copy of the existing one, you retain the formatting.
     
  5. Gill & George

    Gill & George Well-Known Member

    Joined:
    Oct 27, 2015
    Great Instructions @Squeaky and KT I have managed to create a new tab but
    I do have a question, though I think the problem is of my own making.

    Could you tell me if my SS is US or world (I think I am using world, don't know why though I had intended to open US as my vet here in Spain uses the same units for BG as you guys in the US)

    I don't need to have the world units, so I tried deleting the world tab, but that made things go a bit wonky in the US tab, everything got highlighted with red, so I freaked out undid my delete, didn't want to loose all the data.
    What do you think is my best solution
    1) start a new US ss
    2) is there a way to edit the ss to get rid of the world tab, and the conversion formula (which to be honest has been a bit of a pain as I have to delete formula before putting in numbers)

    Thanks, sorry for being such an idiot
     
  6. Sienne and Gabby (GA)

    Sienne and Gabby (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
    The World SS has a different formatting since the information that is entered on the 'world' tab converts the numbers to US format. You are probably better served by creating a new SS using the US template, then copying and pasting the current information into that SS and moving forward from there.
     
  7. Gill & George

    Gill & George Well-Known Member

    Joined:
    Oct 27, 2015
    Thanks Sienne, I'll do that.
     
  8. tiffmaxee

    tiffmaxee Well-Known Member

    Joined:
    Nov 15, 2013
  9. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011
    Sienne hit the nail on the head - it would likely be better to start a whole new file from the USA template. The 2 files work completely different. In the world file, the USA sheet takes the value you entered and multiplies it by 18. When you erased the 'World' sheet, it caused the USA view to freak out because there WAS no 'world' sheet for it to refer to. In the USA view, the conditional formatting is in the cells themselves.
     
  10. Gill & George

    Gill & George Well-Known Member

    Joined:
    Oct 27, 2015
    Thanks Lyresa, have, with the assistance of DH, coppied the old ss, set up a new US ss with the old numbers pasted in and got my 2016 tab ready to start the year afresh.

    It was a little bit of a faff, as some of the cells where I had added comments had to be hand filled in the correct colours, but it was worth it in the end to have all the data easily accessible on one SS.
     
  11. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011
    @GTS - GREAT! May I suggest that you use 'Notes' instead of 'Comments' function? You can clear 'notes', you have to 'resolve' comments and there's no way to get rid of them that I've found. To use notes instead, just use 'Shift/F2' or use the 'insert' menu...they look the same on the ssheet. Those are handy as a shirt pocket! I use them all the time BUT I discovered that they don't show on the 'published' view...
     
  12. Anne & Hyde (GA)

    Anne & Hyde (GA) Well-Known Member

    Joined:
    May 18, 2015
  13. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
    Thanks for posting this, Lyresa. Really helpful!

    Don't forget the final step is updating the link to the spreadsheet in your signature block so it goes to the current year!
     
  14. Jill & Alex (GA)

    Jill & Alex (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
    No.
    Make sure you're signed into your Google account. All you have to do is click on the tab at the bottom of the new sheet. Choose the option to move the new sheet to the left (if it isn't already) so it's "on top". The link in your signature remains the same. Don't mess with it! LOL!
     
  15. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
    good to know - thanks.
     
  16. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011

    Julie, you don't even have to republish! It's the same link...Jill already hit that part... :)
     
  17. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011
    You can also 'drag and drop' the new sheet to the far left (top) by clicking/holding the tab and dragging it. Just let go when it's there! You'll see the old tab slide to the right.
     
  18. Marje and Gracie

    Marje and Gracie Senior Member Moderator

    Joined:
    May 30, 2010
    Thanks for posting this, Lyresa. It might actually be a good thing for me to consider adding to the post in the tech forum on how to do a SS.
     
  19. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011
  20. Tara & Ivana (GA)

    Tara & Ivana (GA) Well-Known Member

    Joined:
    Aug 20, 2015
    I started a new spreadsheet, as the World one takes longer and longer to load as it gets bigger due to all the calculations and it would be as slow as a snail a few months into another year. So for people doing that, you'll need to change/add the new link in your signature.
     
    Squeaky and KT (GA) likes this.
  21. Jill & Alex (GA)

    Jill & Alex (GA) Senior Member Moderator

    Joined:
    Dec 28, 2009
    Yes, if you're starting a new spreadsheet, the link in your signature will require updating.
    If you're simply adding a new sheet to an existing spreadsheet, there's no need to touch your existing signature.
     
    Squeaky and KT (GA) likes this.
  22. Ella & Rusty & Stu(GA)

    Ella & Rusty & Stu(GA) Well-Known Member

    Joined:
    Jan 11, 2010
    Here's a tip I learned from @Ann & Tess GA. After you have taken out all of the values on the duplicate spreadsheet and have a nice, blank spreadsheet, make a duplicate of it, and label it "Spreadsheet Template". Then, next January, all you will have to do is make a duplicate of "Spreadsheet Template" and name the duplicate "2017". And so on, through the years! Always keep a pristine "Spreadsheet Template".

    Ella
     
  23. Julia Rae

    Julia Rae Well-Known Member

    Joined:
    Jun 11, 2015
    Help I am being brain dead and cant figure making a new ss out!
     
  24. Squeaky and KT (GA)

    Squeaky and KT (GA) Well-Known Member

    Joined:
    Jul 19, 2011
    What part are you running into problems with Julia? I'll be glad to help. Would you mind posting your questions on the link in the Tech Forum? Others may have the same problem and reading the solution may help them later. :) Here a link to it:

    CREATING NEW TAB IN SPREADSHEET-TECH FORUM

    .
     
  25. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
  26. julie & punkin (ga)

    julie & punkin (ga) Well-Known Member

    Joined:
    Feb 17, 2011
    another bumpity for those that are a week into the New Year and realizing they need to do this . . . :D
     
    Squeaky and KT (GA) likes this.
  27. Gill & George

    Gill & George Well-Known Member

    Joined:
    Oct 27, 2015
    Thanks Lyresa
    The note function may prove handy, I haven't used yet as I want the comments that I am making to be visible in the published version. I've made a copy of the 'clean' ss and labeled it template on the ss, that way I will have a clean copy come 2017, avoiding having to manually clear coloured cells or notes etc. it should prove less faffy next year:)
     
    Squeaky and KT (GA) likes this.
Thread Status:
Not open for further replies.

Share This Page