Computer Aided Operations - Examples Important MS Excel Shortcut Keys
-Dr. Lalit Kumar Setia*
The article describes various short-cut keys which can be used to perform the financial operations more efficiently using spread-sheets in a software i.e. MS-Excel. the latest content usually being asked in Competitive Examinations in English Subject.
It is must to learn excel shortcuts in
order to perform fast and effectively at workspace. There are a lot of
techniques built on the basis of shortcut keys.
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 Menubar
|
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+F1 - What’s This?
|
Shift+F2 - Edit cell comment
|
Shift - Hold down shift for additional functions in Excel’s menu
|
||
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
|
Shift+F12 - Save
|
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+F8 - Macro dialog box
|
Alt+F11 - Visual Basic Editor
Ctrl+Shift+F3 - Create name by using names of row and column
labels
|
||
Ctrl+Shift+F6 - Previous Window
|
Ctrl+Shift+F12 - Print
|
Alt+Shift+F1 - New worksheet
|
Alt+Shift+F2 - Save
|
Alt+= - AutoSum
|
Alt+’ - Format Style dialog box
|
Ctrl+` - Toggle Value/Formula display
|
Ctrl+Shift+~ - General format
|
|
Ctrl+Shift+A - Insert argument names into formula
|
Ctrl+Shift+! - Comma format
|
|
Alt+Down arrow - Display AutoComplete list
|
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
|
*Copyright © 2018 Dr. Lalit Kumar. All rights
reserved.
Next Topic : Previous:
You Might Also Be Interested In Reading:
No comments:
Post a Comment
Happy to hear from you. Please give your comments...