I’ve also included an “Other” line for special jobs that might come up or for any other information that may need to be included in the customer’s file. Make lines for the order number, customer name, address, city, state and zip, contact number, job starting date, and a place to check off what type of job this will be. Start the customer information section on H9 and skip every other line so that there is more room to write. I moved the logo I’m using to the center.įor the company address, merge and center H7– K7. If your logo is too big for the area, you can use Excel to crop or resize it by right clicking on the image and choosing Format Picture.īy clicking on the picture and selecting it, you can drag it to wherever you want inside that cell. Select the merged cell then click the INSERT tab at the top, find the Pictures button, and click on it. The other columns will become “Hrs”, “Rate” and “Amount”. Select C18 and D18 and merge those cells. The labor section will begin at Cell C18 and span across to G18 down to Row 26. We’ll fix that when we’re putting in the lines/borders. G1 will be the “Amount”.įor right now, leave the rows beneath “Unit” separated. Merge Cells E1 and F1 for the “Unit” column. Depending on how wide Column D is, you might want to expand it a little to the left to make room to list materials. Drag the line divider between Column C and Column D to the right to make a quantity column. The materials section will start at cell C1 and span across to cell G1 down to Row 17. With A1 still selected, click on the “A” next to the paint bucket and choose white for the text. In the HOME tab look at the font section and locate the Paint Bucket. To make the headings stand out, you can now go back and add a background to the cell. Once clicked, your heading will span across both Column A and Column B. At the top, Under the HOME tab, find the Merge & Center button. Left click on cell A1 and drag your cursor to the right to highlight cell B1. The checklist has about 4 headings and these headings should span both Column A (the check boxes) and Column B. Since the lawn care service work order has a long checklist, I’m going to begin typing my list in Column B. Click on the line dividing Column A from Column B.ĭrag that line to the left, making Column A as small as you’d like. The lawn care service work order has check boxes for marking off job requirements and Column A looks like a good spot to place them. Excel is letting you know where your page margins are. You may see a faint dotted line running vertically and horizontally across your blank document. Then click on the margins tab to set your margins. On the first page, let Excel know what orientation your form will be. Set your page margins by clicking on the PAGE LAYOUT tab. 25″ away from the edge of the page so that it will not be cut off. You always want to be sure that your important information is. I will be using our lawn care services work order form as a base to work off of but will be transforming it into a layout that can be recreated in Excel or other spreadsheet programs. The purpose of this tutorial is to help landscapers create a custom form based solely on their business needs. Today I will be using Microsoft Excel 2013 to design a lawn care services work order. Ap9:53 am Published by Progressive Printing Team Leave your thoughts
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |