From Cathy…
Windows N Minimize
Windows E Explorer
Alt Tab Move to next application
Alt F4 Close application
Right Click & Tile Vertically Share desktop w/more than 1 app
Double Click Upper Bar Maximize
Right Click on Tab Arrows Gives list of active worksheet tabs
Ctrl * Highlights all columns and rows that are connected
Ctrl ~ Shows all equations
Ctrl 0 Hides Column
Ctrl-Shft ) close paren Unhide Column
Ctrl 9 Hides Row
Ctrl-Shft ( open paren Unhide Row
Ctrl A Highlights a section
Ctrl B Bold
Ctrl I Italics
Ctrl P Print
Ctrl S Save
Ctrl U Underline
Ctrl V Insert
Ctrl X Cut
Ctrl Z Undo
Alt F List of Recent Documents
Alt Shows the keystrokes for visible functions
Paste Special Transpose Takes number Vertically & puts them horizontal and vice versa
F9 Refesh in Excel and Updates in Word
Sequential #'s Hold down Ctrl and drag
From Dr. Jerz…
F4 Toggles relative to absolute referencing
Ctrl Y Repeats last action
F1 Help
FREQUENCY (data, bins) Ctrl-Shift-Enter
Mode Excel can only show 1 mode so be careful of using Mode
Conditional Formatting This is under the Home Ribbon
Highlighting words or numbers that meet certain criteria
Data Subtotals This is under the Data Ribbon
Highlight data you want sub-total
Chose the Category you want the subtotal change
Choose what you want totaled
Example: 5 people with 5 purchases from Wal-mart
Sub-total at the name and Sum the purchases
Data Analysis Pack This is under the Data Ribbon (once installed)
Go to Office Button At Top to Install
Choose Excel Options
Go to Add-in
Choose Analysis Pack and hit Go
Click on the box for Analysis Pack
Freeze Frames This is under the View Ribbon
This will freeze rows and columns that you want to remain visible on your spreadsheet
Goal Seek This is under the Data Ribbon
Click on the down arrow in What-If Analysis
Chose Goal Seek