Spell Check

Spell check in Excel has a host of different options: If you have the formula bar selected, start the spell check (Tools menu, Spelling choice or F7). Excel will only check the contents of the formula bar, leaving the rest of the worksheet untouched. If spell check is started with a range of cells selected, only the cells in the selected range will be checked. To check an entire worksheet, select any cell and start the spell check. Finally, to check multiple worksheets, first select the sheet tabs for all of the worksheets. (Use the Shift key or Ctrl key with the mouse to select all the sheets). Now, start the spell check.

Have trouble editing hyperlinks with the mouse in your MS Excel worksheets?

The easiest way is: click and hold the mouse button down on the cell with the link. After a couple of seconds, you'll notice the cursor change into a plus sign and then you're free to release the mouse button. You'll find that the cell has been selected without activating the link. Then use the F2 key or the Formula bar to edit the text.

MS Excel

In Ms Excel, to break up a long cell entry into separate lines, position the cursor where you want a new line to start and press Alt+Enter.
Excel will expand the row to accommodate wrapping lines of text. Press Enter to complete the entry.

MS Excel

Here are some quick highlighting tips for Ms Excel:
Hit Ctrl + Spacebar to select the entire column. Use Shift + Spacebar to select entire the row.

MS Excel

You can color-code sheet tabs in MsExcel for easier identification or grouping of related sheets. Here's how: Select the sheets you want to color by Press the CTRL key and click the tab(s) to select the sheets you want to color. Right-click the sheet tab and then click Tab Color. Select the color you want, and then click OK

MS Excel

Ever have to create a column of formulas that are very similar? When you completed a copy/paste, were you upset to find that the cell references were changed during the paste? The ability to force Excel to perform an exact copy of the contents from the cell above your current location might just come in handy: To get an exact copy (no cell reference changes at all) of the cell directly above, simply use Ctrl + '. Select a cell, hit Ctrl + ' and poof, the contents of the cell above are duplicated immediately!

MS Excel

Want to use the Find/Replace function in a multiple worksheet MS Excel file? Use either the Ctrl key or the Shift key in conjunction with the Sheet Tabs to select all the worksheets that need to be searched. Then start the Find /Replace feature (Ctrl + F or the Edit menu, Find choice).

MS Excel

To add an Ms Excel chart, select a cell in the data and hit F11. Double click to make any changes. If items are missing, right click over the area to be changed.

MS Excel

Do you want to change the number of decimal places displayed in one of your MS Excel cells? Use the two buttons located on the Formatting toolbar or in Excel 2007, they're on the Home ribbon, Number section. The button on the left will add decimal places to numbers in highlighted cells and the one on the right will reduce them. (As decimal places are reduced, the value displayed in the cell is rounded. The formula bar will have the exact value stored

MS Excel

A quick way to see all the formulae on your Ms Excel worksheet is to Touch CTRL+~ (tilde ~ character – upper left of keyboard). This is an ON/OFF toggle – touch CTRL/~ again and it brings the results back and hides the formulas. Another method is to select the Tools menu, select Formula Auditing and choose the Formula Auditing Mode.