As Teachers we do a lot of Microsoft Office tasks most special in excel when deped require us to submit huge amount of forms. Part of our Goal and Purpose of this website is to ease those burdens even just for a little bit.

So we are digging the internet just to find this Helpful Keyboard shortcuts list for Excel from the Basic shortcuts to Advanced, like most of Information Technology (IT) professionals they use keyboard shortcuts to make their work more efficient and fast. So by that example we believe that doing so it may help us Teachers to increase our productivity when creating forms and lessen or time and burden so that we can have more quality time to our families.

Below are the list of Excel shortcuts, you may copy it and save it to remember the shortcuts or you may Download the PDF list file down below.

EXCEL SHORTCUT LIST PDF

• CTRL + 1 Format Box
• ALT + E + S + T Copy Format
• ALT + H + 0 Increase Decimal
• ALT + H + 9 Decrease Decimal
• CTRL + SHIFT + 7 Boxing
• ALT + O + C + A Fit Column Width
• ALT + H + O + R Change Tab Name
• ALT + W + F (Un)Split Panes
• ALT + W + S (Un)freeze windows
• SHIFT + CTRL + # Date Format
• SHIFT + CTRL + $ $ Dollar Format
• SHIFT + CTRL + % % Percentage Format
• ALT + “=” Sum Function

CTRL Shortcuts

• CTRL + A Select All
• CTRL + B Bold
• CTRL + C Copy
• CTRL + D Fill Down
• CTRL + F Find
• CTRL + I Italic
• CTRL + N New Workbook
• CTRL + O Open
• CTRL + P Print
• CTRL + R Fill Right
• CTRL + S Save Workbook
• CTRL + U Underline
• CTRL + V Paste
• CTRL + W Close Window
• CTRL + X Cut
• CTRL + Z Undo

Function Key Shortcuts

• F2 Edit Cells
• F4 Anchor Cells
• F7 Spell Check
• F12 Save As
• SHIFT + F2 Insert a Comment
• SHIFT + F8 Add to Selection
• SHIFT + F10 Right Click
• CTRL + F3 Name a Cell
• Windows Flag + D Minimize Programs

Navigation Shortcuts

• Arrows Move
• CTRL + Arrows Go to End of Continuous Range
• SHIFT + Arrows Select A Cell Range
• CTRL + SHIFT + Arrows Highlight A Continuous Range
• ALT + Tab Switch Programs
• CTRL + Pg Up/Down Switch Worksheets
• Enter Move below
• Shift + Enter Move Up
• Home Move to Beginning of Line
• CTRL + Home Go to Cell A1
• ESC Cancel
• Alt + Enter (when in a cell) Add a Line

Columns & Rows Shortcuts