Excel Formulas Tutorial, Make it Easy!

Like us on Facebook

Banner

Labels

Ads

ads

Search This Blog

Powered by Blogger.

Blog Archive

Saturday, December 8, 2018

Excel101: Excel Keyboard Shortcut

Below are list of Excel Shortcut that can make your everyday use of excel faster and easier.

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