EXCEL KEYBOARD SHORTUCTS

"Keyboard shortcuts with CTRL as a primary Key"

Here i have presented the excel keyboard shortcuts with CTRL as one of the primary key. Try remembering as many as possible. The best way to see the practical application of these shortcut keys is to try out them in excel. Write a number in a cell and keep trying out these combinations. Practice them for 3-4 times by looking at the sheet and after think of an activity that you want to do and then try to remember the keystroke required to accomplish the task. Do not move to the next blog in series until 80% of the shortcuts are successfully reproduced

Shortcut key	Activity performed		Shortcut Key	Activity Performed
Ctrl + A	Select All		Ctrl + Space	Select Row
Ctrl + B	Bold		Shift + Space	Select Column
Ctrl + C	Copy		Ctrl + 1	Format cell Dialog
Ctrl + D	Copy Down		Ctrl + 2	Bold
Ctrl + E			Ctrl + 3	Italic
Ctrl + F	Find		Ctrl + 4	Underline
Ctrl + G	Goto		Ctrl + 5	Strikethrough
Ctrl + H	Replace		Ctrl + 6
Ctrl + I	Italics		Ctrl + 7
Ctrl + J			Ctrl + 8
Ctrl + K	Hyperlink		Ctrl + 9	Hide Row
Ctrl + L	Create Table		Ctrl + 0	Hide Column
Ctrl + M
Ctrl + N	New file
Ctrl + O	Open file		Ctrl + ;	Insert Date
Ctrl + P	Print file		Ctrl + '	Copy exact formula
Ctrl + Q			Ctrl + +	Insert Row
Ctrl + R	Copy right		Ctrl + -	Delete Row
Ctrl + S	Save File		Ctrl + F1	Remove developer bar
Ctrl + T	Create Table		Ctrl + F2	Print Preview
Ctrl + U	Underline		Ctrl + F3	Manage names
Ctrl + V	Paste		Ctrl + F4	Close
Ctrl + W	Close file		Ctrl + F5	Maximize
Ctrl + X	Cut		Ctrl + F6
Ctrl + Y	Redo		Ctrl + F7
Ctrl + Z	Undo		Ctrl + F8
Ctrl + Tab	Next workbook		Ctrl + F9	Minimize
			Ctrl + F10	Maximize
			Ctrl + F11	Create macro sheet
			Ctrl + F12	Open file

Of the above the functions that i think will be used the most include, Ctrl + R and Ctrl +D, Ctrl + + and Ctrl + -. So in the next post we will be discussing about each of these shortcut keys in brief.