Saving a Customized Workbook as a Template

Why it is important to save a customized workbook as a template: * Allows you to save custom Styles. * Allows you to save Print Setups options as ...

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...

Create a hyperlink from a string in Microsoft Excel 2010

In this article we will learn how to create a hyperlink from a string, we need to use the Hyperlink function in Microsoft Excel 2010. We will learn n...

Changing the font size of the Sheet name in Microsoft Excel

The Sheet tabs in a workbook are part of the Scroll Bar. Change the font size in the Scroll Bar option to change the font size of the Sheet name in t...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube