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

Color Alternate Rows with Conditional Formatting

If you wish to color every Alternate Row in your data with conditional formatting (without using) macro, follow the below quick process:-   ...

Values Not Formatted as Numbers in Excel 2007

Change the column formatting from Text to General by multiplying the numbers by 1: 1. Enter the number 1 into a cell and copy it. 2. Select the co...

Conditional Formatting in Excel

To use Conditional Formatting ready to use rules: Select Home -> Conditional Formatting (in Styles Group) -> Highlight Cells Rules or Top/Bot...

Applying Formatting to Cells Containing Text Only in Excel 2007

To apply formatting to cells containing text only, use Conditional Formatting: 1. Select a range of cells containing text. 2. Select Home-> Con...

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.