BoostExcel main content

Labor Invoice with Gradient Border

Template#: c4076

Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
361 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Labor Invoice with Gradient Border

Detail

This form differs from the original version in that it adds a gradient border to surround the entire printable form.

There are other formats that use a form border too.

This form implements the border in another way. It uses the fill effect of Excel cells. We'll use the Labor Invoice Template (c4070) as the base template.

In order to implement the borders using Excel's fill effects, we'll need to first add four rows and four columns to the existing printable form that surround the printable area. We'll use the outer rows and columns to mimic the borders and the inner rows and columns to adjust the space (or margin) between the borders and actual content. The detailed procedure is demonstrated in c5085. In this tutorial, we'll not cover those details again but start with how to create borders using the fill effects of cells.

The cells on each side should be merged. For example, on the left side, we merge the cells from D2 to D51. To merge the cells, first drag your mouse to select all the cells to merge, and then click "Merge and Center".

Now the interesting part is to fill the (merged) border cells with gradient colors. To do this, follow the steps below.

  1. Right-click one of the merged cells (for example, the left vertical border cells) and choose "Format Cells".
  2. Go to the "Fill" tab, and then click "Fill Effects".
  3. On the "Gradient" tab, choose "Two colors".
  4. From the color drop-down lists, choose two colors separately. Usually, you choose one dark color and another bright color.
  5. From the "Shading Styles" section, we choose "Horizontal" for the left vertical border.
  6. Click to choose one of the "Variants".
  7. Click OK to confirm the settings of the gradient colors.

Set the gradient fill effects for the other three borders: the top horizontal border, the right vertical border, and the bottom horizontal border. In this design, make sure all four borders use the same dark color and the same bright color. By combining the proper selection of shading variants, we get the result shown in the screenshot images. You may like to play with other possible options too.

Format and Specification

Template#c4076
Belongs to
Format (XLS or XLSX).xlsx
Columns4
Lines8
Line Height (Points)30.00
Print Area$D$2:$P$51
Papaer OrientationPortrait
Default Margins (Points)
Left27.36
Right22.68
Top50.76
Bottom45.35
PriceFree

Related

Labor Invoicing Sample Thumbnail
Parts and Labor Invoicing Format Thumbnail
Beautiful Service Invoice Template with Hourly Rate Thumbnail
Sample Service Invoice Template: Using handwritten Signature Thumbnail
Independent Contractor Invoice Thumbnail
Hourly Invoice Template Thumbnail
Engineering Invoice Template Thumbnail