Copy & Paste
The base shortcut for a simple copy-paste
ctrl + c / ctrl + v
Autofit Column Width
alt + h o i
Adding a filter
alt + a t
How to navigate from one side of data to the other
ctrl + arrow keys
Breaking external links
alt + a k
Opens the "Paste Special" Menu
alt + e s
shortcuts to change alignment of text within cells
alt + h a l
alt + h a r
alt + h a c
Clearing a filter
alt + a c
How to return to the beginning of each sheet
ctrl + home
Where to create hotkeys (description)
File -> Options -> Quick Access Toolbar
When you want to copy Formatting over from another cell
alt + e s t
Shortcut to create a bottom border
alt + h b o
How to group AND ungroup rows/columns
alt + a g g
alt + a u u
Freeze frames
alt + w f f
Run Spell Check
F7
To paste a formula without changing formats
alt + e s f
Shortcut to open up color fill menu
alt + h h
To open a filter
alt + down arrow key
Where to find the "subtotal" menu (description or shortcut)
Data tab -> outline
(alt + a b)
Undo for Alex
CTRL + Zed
to select visible cells ONLY before you paste something
alt + ;
How to add or remove gridlines
alt + w v g
Removing Duplicates
alt + a m
Opening a new window
alt + w n
How to add a drop down menu for a cell (description)
Data validation -> Allow "List" -> enter values separated by commas