To create a new tab in the spreadsheet

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

Squeaky and KT (GA)

Member Since 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:
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.
 
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
 
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.
 
Sienne and Gabby (GA) said:
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.
Click to expand...
Thanks Sienne, I'll do that.
 
GTS said:
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
Click to expand...

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.
 
Squeaky and KT said:
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.
Click to expand...
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.
 
@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...
 
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!
 
julie & punkin (ga) said:
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!
Click to expand...
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!
 
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.
 
Tara & Ivana said:
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.
Click to expand...
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.
 
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
 
Squeaky and KT said:
@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...
Click to expand...

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:)
 
Status
Not open for further replies.
Back
Top