MX Excel Short cute Keys ( PRAGYAN कम्प्यूटर LEARN MORE )

 

Shortcut keyAction
Ctrl+ASelect All
Ctrl+BBold
Ctrl+CCopy
Ctrl+DFill Down
Ctrl+EFlash Fill
Ctrl+FFind
Ctrl+GGoto
Ctrl+HReplace
Ctrl+IItalic
Ctrl+KInsert Hyperlink
Ctrl+NNew Workbook
Ctrl+OOpen
Ctrl+PPrint
Ctrl+RFill Right
Ctrl+SSave
Ctrl+UUnderline
Ctrl+VPaste
Ctrl WClose
Ctrl+XCut
Ctrl+YRepeat
Ctrl+ZUndo
F1Help
F2Edit
F3Paste Name
F4Repeat last action
F4While typing a formula, switch between absolute/relative refs
F5Goto
F6Next Pane
F7Spell check
F8Extend mode
F9Recalculate all workbooks
F10Activate Menubar
F11New Chart
F12Save As
Ctrl+:Insert Current Time
Ctrl+;Insert Current Date
Ctrl+"Copy Value from Cell Above
Ctrl+Copy Formula from Cell Above
ShiftHold down shift for additional functions in Excel’s menu
Shift+F1What’s This?
Shift+F2Edit cell comment
Shift+F3Paste function into formula
Shift+F4Find Next
Shift+F5Find
Shift+F6Previous Pane
Shift+F8Add to selection
Shift+F9Calculate active worksheet
Ctrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Ctrl+Alt+Shift+F9Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Shift+F10Display shortcut menu



Shortcut key
Action
F1Help
F2View Object Browser
F3Find Next
F4Properies Window
F5Run Sub/Form or Run Macro
F6Switch Split Windows
F7View Code Window
F8Step Into
F9Toggle Breakpoint
F10Activate Menu Bar
Shift+F2View definition
Shift+F3Find Previous
Shift+F7View Object
Shift+F8Step Over
Shift+F9Quick Watch
Shift+F10Show Right Click Menu
Ctrl+F2Focus To Object Box
Ctrl+F4Close Window
Ctrl+F8Run To Cursor
Ctrl+F10Activate Menu Bar
Alt+F4Close VBE
Alt+F6Switch Between Last 2 Windows
Alt+F11Return To Application
Ctrl+Shift+F2Go to last position
Ctrl+Shift+F8Step Out
Ctrl+Shift+F9Clear All Breakpoints
InsertToggle Insert Mode
DeleteDelete
HomeMove to beginning of line
EndMove to end of line
Page UpPage Up
Page DownPage Down
Left ArrowLeft
Right ArrowRight
Up ArrowUp
Down ArrowDown
TabIndent
EnterNew Line
BackSpaceDelete Prev Char
Shift+InsertPaste
Shift+HomeSelect To Start Of Line
Shift+EndSelect To End Of Line
Shift+Page UpSelect To Top Of Module
Shift+Page DownSelect To End Of Module
Shift+Left ArrowExtend Selection Left 1 Char
Shift+Right ArrowExtend Selection Right 1 Char
Shift+Up ArrowExtend Selection Up
Shift+Down ArrowExtend Selection Down
Shift+TabOutdent
Alt+SpacebarSystem Menu
Alt+TabCycle Applications
Alt+BackSpaceUndo
Ctrl+ASelect All
Ctrl+CCopy
Ctrl+EExport Module
Ctrl+FFind
Ctrl+GImmediate Window
Ctrl+HReplace
Ctrl+ITurn On Quick Info
Ctrl+JList Properties/Methods
Ctrl+LShow Call Stack
Ctrl+MImport File
Ctrl+NNew Line
Ctrl+PPrint
Ctrl+RProject Explorer
Ctrl+SSave
Ctrl+TShow Available Components
Ctrl+VPaste
Ctrl+XCut
Ctrl+YCut Entire Line
Ctrl+ZUndo
Ctrl+InsertCopy
Ctrl+DeleteDelete To End Of Word
Ctrl+HomeTop Of Module
Ctrl+EndEnd Of Module
Ctrl+Page UpTop Of Current Procedure
Ctrl+Page DownEnd Of Current Procedure
Ctrl+Left ArrowMove one word to left
Ctrl+Right ArrowMove one word to right
Ctrl+Up ArrowPrevious Procedure
Ctrl+Down ArrowNext Procedure
Ctrl+SpacebarComplete Word
Ctrl+TabCycle Windows
Ctrl+BackSpaceDelete To Start Of Word
Ctrl+Break/PauseBreak
Ctrl+Shift+IParameter Info
Ctrl+Shift+JList Constants

Comments