Book.xltx and Sheet.xltx are two special templates you can create and add to the XLStart folder. As a result, Excel uses Book.xltx as the basis for new workbooks and Sheet.xltx as the basis for new worksheets. Book.xltxTo create Book.xltx, execute the following steps. 1. Create a workbook. For example, change the row height of all […]
This article describes how to automate the generation of invoices in Excel. If you are in a hurry, simply download the Excel file. This is what the spreadsheet looks like. If you select a Client nr from the drop-down list in cell E6, Excel automatically fills in the client information. If you select a Product […]
This article describes how to create a simple invoice in Excel. 1. Click the Select All button and change the background color to white. 2. Our invoice template is 3 columns wide. Column A: 418 pixels. Column B: 70 pixels. Column C: 90 pixels. Click on the right border of a column header to change […]
This article shows you how to create a meal planner in Excel. Here’s what we are trying to achieve: 1. On the second sheet, create the following named ranges. Note: you can add 7 more breakfast meals in the future without changing the range address. 2. On the first sheet, select cell C4. 3. […]
This example shows you how to create a budget in Excel. 1. Enter the different type of income and expenses in column A. – On the Home tab, in the Font group, you can use the different commands to change the font size and font style of text. Click on the right border of the […]
This example describes how to create a 2016 calendar in Excel (or 2017 calendar, 2018 calendar, etc). If you are in a hurry, simply download the Excel file. Note: the instructions below do not teach you how to format the worksheet. We assume that you know how to change font sizes, font styles, insert rows […]
Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used. Existing TemplatesTo create a workbook based on an existing template, execute the following steps. 1. On the green File tab, click New. 2. To choose a template from […]
