MS-EXCEL SHORTCUT

 

SHORTCUT	MS-EXCEL
Ctrl+A	Select all contents of the worksheet.
Ctrl+B	Bold highlighted selection.
Ctrl+C	Copy  the cell
Ctrl+D	Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.
Ctrl+E
Ctrl+F	Find
Ctrl+G	Goto
Ctrl+H	Replace
Ctrl+I	Italic highlighted selection.
Ctrl+J	To enter the line break character
Ctrl+K	Insert link.
Ctrl+L	Create a table
Ctrl+M	to activate a "Move" function
Ctrl+N	Create a new work book
Ctrl+O	Open a excel
Ctrl+P	Print
Ctrl+Q	Display the Quick Analysis options for selected cells that contain data.
Ctrl+R	Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+S	Save the open worksheet.
Ctrl+T	Convert cell to table
Ctrl+U	Underline highlighted selection.
Ctrl+V	Paste
Ctrl+W	Close the current window
Ctrl+X	Cut
Ctrl+Y	Undo
Ctrl+Z	Repeat

 

SHORT CUT	MS-EXCEL
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

 

FUNCTION kEY	MS-EXCEL
F1	Help
F2	Edit
F3	Paste Name
F4	Repeat last action
F5	Goto
F6	Next Pane
F7	Spell check
F8	Extend mode
F9	Recalculate all workbooks
F10	Activate Menubar
F11	New Chart
F12	Save As

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SHORTCUT	MS-EXCEL
Ctrl+Shift+(	Unhide rows
Ctrl+Shift+)	Unhide columns
Alt or F10	Activate the menu
Crtl +Tab	In a workbook: activate next workbook
Tab	Next tool
Shift+Tab	Previous tool
Enter	Do the command
Alt+Enter	Start a new line in the same cell.
Ctrl+Enter	Fill the selected cell range with the current entry.
Ctrl+Spacebar	Select the entire column
Shift+Spacebar	Select the entire row
CTRL+PgUp	Switches between worksheet tabs, from left-to-right.
CTRL+PgDn	Switches between worksheet tabs, from right-to-left.
Ctrl+"	Copy Value from Cell Above
Ctrl+’	Copy Formula from Cell Above
Ctrl+:	Insert Current Time
Ctrl+;	Insert Current Date

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SHORTCUT	MS-EXCEL
Alt+=	AutoSum
Ctrl+`	Toggle Value/Formula display
Ctrl+Shift+A	Insert argument names into formula
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 the current region around the active cell. In a PivotTable report, select the entire PivotTable report.
Ctrl++	Insert
Ctrl+-	Delete

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  

SHORT CUT	MS-WORD	MS-EXCEL
Shift+F1	Start context-sensitive Help or reveal formatting.	What’s This?
Shift+F2	Copy text.	Edit cell comment
Shift+F3	Change the case of letters.	Paste function into formula
Shift+F4	Repeat a Find or Go To action.	Find Next
Shift+F5	Move to the last change.	Find
Shift+F6	Go to the previous pane or frame (after pressing F6).	Previous Pane
Shift+F7	Choose the Thesaurus command (Review tab, Proofing group).
Shift+F8	Reduce the size of a selection.	Add to selection
Shift+F9	Switch between a field code and its result.	Calculate active worksheet
Shift+F10	Display a shortcut menu.	Display shortcut menu
Shift+F11	Go to the previous field.	New worksheet
Shift+F12	Choose the Save command.	Save