The Best Shortcut Keys in Microsoft Excel

Ctrl+Z	Undo
Ctrl+C Enter, Ctrl+V Ctrl+X	Copy, Paste, Multiple Paste, Cut
Ctrl+F, Ctrl+H	Find, Find&Replace
Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4	Print, Save, Close, Close Excel
Ctrl+Arrow	Move to edge of region
Ctrl+*	Select current region
Ctrl+A	Select all cells
Ctrl+Home Ctrl+End	Select A1, Select last cell in used range
Ctrl+Shift+End	Select from active cell to last cell in used range.
Ctrl+Shift+Home	Select from active cell to A1
Ctrl+Page Down Ctrl+Page Up	Move to the next sheet, Move to the previous sheet
Ctrl+Tab	Move to next open workbook
Ctrl+N	Open new workbook
Shift+F11	Insert new worksheet
Shift+F3	Paste function window
=+FunctionName+Ctrl+A	Insert new function
Alt+F11	Open VBE
Ctrl+Shift+Enter	Array formula
Ctrl+F3, F3	Define name, Paste name
Ctrl+Spacebar Shift+Spacebar	Select columns, Select rows
Ctrl+1, Ctrl+B, Ctrl+U	Format cells, Bold, Underline
Ctrl+; , Ctrl+shift+:	Current date, Current time

Excel: Change the font color based on the value in the cell in Excel 2003/XP/2000/97

To do this, select the cell that you wish to apply the formatting to. In this example, we’ve selected cell B8.

Under the Format menu, select Conditional Formatting.

When the Conditional Formatting window appears, enter the first condition. In our example, we’ve selected when the cell value is greater than 10.

Next, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.

When the Format Cells window appears, select the formatting conditions that you wish to apply. We’ve changed the Color to Red. Then click on the OK button.

If you wish to apply more than one condition, you will need to click on the Add button.

We’ve added three different conditions. When you’re done, click on the OK button.

Now when you return to the spreadsheet, the conditional formatting will be applied. As you can see, the value in cell B8 appears in red.

Turn Excel Data and Charts into JPEGs

Read this from PC MAG. Nice little trick

http://www.pcmag.com/article2/0,2817,2269778,00.asp