Excel shortcut keys
Don't get bogged down in Excel's options and commands. Use this guide to its keyboard shortcuts to fly around the keyboard and get your work done without having to take your hands away to move the mouse all the time.
Ctrl+- Delete the current cell or selection
Ctrl+Shift++ Insert cell or selection
Ctrl+; Insert current date at the selected cell
Ctrl+Shift+; Insert current time at the selected cell
Ctrl+K Insert a hyperlink or web link
Ctrl+Tab Switch to the next worksheet in the workbook
Shift+F3 Open the formula window
F11 Create a chart
Ctrl+Space Select all of the current column
Shift+Space Select all of the current row
Ctrl+Shift+1 Format the current cell with commas
Ctrl+Shift+4 Format the current cell as currency
Ctrl+Shift+5 Format the current cell as a percentage
Ctrl+Arrow key Move to the next used cell in the direction of the arrow key
Ctrl+F Open the search box
0 comments:
Post a Comment