

In this sample, we simply choose one of preset WordArt Style. Click to select the "RECEIPT" title, the "DRAWING TOOLS / Format" ribbon tab appears, where you have full control over the style and appearance of the text box. Compared to regular text on the spreadsheet form, adding text and label using text box gives you more options on formatting and placing text. The "RECEIPT" title is now implemented as a text box.Before you can create your first invoice, you need to replace it with your business name. "Your Hotel Name" is a placeholder for your hotel / business name.Click OK to close the "Format Cells" dialog box.Click OK to close the "Fill Effects" dialog box.Click one of the fill effect from the "Variants" section.From "Shading Style" section choose "From corner".From "Colors" section, choose "Two colors", make the "color 1" is white and "color 2" is blue.

Right-click the merged cell and choose "Format Cells".On Excel "Home" ribbon tab, click "Merge and Center".Select all the cells on the top line that we'll marge, in this case, $D$3:$N$3.The purpose of enabling protection is to prevent end users from altering the design of the template accidently. All the template here on Invoicing Template are protected by default, but with no password set. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.

So to create this blue gradient bar, we followed the steps below.

