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

How to Color Sheet Tabs in Excel

In this article, we will learn How to Color Sheet Tabs in Excel. How to edit format tab color? Introduction to Excel worksheet workbook, Her...

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

How to Open file as copy in Excel

In this article, we will learn How to Open file as a copy in Excel. Why open a file as a copy? When a user needs to open a file and needs to...

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.