Excel Shortcuts - Part I

It is very important for a Planning/Cost Control Engineer to have advanced level Excel skills. PLANNING.AZ provides with Excel shortcuts to gain these skills.

FILE

• Create new workbook - CTRL + N
• Open workbook - CTRL + O
• Save workbook - CTRL + S
• Save as - F12
• Print file - CTRL + P
• Open print preview window - CTRL + F2
• Close current workbook - CTRL + F4
• Close Excel - ALT + F4

GENERAL

• Open help – F1
• Undo last action – CTRL + Z
• Redo last action - CTRL + Y
• Copy selected cells – CTRL + C
• Repeat last action - F4
• Cut selected cells - CTRL + X
• Paste content from clipboard - CTRL + V
• Display Paste Special - CTRL + ALT + V
• Display find and replace - CTRL + F
• Find with replace selected - CTRL + H
• Find previous match - CTRL + SHIFT + F4
• Find next match - SHIFT + F4
• Create embedded chart - ALT + F1
• Create chart in new worksheet – F11
• Toggle Autofilter - CTRL + SHIFT + L
• Activate filter – ALT + ¯
• Insert table - CTRL + T
• Select table row – SHIFT+ Space
• Select table column - CTRL+ Space
• Select table – CTRL + A

ACTIVE CELL

• Select active cell only – Shift + Backspace
• Move active cell clockwise in selection – CTRL + .
• Move active cell down in selection - ENTER
• Move active cell up in selection – SHIFT + ENTER
• Move active cell right in a selection - Tab