Know Your Office Application!
keyboard shortcuts can be less demanding than using the touchscreen and are an essential alternative to using a mouse. This article itemizes the keyboard shortcuts for office applications on Windows.
Ctrl + A - Select All
Ctrl + B - Bold
Ctrl + C - Copy
Ctrl + D - Fill Down
Ctrl + E - Align center
Ctrl + F - Find
Ctrl + G - Goto
Ctrl + H - Replace
Ctrl + I - Italic
Ctrl + J - Justify
Ctrl + K - Insert Hyperlink
Ctrl + L - Align left
Ctrl + N - New Workbook
Ctrl + O - Open
Ctrl + P - Print
Ctrl + R - Fill Right
Ctrl + S - Save
Ctrl + U - Underline
Ctrl + V - Paste
Ctrl + W - Close
Ctrl + X - Cut
Ctrl + Y - Repeat
Ctrl + Z - Undo
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat last action
F4 - While typing a formula, switch between absolute/relative refs
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
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
Shift - Hold down shift for additional functions in Excel’s menu
Shift + F1 - What’s This?
Shift + F2 - Edit cell comment
Shift + F3 - Paste function into formula
Shift + F4 - Find Next
Shift + F5 - Find
Shift + F6 - Previous Pane
Shift + F8 - Add to selection
Shift + F9 - Calculate active worksheet
Shift + F10 - Display shortcut menu
Shift + F11 - New worksheet
Ctrl + F3 - Define name
Ctrl + F4 - Close
Ctrl + F5 - Restore window size
Ctrl + F6 - Next workbook window
Shift + Ctrl + F6 - Previous workbook window
Shift + Ctrl + F - Font Drop Down List
Shift + Ctrl + F + F - Font tab of Format Cell Dialog box
Shift + Ctrl + P - Point size Drop Down List
Ctrl + F7 - Move window
Ctrl + F8 - Resize window
Ctrl + F9 - Minimize workbook
Ctrl + F10 - Maximize or restore window
Ctrl + F11 - Insert 4.0 Macro sheet
Ctrl +F1 - File Open
Alt + F1 - Insert Chart
Alt + F2 - Save As
Alt + F4 - Exit
Alt + Down arrow - Display auto complete list
Alt + Tab - Switch applications
Windows + P - Project screen
Windows + E - Open file explorer
Windows + D - Go to desktop
Windows + M - Minimize all windows
Windows + S - Search
Ctrl + Shift + ~ - General format
Ctrl + Shift + ! - Comma format
Ctrl + Shift + @ - Time format
Ctrl + Shift + # - Date format
Ctrl + Shift + $ - Currency format
Ctrl + Shift + % - Percent format
Ctrl + Shift + ^ - Exponential format
Ctrl + Shift + & - Place outline border around selected cells
Ctrl + Shift+_ - Remove outline border
Ctrl + Shift + * - Select current region
Ctrl ++ - Insert
Ctrl +- - Delete
Ctrl + 1 - Format cells dialog box
Ctrl + 2 - Bold
Ctrl + 3 - Italic
Ctrl + 4 - Underline
Ctrl + 5 - Strike through
Ctrl + 6 - Show/Hide objects
Ctrl + 7 - Show/Hide Standard toolbar
Ctrl + 8 - Toggle Outline symbols
Ctrl + 9 - Hide rows
Ctrl + 0 - Hide columns
Ctrl + Shift + ( - Unhide rows
Ctrl + Shift+ ) - Unhide columns
Alt or F10 - Activate the menu
Ctrl + Tab - In toolbar: next toolbar
Shift + Ctrl + Tab - In toolbar: previous toolbar
Ctrl+Tab - In a workbook: activate next workbook
Shift + Ctrl + Tab - In a workbook: activate previous workbook
Tab - Next tool
Shift + Tab - Previous tool
Enter - Do the command
I hope I saved some lives here.
Feel free to add more if any was omitted.
Content Sources
Very helpful
Thanks man