Then make the font of Bill to text white and make it Bold.Next go to the fill color option and select dark blue color to fill the selected area.We will go to cell B11 and select B11 to C11 by holding down the Shift + Right Arrow key. ![]() Next we will format the Bill to field and to do so: Apply the same formatting to I8 by clicking on the cell and then pressing F4, which is used to repeat the last action.We will also change the format of the dates by going to cell I6, going to the cell format option and then from the number tab select the date category and from there, choose the “d-mmm-yy” format and click on OK.Now, select I5 to I8 and change its alignment to center so that it appears more organized and neat.You can add the days according to your preferences to reflect due date. So, to do that: Click on cell I8 and type “=I6+20” and then hit enter.Īs you can see that doing this has returned the date that will fall after 20 days from today. Next we have to enter the date when the payment will be due.So go to cell I7 and enter the TODAY function and press enter.We will type in the “Customer ID” and for the “Invoice date” we will make use of the TODAY function as an invoice always needs to reflect the current date. Now, enter the values for the above details in the corresponding table we made.Now we will make this text Bold to further enhance its appearance. Increase the Indent from 0 to 2 and click on OK.Īs, you can see, now the text looks more indented and better than before.Select right indent from the Horizontal text alignment category.From there, go to the Alignment tab and.This shortcut will open the format cell dialog box. Now, select H5, H6, H7 and H8 and press the CTRL +1 ( Learn 200+ keyboard shortcuts).So, select cell I5 to I8, go to the Home tab and from the Font category select All Borders option. Next we will make a small table in the “I” column where the values for the above categories will be added. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |