Simple+Excel+Tips+and+Tricks

These Simple tips and tricks can be done in Microoft Excel 2007. They will make your job and your life easier.


 * __1) Easily write the current date and time.__**

Just enter //=NOW// into any cell, and Excel displays the date and time formatted according to the regional options you've set for Windows. If you just want to see the date, use the TODAY function, =TODAY, instead. But be careful, it will autmatically update whenever your spreadsheet is re-opened, so what you can do is set a fixed date, so to do that, into a cell--a date that you don't want to change--hold down //Ctrl// while you press the semicolon ( //;//) key. To insert the current time (without a date), press //Ctrl-Shift-Semicolon//.

This is how it will appear, you can then format the date like we learned in the first advantage training guide. 2) **__Use Shortcuts__**

You will most likely use these shortcuts when workng with excel on a daily basis.
 * Ctrl+Z || Undo ||
 * Ctrl+C

Enter, Ctrl+V Ctrl+X || Copy,

Paste, Multiple Paste, Cut || Ctrl+H || Find, Find&Replace || Ctrl+S, Ctrl+F4, Alt+F4 || Print, Save, Close, Close Excel || to edge of region || current region || all cells || Ctrl+End || Select A1, Select last cell in used range || from active cell to last cell in used range. || from active cell to A1 || Down Ctrl+Page Up || Move to the next sheet, Move to the previous sheet || to next open workbook || new workbook || new worksheet ||
 * Ctrl+F,
 * Ctrl+P,
 * Ctrl+Arrow || Move
 * Ctrl+* || Select
 * Ctrl+A || Select
 * Ctrl+Home
 * Ctrl+Shift+End || Select
 * Ctrl+Shift+Home || Select
 * Ctrl+Page
 * Ctrl+Tab || Move
 * Ctrl+N || Open
 * Shift+F11 || Insert
 * Shift+F3 || Paste ||

__**3) Show and Print all formulas**__

To quickly show all formulas in your Excel spreadsheet hold down the **CONTROL** key on the keyboard and press the grave accent key ( **`** ). This key is located next to the #1 key on the top left corner of the keyboard and looks like a backwards apostrophe. Show formulas does not change the spreadsheet, only the way it is displayed.

I will use Homework 5 as an example

Vicklyn Estime Info 273 Dr. William Colucci