Excel Shortcuts
Microsoft Excel is a Computer Program. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.
⌨️Excel Best Shortcuts!
- SHIFT + F11 or ALT + SHIFT + F1
Insert a new worksheet.
- CTRL + PAGE DOWN
Move to the next sheet in the workbook.
- CTRL + PAGE UP
Move to the previous sheet in the workbook.
- SHIFT + CTRL + PAGE DOWN
Select the current and next sheet. To cancel selection of multiple sheets, press CTRL + PAGE DOWN or, to select a different sheet, press CTRL + PAGE UP.
- SHIFT + CTRL + PAGE UP
Select the current and previous sheet.
- ALT + O H R
Rename the current sheet (Format menu, Sheet submenu, Rename command).
- ALT + E M
Move or copy the current sheet (Edit menu, Move or Copy Sheet command).
- ALT + E L
Delete the current sheet (Edit menu, Delete Sheet command).
➡️Excel Best Shortcuts! [Arrow Key]
- Arrow keys
Move one cell up, down, left, or right.
- CTRL + arrow key
Move to the edge of the current data region
- HOME
Move to the beginning of the row.
- CTRL + HOME
Move to the beginning of the worksheet.
- CTRL + END
Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
- PAGE DOWN
Move down one screen.
- PAGE UP
Move up one screen.
- ALT + PAGE DOWN
Move one screen to the right.
- ALT + PAGE UP
Move one screen to the left.
- F6
Switch to the next pane in a worksheet that has been split (Window menu, Split command).
- SHIFT + F6
Switch to the previous pane in a worksheet that has been split.
- CTRL + BACKSPACE
Scroll to display the active cell.
- SHIFT + F5
Display the Find dialog box.
- TAB
Move between unlocked cells on a protected worksheet.
🚵♀️Move within a Selected Range
- ENTER
Move from top to bottom within the selected range.
- SHIFT + ENTER
Move from bottom to top within the selected range.
- TAB
Move from left to right within the selected range. If cells in a single column are selected, move down.
- SHIFT + TAB
Move from right to left within the selected range. If cells in a single column are selected, move up.
- CTRL + PERIOD
Move clockwise to the next corner of the selected range.
- CTRL + ALT + RIGHT ARROW
In nonadjacent selections, switch to the next selection to the right.
- CTRL + ALT + LEFT ARROW
Switch to the next nonadjacent selection to the left.
🖱️Move and Scroll in End Mode
- CTRL + SPACEBAR
Select the entire column.
- SHIFT + SPACEBAR
Select the entire row.
- CTRL + A
Select the entire worksheet.
- SHIFT + BACKSPACE
With multiple cells selected, select only the active cell.
- CTRL + SHIFT + SPACEBAR
With an object selected, select all objects on a sheet.
- CTRL + 6
Alternate between hiding objects, displaying objects, and displaying placeholders for objects
📄Entering Data
- ENTER
Complete a cell entry and select the cell below.
- ALT + ENTER
Start a new line in the same cell.
- CTRL + ENTER
Fill the selected cell range with the current entry.
- SHIFT + ENTER
Complete a cell entry and select the previous cell above.
- TAB
Complete a cell entry and select the next cell to the right.
- SHIFT + TAB
Complete a cell entry and select the previous cell to the left.
- ESC
Cancel a cell entry.
- Arrow keys
Move one character up, down, left, or right.
- HOME
Move to the beginning of the line.
- F4 or CTRL + Y
Repeat the last action.
- CTRL + SHIFT + F3
Create names from row and column labels.
- CTRL + D
Fill down.
- CTRL + R
Fill to the right.
- CTRL + F3
Define a name.
- CTRL + K
Insert a hyperlink
- CTRL + ; (semicolon)
Enter the date.
- CTRL + SHIFT + : (colon)
Enter the time.
- ALT + DOWN ARROW
Display a drop-down list of the values in the current column of a range.
- CTRL + Z
Undo the last action.
📃Enter special characters
- ALT + 0162
Enters the cent character ¢.
- ALT + 0163
Enters the pound sterling character £.
- ALT + 0165
Enters the yen symbol ¥.
- ALT + 0128
Enters the euro symbol €.
✨Edit Data
- F2
Edit the active cell and position the insertion point at the end of the cell contents.
- ALT + ENTER
Start a new line in the same cell.
- BACKSPACE
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents.
- DELETE
Delete the character to the right of the insertion point, or delete the selection.
- CTRL + DELETE
Delete text to the end of the line.
- F7
Display the Spelling dialog box.
- SHIFT + F2
Edit a cell comment.
- ENTER
Complete a cell entry and select the next cell below.
- CTRL + Z
Undo the last action.
- ESC
Cancel a cell entry.
- CTRL + SHIFT + Z
When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.
Hope this Excel Amazing Shortcut helps you a lot. Please Follow our BLOG for more Excel related Tips, Tricks and PDF file. Thank you so much for your valuable time.
Folow our YT channel – datainflow
Please Follow US! for more Tips & Tricks