MS Excel Shortcuts

    

Excel Shortcuts
ctrl+shift+*	selected the whole area in data range
f4	copy a fill colour and paste colour
alt	excel 2007 active the menu bar option
ctrl+5	strikout
f2	editing the selected cell
ctrl+-	insert the delete box
ctrl+shift+=	display the insert box
ctrl+;	insert the date
ctrl+shift+:	insert the time
alt+=	autosum
shift+f11	insert the worksheet
ctrl+spacebar	selected the whole coloumn
shift+spacebar	selected the whole row
ctrl+pageup	previous sheet
ctrl+pagedown	next sheet
ctrl+shift+!	set the decimal value like 45.00
ctrl+shift+$	set the curancy value like $45.00
ctrl+shift+%	set the per value like 45%
ctrl+shift+~	clear the number format 45
ctrl+shift*	select the whole text area
ctrl+9	hide the select row
ctrl+shift(	unhide the row
ctrl+0	hide the select column
ctrl+shift+)	unhide the column
ctrl+shift+&	set the border selected cell
ctrl+shift+-	delete the border
ALT+ENTET	wrapping the selected cell
shift+f3	insert the function box
shift+f2	insert the comments
ctrl+f9	mini the selected work book
ctrl+f10	max the selected work book
ctrl+f6	selected the mini workbook
ctrl+f5	restore work book
ctrl+shift + f3	create name box
ctr+f3	define name
ctrl+f4	close the work book