You really don’t need to open this and editing it, may break the sheet. Notes (hidden) – this is a hidden sheet that has some working and formulas to help operate the sheet.You can delete this at any time by right-clicking the tab and selecting Delete. Rumballs – An example recipe from me to you so you can see what your own recipe tabs should look like.Template – You will duplicate this to create your recipes.Recipe List – This is your custom list of recipes in your current Google Sheet.Print – This will allow you to print your selected recipe by your chosen ingredient list. Instructions – A simple set of instructions for you along with a link to this post if you need a bit more detail.Your copy of the Recipe Google Sheet should contain the following tabs: Google Sheets Beginners: Creating Sheet Tabs (14) You can navigate to different tabs inside the one Google Sheet file by clicking on them. In Google Sheets, there are a bunch of tabs down the bottom. When you open your Recipe Google Sheet for the first time you should be automatically navigated to Recipe List sheet tab. You can go ahead and close my copy so you don’t get confused ( I do this all the time). Once you have completed this step, your very own copy of the Recipe Google Sheet will appear. Go to File > Make a copy. You’ll get a popup window that will ask you to rename the file and put it somewhere in your Google Drive. You’ll only be able to view my version of this Google Sheet, so you will need to make a copy. To create your first Recipe Google Sheet, click on the link below to access my copy. Now let’s get your first recipe Google Sheet underway… Instructions There is a link to this post with step-by-step instructions and links to mini videos and tutorials on anything you need a little help with.There is a short guide in the Instructions Sheet Tab for you to create your own Recipe Google Sheet or create a new recipe in a sheet tab.Find a custom template Sheet Tab for you to update for your own recipe.You can make a trusted friend a co-editor.You can easily share this template for others to view by family member emails or the whole world.There is a print page that allows you to print your selected recipe in Portrait by:.You can set it to display in Imperial ( ounces) or Metric ( grams).Automatically get ingredients by the batch amount or the total weight of ingredients.This Google Sheet Recipe template allows you to: Print the recipe with a selected ingredient type.Changing Batches and Total Weight of your Recipe.Sheets (The little TAbs down the bottom).Creating your first Recipe Google Sheet.We’ve even got a linked up list of all of our recipes: Click to Expand!Ĭlicking the link will take you straight to the recipe. Take a look at my example Christmas Recipe Google Sheet below: Click to Expand! I am no design genius, but you might be surprised. Ugh…but recipes in Google Sheets is ugly, Yagi!!! So rather than try and calculate the changes each time, I put our recipes into a Google Sheet and set it up so that I could plug in a number of batches or a total ingredient weight and then head out and do my shopping accordingly. However, one of the problems I often face is that I need to be able to change the batch size or total ingredient weight of my recipe for when it is just me and Mrs Yagi or when I am hosting a bunch of people for a Christmas party. I do like to cook and over the years I have either inherited or discovered some great recipes. With it comes all the delightful homemade goodies and snacks you get for over the Christmas season. Your very own Google Sheets Recipe Templateįor my culture, the Christmas season has come.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |