Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When designing a template, you can add predefined content to model the look of a finished spreadsheet or even to provide instructions and other productivity aids for template users. Let's continue to use our spreadsheet named Running Club Template, which already has quite a bit of content added, but let's add some more. We'll begin with the text box. Click the Text Box button, which adds the default text box containing the word Text. We'll move that into position in the top-left corner. Let's stretch it out by dragging the right handle, about half way across our table.
Now, we'll double-click inside to select the word Text and type in our own. Let's type in Running Club. Now, we'll reselect that text by dragging across it, and let's change the Font attributes. We'll start with the font name for example. Let's scroll down our list until we see the Gs where we can choose Gill Sans. Now, let's change the Point size. From the Format Bar, we see it's currently set at 11 points. We can click this button. Let's try something much larger like 36. That looks pretty good there.
Now, we can deselect by clicking the Canvas. Let's add a shape now, which is actually just going to be a straight line underneath our title to separate it from the rest. Click the Shapes button, and right at the top, we'll choose a Straight Line. It gets added right to the middle of our Canvas, but we can drag that up underneath Running Club. We'll line it up with the edge, and let's drag it across. Hold down your Shift key while you are doing this to keep it perfectly straight and leveled. Let's go all the way to about just after our chart title Monthly Distance vs Goal. Now, we can deselect that by clicking the Canvas. It looks pretty good.
Let's switch over to our second sheet called Member List now. Here we have a table but there is really nothing in the table. We can add content to the table that will also act as instructions to the people using this table. So for example, we can put in some labels across the top here. At the top of column A, we'll click cell A1 and type in Name; that's where the member name will go. Press your Tab key to move across. Let's type the Address, Tab again to move across. Here is where the phone number will go, so we'll type in Phone, Tab across again, we'll type in Email and once more for column E, we'll type in Photo.
So now we've got content in our table, but this content really access instructions as well as to what is supposed to go in each column. You can deselect the table by clicking the Canvas to see the end-result. Now, of course we need to save our changes. So we'll need to save this spreadsheet, Command+S is the keyboard shortcut, and now our future template is beginning to look like a finished spreadsheet.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 75220 Viewers
80 Video lessons · 130053 Viewers
52 Video lessons · 64198 Viewers
59 Video lessons · 50001 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.