Changing the Font Size of the Sheet Name in Excel 2007

To change the font size of the sheet tab: 1. Minimize all open applications by pressing Windows button + M, and right-click the desktop. 2. Select...

Using a Workspace to Open a Number of Workbooks at Once

Saving open workbooks in a workspace enables them to be opened together at a later time. This is important when working with linked workbooks. To s...

Saving a Customized Workbook as a Template

In this article, we will learn How to save your workbook as a template in Excel. Templates in Excel Users who are working on excel for a lon...

Displaying the Workbook's Path in the Address Box

To display the active workbook's path and name in the Address box: 1. Place the mouse pointer over one of the toolbars, right-click, and select Cus...

Recovering Data from a Corrupted Workbook That Cannot Be Opened

To recover data from a corrupted workbook: 1. Add a new workbook, and save it using the name of the corrupted workbook, but in a different folder t...

Inserting a New Sheet from a Template Sheet

For an explanation on how to create and save a new template workbook. In this example, the template workbook name is Book.xlt (except for Excel 2000...

Selecting a Sheet from a Sorted Sheets List

To select a sheet from a list of sheets sorted in ascending order, install the ChooseSheet.xla Add in: 1. Download the ChooseSheet.xla add-in by j...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.