Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: Templates

Excel Default Templates

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.xltx To create Book.xltx, execute the following steps. 1. Create a workbook. For example, change the row height of all rows on the first sheet to 30 pixels.…

How to Create Calendar in Excel

This example describes how to create a calendar in Excel (2019 calendar, 2020 calendar, etc). If you are in a hurry. 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 and columns, add borders, change background colors, etc. This is what January 2020 looks like. The…

How To Create Budget in Excel

This chapter shows you one of the many powerful features Excel has to offer. The example below illustrates how to create a budget in Excel. 1. Enter the different type of income and expenses in column A. Note: 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…

Using Existing Templates in Excel

Microsoft office Excel comes with in built Templates. Templates are predefined layouts, patterns, structures built that can be reused. If you often use the same layout or data, 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 Templates To create a workbook based on…