Change Excel's default font in Excel 2007

MS Excel 2007 by default uses the Body Font font in font size 11. When you type data in a worksheet,  text box, header or footer, it will appear as t...

How to Change Excel default font and font size

In this article, we will learn How to Change Excel default font and font size. New workbook in Excel When a user opens a new workbook in Exc...

How to Hide gridlines in Excel

In this article, we will learn How to Hide gridlines in Excel. Scenario: Default features of Excel helps you work on data rather than its form...

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

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.