Excel Shortcuts for beginners - Part 1

3/31/2013
Jalaluddin Akbar Shaik
Excel Basic Formulas
Excel Features
	Ctrl + n	Open New Workbook
	Ctrl + o	Open File
	Ctrl + s	Save File.
	F12	Display the Save As dialog box.
	F10 or Alt	Turn key shortcuts on or off
	Ctrl + P	Opens Print Menu.
	F1	Opens Excel Help Menu
	F7	Opens the Spelling dialog box.
	Shift + F7	Opens the Thesaurus dialog box.
	Alt + F8	Opens the Macro dialog box.
	Alt + F11	Open the Visual Basic Editor
Format Cells
	Ctrl + 1	Displays the Format Cells dialog box.
	Ctrl + 2 (or Ctrl + b)	Applies or removes bold formatting.
	Ctrl + 3 (or Ctrl + i)	Applies or removes italic formatting.
	Ctrl + 4 (or Ctrl + u)	Applies or removes underlining.
	Ctrl + 5	Applies or removes strikethrough.
	Ctrl + Shift + &	Applies the outline border.
	Ctrl + Shift + _	Removes outline borders.
	Ctrl + Shift + f	Display the Format Cells with Fonts Tab active.
	Alt + ‘(apostrophe )	Displays the Style dialog box.
Format Cell Contents
	Ctrl + Shift + 1	Applies the Number format
	Ctrl + Shift + 2	Applies the Time format
	Ctrl + Shift + 3	Applies the Date format
	Ctrl + Shift + 4	Applies the Currency format
	Ctrl + Shift + 5	Applies the Percentage format
	Ctrl + Shift + 6	Applies the Scientific number format
Rows & Columns
	Ctrl + F3	Define a name or dialog.
	Ctrl + Shift + F3	Create names from row and column labels.
	F3	Paste a defined name into a formula.
Work with Clipboard
	Ctrl + c	Copy contents of the selected cell
	Ctrl + v	Paste contents of the selected cell
	Ctrl+ x	Cut contents of the selected cell
	Ctrl + Alt + V	Display Paste Special dailog box
	Ctrl + Shift + +	Display the insert dailog box
Undo/Redo
	Ctrl + Z	Undo last action
	Ctrl + Y	Redo last action