If you've known some unique shortcuts, please don't forget to comment.
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - While
F5 - Go To
F6 - Next Pane
F7 - Spell Check
F8 - Extend Mode
F9 - Re-calculate Workbook
F10 - Activate Menu Bar
F11 - New Chart
F12 - Save as
Ctrl + : - Insert Current Time
Ctrl + ; - Insert Current Date
Ctrl + " - Copy Value from Cell above
Ctrl + ' - Copy Formula from Cell above
Ctrl + Shift + ~ - General Format
Ctrl + Shift + ! - Comma Format
Ctrl + Shift + @ - Time Format
Ctrl + Shift + # - Date Format
Ctrl + Shift + $ - Currency Format
Ctrl + Shift + % - Percent Format
Shift + Ctrl + F6 - Previous Workbook Window
Ctrl + Shift + F3 - Create names by using name of rows and column labels
Ctrl + Shift + F6 - Previous Window
Ctrl + Shift + F12 - Print
Alt + Shift+ F1 - new Worksheet
Alt + + - AutoSum
Ctrl + ' - Toggle Value
Ctrl + Shift + A - Insert argument names on into formula
Alt + Downarrow - Display Auto Complete list
Ctrl + F7 - Move Window
Ctrl + F8 - Resize Window
Ctrl + F9 - Minimize Workbook
Ctrl + F10 - Maximize or Restore Workbook
Ctrl + F11 - Insert 4.0 Macro Sheet
Ctrl + F12 - File Open
Alt + F1 - Insert Chart
Alt + F2 - Save as
Alt + F4 - Exit
Alt + F11 - Visual Basic Editor
Ctrl + A - Select All
Ctrl + B - Bold
Ctrl + C - Copy
Ctrl + D - Fill down
Ctrl + F - Find
Ctrl + H - Find and Replace
Ctrl + G - Go to
Ctrl + I - Itallic
Ctrl + K - Insert Hyperlink
Ctrl + N - New Workbook
Ctrl + O - Open
Ctrl + P - Print
Ctrl + R - Fill Right
Ctrl + S - Save Workbook
Ctrl + U - Underline
Ctrl + V - Paste
Ctrl + W - Close Workbook
Ctrl + X - Cut
Ctrl + Y - Repeat
Ctrl + Z - Undo
Ctrl + Shift + ^ - Exponential Format
Ctrl + Shift + & - Place outline border around cells
Ctrl + Shift + _ - Remove outline border
Ctrl + + - Insert Column or Rows
Ctrl + - - Delete Column or rows
Ctrl + Shift + Arrow - Select all Columns/Rows with fill
No comments:
Post a Comment