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.

Rule No 1

"Leave the mouse and focus on the keyboard" 

Excel has loads of shortcuts which have the potential to make your life and work simpler. Learning these shortcuts is one of the key requirements for making financial models quickly and efficiently. Presented below are some of the shortcuts that i find particularly useful and handy. The reader should make a concerted effort in remembering the shortcuts.

The shortcuts that i am going to present here are easily available on a wide variety of websites. These shortcuts are grouped by the utility they serve. Here i have tried to present them according to key combinations for e.g. all shortcuts which require Ctrl to be pressed have been grouped together and presented. I believe it is much easier to see the formulas this way than trying to remember them utility wise.

About the blog name

The blog would deal with the nuances of excel modeling. I would talk about the functions that one can use to make the work easier and the shortcuts to speed up the entire exercise of modeling. Over the course of the blog i would also try to put some models that would prove to be useful during valuation exercises and project financing. So the site got its name "excelmodels". Well! that could have been a justification of the blog. But i would not lie.

I tried "excel modeling" and "financial modeling" which would better befit the activities that i plan to undertake but alas they were already taken for no good purpose. Probably kept for the sake of posterity for the future. So without blabbering too much on the name lets get started with the game.