📝Know More About Your Computer
Many Useful ShortKeys📝
🔹Ctrl+A - Select All
🔹Ctrl+B - Bold
🔹Ctrl+C - Copy
🔹Ctrl+D - Fill Down
🔹Ctrl+F - Find
🔹Ctrl+G - Goto
🔹Ctrl+H - Replace
🔹Ctrl+I - Italic
🔹Ctrl+K - Insert Hyperlink
🔹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 - XL, Restore window size
🔹Ctrl+F6 - Next workbook window
🔹Shift+Ctrl+F6 - Previous workbook window
🔹Ctrl+F7 - Move window
🔹Ctrl+F8 - Resize window
🔹Ctrl+F9 - Minimize workbook
🔹Ctrl+F10 - Maximize or restore window
🔹Ctrl+F11 - Inset 4.0 Macro sheet
🔹Ctrl+F1 - File Open
🔹Alt+F1 - Insert Chart
🔹Alt+F2 - Save As
🔹Alt+F4 - Exit
🔹Alt+Down arrow - Display AutoComplete list
🔹Alt+’ - Format Style dialog box
🔹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 - Strikethrough
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
🔹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 + E - Align center
🔹Ctrl + J - justify
🔹Ctrl + L - align
🔹Ctrl + R - align right
🔹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```
Enjoy and share ❤️
No comments:
Post a Comment