How to Quickly apply Currency number format in Excel

In this article, we will learn How to Quickly apply Currency number format in Excel. Scenario: To get the currency format Go to Home tab and...

Color sheet tabs

Adding color to sheet tabs has become very easy.  Starting from Excel 2002, this task can be easily accomplished.  For example, you could make the t...

Creating Page Breaks without VBA

Many excel users insert blank rows within their files so that the sheets print out properly with the required number of rows on each page.  However, ...

Spice up the borders

Most Excel users use only the Borders tool on the toolbar and assume that borders are only solid, black, thin lines. In fact, when applying borders to...

Centre a title across a worksheet

Its really easy to make your spreadsheets look more professional by centering your tittle across the top of your sheet. In the example our heading ...

How to Copy Conditional Formatting in Excel

In this article, you’ll learn how to copy conditional formatting in Microsoft Excel. This will enable you to copy the highlighted (highlighted due t...

Custom Format to show Units without changing Number to Text

Sometimes we need to show the numbers in Units of Measure (e.g., KG, LB, KMS, CM ... etc) Generally people do this by using Text function but after...

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.