Excel Some Useful Shortcuts

Excel Some Useful Shortcuts

Excel Some Useful Shortcuts
Shortcut key	Action	Menu equivalent comments
Alt or F10	Menu	Go to Menu bar
Alt+’	Format Style dialog box	Format the Style
Alt+=	AutoSum	Sum Formaula Showing in Cell
Alt+Down arrow	Display AutoComplete list	Displaying Auto Complete Data List
Alt+F1	Insert Chart	Insert the Chart
Alt+F11	Visual Basic Editor	Tools, Macro, Visual Basic Editor
Alt+F2	Save As	Save File to Save As
Alt+F4	Exit	File Exit
Alt+F8	Macro dialog box	Macro dialog box Tools
Alt+Shift+F1	New worksheet	Insert New Worksheet
Alt+Shift+F2	Save	Save the File
Ctrl + Shift + L	Filter	Filter the Row
Ctrl W	Close	Close the Open File
Ctrl+-	Delete	Delete the Rows, Columns and Cells Right or Down Depends on selection
Ctrl+!	Format cells dialog box	Font Tab Open in Format Cell Tool
Ctrl+#	Italic	Cell Font Style Change to Italic toggle
Ctrl+$	Underline	Cell Font Style Change to Underline toggle
Ctrl+%	Strikethrough	Cell Font Style Change to Strikethough
Ctrl+(	Hide rows	Hide the Row
Ctrl+)	Hide columns	Hide the Coloumns
Ctrl+;	Insert Current Date	Add the Current Date
Ctrl+@	Bold	Cell Font Style Change to Blod toggle
CTRL+[	Select all cells directly referenced by formulas in the selection.	Referene Contains Cell Easily Find
CTRL+]	Select cells that contain formulas that directly reference the active cell.	Referene Formula Cell Easily Find
Ctrl+`	Column Widht	Coloumn Width Increase Double Size
Ctrl++	Insert	Insert the Rows, Columns and Cells Right or Down Depends on selection
Ctrl+A	Select All	Selecting Entire Sheet
Ctrl+Alt+V	Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.	Purpose Paste and Paste Special
Ctrl+Alt+V, Press A	Displays the Paste Special dialog box, Selecting All	Purpose Paste and Paste Special
Ctrl+Alt+V, Press V	Displays the Paste Special dialog box, Selecting Values	Purpose Paste and Paste Special
Ctrl+B	Bold	Cell Font Style Change to Bold toggle
Ctrl+C	Copy	As Your Wish to Copy Selected Cells
Ctrl+D	Fill Down	Copy to Down Cell
Ctrl+F	Find	Find What you Find
Ctrl+F1	Hide the Menubar	Hiding the Menubar
Ctrl+F10	Maximize or restore Down window	Maximize and restore Down the window
Ctrl+F11	Macro sheet	Inster the Macro Worksheet
Ctrl+F12	File Open	Open the File
Ctrl+F2	Format Shape & Print	1st Side to Open Format Shape Tool, Next Immediately Open Print Option
Ctrl+F3	Name Manager	New Name add to Refer Cell (Any Cell You Want add New Name)
Ctrl+F4	Close	Close the Open File
Ctrl+F5	Restore Down	Window Size Change
Ctrl+F6	Next workbook	Next Workbook Window Change
Ctrl+F7	Move window	1st Change the Window Size Pressing Ctrl+F5, After Window Move to Any Area
Ctrl+F8	Add to selection	Multiple Different Cell Add to Selection
Ctrl+F9	Minimize workbook	Minimize the Worksheet
Ctrl+G	Go to	Type the Reference Cell Numver Want to Go
Ctrl+H	Replace	Find What you Find to Replace With Another Word
Ctrl+I	Italic	Cell Font Style Change to Italic toggle
Ctrl+K	Insert Hyperlink	Hyperlink Insret
Ctrl+N	New Workbook	New File
Ctrl+O	Open	Open File
Ctrl+P	Print	Print File
Ctrl+R	Fill Right	Copy to Right Cell
Ctrl+S	Save	Save the Workbook File
Ctrl+Shift+&	outline border around selected cells	Place outline border around selected cells
Ctrl+Shift+(	Unhide rows	Unhide the Hided Rows
Ctrl+Shift+)	Unhide columns	Unhide the Hided Coloumns
Ctrl+Shift+:	Insert Current Time	Add the Current Time
Ctrl+Shift+_	Remove outline border	Remove outline border around selected cells
Ctrl+Shift+A	Insert argument names into formula	1 st Type the Formula Name in Cell Next Press the Shortcut
Ctrl+Shift+F1	Full Mode	Hide the QuickAccess, Menu and Status bar
Ctrl+Shift+F12	Print	Print File
Ctrl+Shift+F3	Create name by using names of row and column labels	Insert, Name, Create
Ctrl+Shift+F6	Workbook Switch	Last Workbook Switch Between Multiple Sheets
CTRL+SHIFT+SPACEBAR	Selects the entire worksheet.	Selecting he entire worksheet.
Ctrl+Spacebar	Select the entire column	Selecting the entire column
Ctrl+Tab	In the toolbar next toolbar	Go to Next Option in Toolbar
Ctrl+Tab	In a workbook: next workbook	Switch Next Workbook
Ctrl+U	Underline	Cell Font Style Change to Underline toggle
Ctrl+V	Paste	1st Copy the Selected Area, And Next Paste to Anywhere in Workbook
Ctrl+X	Cut	As Your Wish to Cut Selected Cells
Ctrl+Y	Repeat	1st Using Undo After You can use the Repeat
Ctrl+Z	Undo	Sack to Steps Previous
Enter	Move to Down Cell	Move to Down Cell
F1	Help	Excel Help
F10	Menu	Go to Menu bar
F11	New Chart	Insert Chart
F12	Save As	File Save to Save As
F2	Edit	You Can Edit the Word
F4	While typing a formula, switch between absolute/relative refs	Change the Formula While you Formula Adding (For Example =Vlookup(a2 Now Press F4)
F5	Go to	Type the Reference Cell Numver Want to Go
F6	Menu & Status Bar	1 time Press Go to Status Bar, 2 times Press to Menu Bar
F7	Spell check	Spelling Modified
F8	Extend mode	Extend Selection
SHIFT+BACKSPACE	Cells Selected	select only the active cell, With multiple cells selected With Hold Shift+Down Arrow
Shift+Ctrl+F	Font Tab Format Cell	Font Tab Open in Format Cell Tool
Shift+Ctrl+F6	Previous workbook window	Previous Workbook Window Change
Shift+Ctrl+P	Font Tab Format Cell	Font Tab Open in Format Cell Tool
Shift+Ctrl+Tab	In the toolbar: previous toolbar	Go to Previous Option in Toolbar
Shift+Ctrl+Tab	In a workbook: previous workbook	Switch Previous Workbook
Shift+F10	Display Options	If you Don't Want Use the Mouse Right, Then Use the Shortcut (And Also Shortcut Available Keyboad)
Shift+F11	New worksheet	Insert the New Worksheet
Shift+F12	Save	File Save
Shift+F2	Edit cell comment	Insert and Edit Comments
Shift+F3	Select a Formula Function	Insert a Furmula Function
Shift+F4	Repeat last action	Repeat the Last Actions Works while not in Edit mode. (1st Using Find What : What You Find, After You Can Use Previuosly What You Find)
Shift+F5	Find	Find What you Find
Shift+F6	Menu & Status Bar	1 time Press Go to Status Bar, 2 times Press to Menu Bar
Shift+F7	Thesaurus	Type the words in groups of synonyms and related concepts
Shift+F8	Add to selection	Multiple Different Cell Add to Selection, How to Use Press 2 Times, After Add to Selection
Shift+Spacebar	Select the entire row	Selecting the entire row
Shift+Spacebar and Ctrl+ -	Delete	Delete the Selected Area Row
Shift+Spacebar and Ctrl+ +	Insert	Insert the Selected Area Row
Shift+Tab	Move to Previous Left Cell	Move to Previous Left Cell
Tab	Move to Right Cell	Move to Right Cell
Esc	Escape	Stop the Selected Cells Copy
PgUp	Page Up	Go to Next WorkSheet
PgDn	Page Down	Go to Previous WorkSheet