Excel Shortcuts & Functions
CTRL W
Close Window
ALT A F W
Data from Web
V Look Up =VLOOKUP(1,A2:C10,2)
Using an approximate match, searches for the value 1 in column A, finds the largest value less than or equal to 1 in column A which is 0.946, and then returns the value from column B in the same row.
ALT + P + V + G
View Gridlines
SHIFT F3
"Insert Function" Box
If Function Ie. If Cell Q5 is $0, make cell blank. If not then = Q5 / Q6
=IF(Q5=0, " ",Q5/B69)
Look Up =LOOKUP(Value ,A2:A6,B2:B6)
=LOOKUP(Value ,A2:A6,B2:B6) Looks up value in Column A, rows 2 - 6, and returns value from column B same row. A2:A6 is the entire range.
Today's date Function
=today()
ALT H H L
Conditional Format
CTRL '
Copy Above Formula
CTRL '
Copy formula from Above Cell
SHIFT CTRL "
Copy value from Above Cell
CTRL T
Create Table
SHIFT CTRL $
Currency Format
CTRL X
Cut
SHIFT CTRL #
Date Format
CTRL + -
Delete Selected Cell
CTRL ]
Dependents
ALT '
Display Style
ALT (DOWN)
Display a Drop-Down list
CTRL ;
Display date
SHIFT CTRL :
Display time
ALT M V
Evaluate Formula
SHIFT CTRL ^
Exponential Format
CTRL D
Fill Down
CTRL R
Fill Right
CTRL ENTER
Fill Selection with Entry
CTRL F
Find
SHIFT F5
Find
CTRL 1
Format Box
ALT H F P
Format Painter
ALT H F
Formatting
SHIFT CTRL ~
General Format
CTRL G
Go to
CTRL Arrow Keys
Go to End of contiguous range
CTRL 0
Hide Column
CTRL 9
Hide Row
SHIFT + SPACE
Highlight Row
SHIFT CTRL Arrow Keys
Highlight contiguous range
ALT =
Insert AutoSum Formula
ALT N K
Insert Charts
SHIFT F2
Insert Comment
H Look Up =HLOOKUP("Axles",A1:C4,2,TRUE)
Looks up Axles (as a header) in row 1, and returns the value from row 2 that's in the same column. A1:C4 is the entire range.
ALT F8
Macro Box
CTRL F1
Min/ Restore Ribbon
CTRL HOME
Move to Cell "A1"
ALT H O M
Move/Copy a sheet
SHIFT CTRL !
Number Format
SHIFT CTRL &
Outline Border
ALT P S P
Page Setup
CTRL ALT V T
Paste Format Only
CTRL ALT V
Paste Special
SHIFT CTRL %
Percentage Format
ALT N V
Pivot Table
CTRL [
Precedents
CTRL P
ALT F W V
Print Preview
SHIFT CTRL _
Remove Border
CTRL Y
Repeat
F4
Repeat or Anchor Cells
CTRL H
Replace
CTRL S
Save
CTRL A
Select All
CTRL SPACE
Select Column
SHIFT CTRL *
Select Region
SHIFT Arrow Keys
Select a cell range
CTRL ~
Show Formulas/Values
ALT A S
Sort Options
F7
Spell Check
=
Start formula
CTRL 5
Strike-through
CTRL Pg Up/Down
Switch worksheets
SHIFT CTRL @
Time Format
SHIFT CTRL }
Trace ALL Dependents (Indirect)
SHIFT CTRL {
Trace ALL Precedents (Indirect)
ALT R G
Track Changes
ALT W F
Un(freeze) windows
ALT W S
Un(split) panes
CTRL Z
Undo
SHIFT CTRL 0
Unhide Column
SHIFT CTRL 9
Unhide Row
ALT F11
Visual Basic Editor
