Excel tips & Trick - To add row

Not everyone like Microsoft. But I must say that Excel spreadsheet is quite a 'marvelous' product from Microsoft.

Below are some of the common shortcut and also some 'extra' shortcut that I've discover from here.

I just put it here for my quick reference and also I've separated it into 2 categories. So here goes:

Some Extra shortcut ( Which I just come across)

Ctrl+Shift+ +	Insert Row
Enter	Paste
Ctrl+H	Find&Replace
Ctrl+Arrow	Move to edge of region
Ctrl+*	Select current region
Ctrl+Home	Select A1 column
Ctrl+End	Select last cell in used range
Ctrl+Shift+End	Select from active cell to last cell in used range.
Ctrl+Shift+Home	Select from active cell to A1
Ctrl+Page Up	Move to the previous sheet
Ctrl+Page Down	Move to the next sheet,
Ctrl+Tab	Move to next open workbook
Shift+F11	Insert new worksheet
Shift+F3	Paste function window
=+FunctionName+Ctrl+A	Insert new function
Alt+F11	Open VBE
Ctrl+Shift+Enter	Array formula
Ctrl+F3	Define name
F3	Paste name
Ctrl+Spacebar	Select columns
Shift+Spacebar	Select rows
Ctrl+;	Insert Current date
Ctrl+shift+:	Insert Current time
Ctrl+1	Format cells

Common Shortcut ( I guess)

Ctrl+Z	Undo
Ctrl+C	Copy
Ctrl+V	Multiple Paste
Ctrl+X	Cut
Ctrl+F	Find
Ctrl+P	Print
Ctrl+S	Save
Ctrl+F4	Close
Alt+F4	Close Excel
Ctrl+A	Select all cells
Ctrl+N	Open new workbook
Ctrl+U	Underline
Ctrl+B	Bold