Increasing/Decreasing the Screen Magnification Percentage

To quickly increase or decrease the screen magnification percentage: 1. Select a cell. 2. Press Ctrl, and roll the mouse wheel forward (to increas...

Coloring Sheet Tabs

To color the Sheet tabs (new in Excel 2002 and Excel 2003): Select a sheet tab, right-click, and select Tab Color from the shortcut menu. Screensh...

Open file as copy in Excel 2007

Sometimes you need to make a copy of the file and work on it, so that you do not alter the original file.  When you open a file as a copy, a duplicat...

Open file as copy

Sometimes when we want to create a new workbook based on an existing file, we open the original file, we intend to use the Save As command to save the...

Quick Analysis in Excel 2013

In Excel 2013, you can do quick analysis like preparing quick charts, quick formatting, converting to table etc. Quick Analysis, as shown in below ...

Calculating just the worksheet NOT whole workbook

If you have huge number of complex formulas in your workbook and it takes long time for workbook to calculate the formulas everytime you enter a new f...

Monthly expense report for colleagues

Dear friends, Here is a simple, most useful application for colleagues. Find an example with the attached file. Don't confuse with the names noted ...

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