Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Shortcut Keys
| Question | Answer |
|---|---|
| UNDERLINE | CTRL + U |
| EDIT | F2 |
| UNDO | CTRL + Z |
| REDO | CTRL + Y |
| REPEAT | F4 |
| BOLD | CTRL + B |
| COPY | CTRL + C |
| PASTE | CTRL + V |
| CUT | CTRL + X |
| TO GO TO FILE TAB | ALT + F |
| TO GO TO HOME TAB | ALT + H |
| TO GO TO INSERT BAT | ALT + N |
| TO GO TO PAGE LAYOUT | ALT + P |
| TO GO TO FORMAT TAB | ALT + M |
| TO GO TO DATA TAB | ALT + A |
| TO GO TO REVIEW TAB | ALT + R |
| TO GO TI VIEW TAB | ALT + W |
| TO GO TO HELP TAB | ALT + Y |
| TO HIDE AND UNHIDE TITLE BAR | CTRL + F1 |
| BORDERS | ATLT + H + B |
| TO MOVE ONE CELL TO RIGHT OR LEFT | ➡️ TO RIGHT , TO LEFT ⬅️ |
| TO MOVE ONE CELL UP ONCE CELL DOWN | CELL UP ⬆️ CELL DOWN ⬇️ |
| TO MOVE ONE CELL RIGT AFTER EDITING | TAB |
| TO MOVE ONE CELL LEFT AFTER EDITING | SHIFT + TAB |
| TO MOVE LAST COLUMN OF THE SHEET(RIGHT END) | CTRL + ➡️ |
| TO MOVE FIRST COLUMN (👈 END) | CTRL + ⬅️ |
| TO MOVE TO LAST ROW | CTRL + ⬇️ |
| TO MOVE TO FIRST ROW | CTRL + ⬆️ |
| TO MOVE SCREEN UP OR DOWN | ALT + PGUP , ALT + PGDN |
| TO SELECT COLUM UP AND DOWN | SHIFT + ⬆️ UP, SHIFT + ⬇️ |
| TO SELEC TROW LEFT AND RIGHT | SHIFT + ⬅️, SHIFT + ➡️ |
| TO SELECT ENTIRE COLUMN | CTRL + SPACEBAR |
| TO SELECT ENTIRE ROW | SHIFT + SPACEBAR |
| TO SELECT ENTIRE SHEET | CTRL + SHIFT + SPACEBAR / CTRL + A |
| HIDE ROW | CTRL + 9 |
| UNHIDE ROW | ALT ➡️ H➡️O➡️U➡️L |
| TO GO TO THE LAST COLUMN OF THE SHEET | CTRL + ➡️ |
| TO COME TO THE FIRST COLUMN OF THE SHEET | CTRL + ⬅️ |
| TO SELECT THE ROW TO 👉 | CTRL + SHIFT + ➡️ |
| TO SELECT THE ROW TO 👈 | CTRL + SHIFT + ⬅️ |
| TO GO COLUMN UP OR DOWN | UP CTRL + ⬆️, DOWN CTRL + ⬇️ |
| TO SELECT COLUMN UP OR DOWN ONE CELL AT A TIME | SHIFT + ⬇️ |
| TO SELECT WHOLE COLUM AT A TIME DOWN OR UP | CTRL + SHIFT + ⬇️, CTRL + SHIFT + ⬆️ |
| SELECT ENTIRE SHEET | CTRL + SHIFT + SPACEBAR / CTRL + A |
| Wrap text in a cell | Alt H W |
| Hide selected column | Ctrl + 0 |
| Hide selected row | Ctrl + 9 |
| Selective Pasting | Ctrl + E + S |
| Auto Fit to Column | Alt H O I |
| Auto Fit to Row | Alt H O W |
| To open paste special box | Ctrl + Shift + V |
| To convert number data to 💲 | Ctrl + Shift + 4 ($) |
| To enter date into a cell | Ctrl + ; |
| To enter time (give space to enter in same cell) | Ctrl + Shift + ; |
| To open paste special box | Ctrl + Alt + V |
| To go to one work book to another work book | Ctrl + Tab |
| To increase formula bar size | Ctrl + Shift + U |
| To go to active cell | Ctrl + Backspace |
| To apply outside border to selected cells | Ctrl + Shift + & |
| To remove the applied border | Ctrl + Shift + - |
| To open the shot box to change the selected heade names | Alt + D + O + O |
| Autofit to Column width | Alt + H + O + I |
| Autofit to row height | Alt + H + O + A |
| To increase decimal points | Alt + H + 0(Zero) |
| To Decrease decimal points | Alt + H + 9 |
| To remove Duplicate entries | Alt + A + M |
| Go to | F5 |
| To show up hidden formula bar | Alt + W + V + F |
| To remove gridlines lines | Alt + W + V + G |
| Conditional formatting | Alt + H + L |
| Transpose | Ctrl 🔜 Alt 🔜 V 🔜 E |
| Go to | Ctrl + G, or F5 |
| Sort Assending | Alt + A + S + A |
| Sort Desending | Alt + A + S + D |
| Remove formula from cell | Ctrl+C, and Ctrl + Alt + V |
| Lock Selected cell | Shift + ScrollLock |
| System Properties | 🪟. + PauseBreak |
| Overwrite Right side text | Insert Key |
Created by:
user-2012685