![]() Hopefully that took a lot longer for me to write than it took for you to do. Give it a nice, descriptive title like 2007 Plant Purchases and press the Enter key. When you’re all done, it should look like this:īy now you’ve seen this warning (Figure 8). But I always add three more columns, and I recommend that you do, too: Page, Plant Where? and Notes. That takes care of the columns in the order form. Drag it a good ways past the end of the word, because you usually need a big space to describe the item.Ĭontinue typing in the rest of the column headers: Price per package and Total Price. Hover your cursor over the line separating the two cells, and when it turns into a line with arrows at both ends, you can drag the border to the right and make the cell bigger. When I type the word Description, it’s half hidden in the box. Figure 5 shows the first cell with text and the second cell with text in the process of being entered. Notice the cell gets bigger? Type the heading text in the cell and then press Tab to move to the next cell. Then we’re going to click on B for bold (circled).ĭouble-click on the first cell. Rows go across.) We want all the headings for our columns to be in bold, so first we’re going to select all of row 1 by clicking on the number one (see red arrow). (Columns go down, like the columns on a porch. I find if I use the same columns as the order form, it makes it easier to transcribe my order when I’ve finalized it. Next, open up your copy of the catalog to the order form. Click the little down-arrow and choose Rename. Down at the bottom of the page is a tab that says Sheet1. So the first thing we want to do is rename the worksheet. In this case, each nursery that I am considering ordering from will have its own sheet. You can have many worksheets in a work book. What we have in front of us (Figure 3, below) is an empty worksheet. Click the words “New Spreadsheet” to begin (Figure 2). Once you’ve logged in, you should see a welcome screen. If you do have a Gmail account, there is a link right in the email program to the spreadsheet program.(See figure 1.) If you don’t have a gmail account, you’ll need to register with Google first. (Note: Hover your mouse over the illustrations to see the accompanying caption.) ![]() Fortunately, we’re not going to be doing anything that complicated. Or, start out with a Google spreadsheet and then save it to your hard drive as an Excel file. pdf file has the least you need to know to use Excel. If you have Excel on your computer but have never used it, this. I do have Excel and I have used it in the past for these kind of spreadsheets. I will be using it for this tutorial because I can give you all a link to the finished product, and because even if it isn’t ideal, it’s the one program most likely to be accessible to all. Or what if your cable modem goes on the fritz? Or you’re on dial-up? Then an online spreadsheet is not the best solution. I know it seems unlikely, but what if Google’s servers went down? You’d lose all your work unless you’d made backups. ![]() So this is great if you want to assemble a group order with fellow gardeners, for example. Also, Google’s Spreadsheet program is designed so that many people can work on the same file. If you need to work on a spreadsheet from more than one physical location, such as both home and work, this is an advantage. The advantage of this is that anyone with access to the internet can use it. Google’s Spreadsheet program is only available online. Another alternative is Google Docs and Spreadsheets, which is what I am going to use for my tutorial. A free alternative would be Calc, but that involves a huge download and a lot of disk space. Many home computers come with one or the other of these, but not all. Most people get it included in Microsoft Office, or the less powerful version, Microsoft Works. The most common spreadsheet program is Excel, made by Microsoft. When you change the number in one cell used in a calculation (called a formula), it recalculates the formula and updates the answer. But that doesn’t help you much if you don’t know a spreadsheet from a tablecloth, so let’s start right there: a spreadsheet is a computer program that arranges numbers in a table and allows you to make calculations in the cells of the table. Others have mentioned using a spreadsheet to track their seed sowing. I mentioned in a recent post that I use a spreadsheet to plan my garden purchases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |