Follow the instructions below to design the borders for the rest of the invoice.Ĭentered across columns select B18:D18 and click Merge and Center. We now know how to apply borders in different styles and layouts. Select the cell range, then click the Borders menu, then Line Style and choose the thick line.Ĭlick the Borders menu and then choose Left Border. Next, we’ll create a block from cell range F6:F13 and apply a thick border, but this time, only on the left edge. Some of these boxes will use different border styles and column sizes. Now that you know how the border and outline tool works, we are going to create additional boxes within the spreadsheet for storing information. Create another box by selecting cell range A12:C16 then repeat the same steps to apply a thick outside border. Select the Home tab, click the Borders menu then select Thick Outside Borders. Next, create a block by selecting cell range A6:C10. Select column A, then click Home, Format, Column Width and enter 12. The table you create will define the data entry points. Formatting an Invoice Table: Adding Borders and Sizing Columnsįormatting your invoice will require resizing columns and using the borders and the outline tool.

That may seem complex overall, but the tasks themselves are simple if you approach them step-by-step. Adding formulas for totals and subtotals.Formatting the table in Excel: adding borders and sizing columns.We’ll be breaking down the construction of our invoice template in Excel 2016 into several different tasks: Creating a Custom Invoice Template in Excel 2016: The Big Picture

Invoice microsoft