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

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

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 Google PlusVisit Us On Youtube