Handy Excel Tips

This article introduces you to “Define Name” feature of excel with which you can give a name to any cell or range of cells and then just use that particular name in other formula’s like vlookup, offset, match etc without having to select it manually every time.

Read the rest of this entry »

Popularity: 16%

Did you ever wonder why can’t you find asterisk and question mark in your spreadsheet.This article explains it all.

Read the rest of this entry »

Popularity: 28%

If you right click on the chart, you would not see a delete option. So to delete a
chart, just select the chart area with a single mouse click and press the Delete key.

Popularity: 4%

Long route: Copy the cell (CTRL+C) and then select the range by holding the shift key and paste it((CTRL+V).

Short route: No need to copy the cell. Just select the range including the topmost cell by holding the shift key and hit CTRL+D.

Popularity: 7%