The Green($) for Green
- Merge the cells that contain your business name and address.
- Highlight cells A1 and B1 (hold down your shift key when highlighting more than
one cell)
- Under Format, choose Cells, then Alignment
- Choose the “Merge cells” box
- Repeat for A2 and B2, A3 and B3, A4 and B4
- Make your company name and address stand out by changing the font type and size.
- Highlight the desired cells (A1-A4)
- Under Format, choose Cells, then Font
- Make your choice!
- Aligning numbers to the right, left or centre.
- Highlight the desired cells
- Choose the left, centre or right alignment button in the toolbar
Note: Align the text to the left and the unit cost, quantity and prices to the right.
- Show dollar signs where necessary.
- Highlight the desired cells
- Under Format, choose Cells, Number, then Currency
- Do this for all cells that will have a $ sign (remember to highlight blocks of cells to save time)
- You may wish to insert a picture on your invoice
- Under Insert, choose Picture, then Clip Art
- Click on a picture
- Drag picture to desired location
- Save your spreadsheet.
- Under File, choose Save As
- Use a suitable file name