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

Change Excel's default font

Incase you want to change the default font that excel uses, following the given steps to change it - 1. Click on Tools-> Options 2. Click on ...

Hide gridlines

The gridlines showing in your excel spreadsheet are very useful, specially when you need to create a template or format a report.  But if you do not ...

Quickly apply currency number format

If you need to quickly format numbers in your worksheet to currency format, press Ctrl + Shift + $ and it will apply the currency format with 2 decima...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube