Excel shortcut

Hi Guys ... Here are some Really Important Excel Shortcuts , too speed up your Work in day to day office work

SELECTION

• Column Ctrl + space
• Row Shift + space
• Entire worksheet Ctrl + A

NEVIGATE CELL

• Right Tab
• Start of worksheet Ctrl + Home
• End of worksheet Ctrl + End
• Start of row Home
• Up/down one screen Page Up/ Down

STANDARD ACTION

• Activate menus F10
• Save Ctrl + S
• Print Ctrl + P
• New workbook Ctrl + N
• Open Ctrl + O
• Copy Ctrl + C
• Cut Ctrl + X
• Paste Ctrl + V

COPY DATA AND RANGE

• Select current range Ctrl + *
• Move to range border Ctrl + arrow
• Move up Shift + Enter
• Move left Shift + Tab
• Fill down Ctrl + D
• Fill right Ctrl + R
• Copy formula above Ctrl + '
• Copy value above Ctrl+ "

EDIT ACTION AND COMPLETE ACTION

• Edit cell F2
• Insert Ctrl + +
• Delete Ctrl + -
• Repeat last action F4
• Today’s date Ctrl + ;
• Chart selected data F11
• Format cells Ctrl + 1

• General Ctrl + Shift + ~
• Currency Ctrl + Shift + $
• Percentage Ctrl + Shift + %
• Date (d, m, y) Ctrl + Shift + #