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

Opening a Copy of an Existing Workbook

To open a copy of an existing workbook: 1. Press Ctrl+F1 (new in Excel 2003), or select Task Pane from the View menu. 2. In the New Workbook Task ...

Auto-Recovering/ Auto-Saving a Workbook

Excel saves a copy of Excel file periodically, in this article we’ll learn how we can recover the file that was never saved by you. When we open the...

Reducing the Workbook Size for Quick Sending via E Mail

To reduce the workbook size: 1. Press Ctrl+End to find the last cell in the used area within the sheet. In the screenshot, the last cell is E17. 2...

Coloring Gridlines

To color the gridlines: 1. From the Tools menu, select Options, and then select the View tab. 2. In the Window options section, choose a color fro...

Selecting a sheet from shortcut menu in Microsoft Excel

To the left of the sheet tabs in the horizontal scroll bar row are several small arrow buttons. Place the mouse pointer over one of the arrows and rig...

Selecting a Sheet in the Workbook

Using keyboard shortcuts To select to the next sheet in the workbook, press Ctrl+Page Down. To select to the previous sheet in the workbook, press...

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