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

Changing the Number of Files Shown in the Recently Used File List

To see the maximum number of recently used files at the bottom of the File menu, change the Recently used file list option to 9. To set the number ...

Opening a Template File Automatically When Starting Microsoft Excel

To have Excel open a template upon starting: Option 1: Save a template workbook file, named Book.xlt (in Excel 2000, the book name is Sheet.xlt)...

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