![]() ![]() 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 |