Microsoft Excel is widely used for data analysis and archiving worldwide. Excel remains the go-to tool for handling data despite the market being overrun with new data analytics tools. Your data organization will be made easier by its many built-in features. Working with your data quickly is made more accessible by Excel's shortcut keys. We'll talk about the different Excel shortcuts in this tutorial. You can work more swiftly and effectively by using these keyboard shortcuts.
Even though a lot of you have become used to Excel, let's give it a brief introduction nonetheless. Data recording, analysis, and visualization are all possible with Microsoft Excel, an application created by Microsoft. Microsoft created Excel, a spreadsheet program, in 1985.
Data is arranged in Excel using rows and columns. Excel is widely used for mathematical operations, data analysis and recording, and the graphic display of structured data in charts and graphs. Finally, using Excel macros to automate tasks is another crucial use for the program. The tasks mentioned above can be finished quickly with Excel's shortcuts. A few simple keystrokes can accomplish a variety of functions. Now, let's explore the Excel shortcuts that can improve our efficiency when using a spreadsheet.
Shortcut keys use
Excel's Many keyboard shortcuts can help you work more productively and efficiently. Essential functions are accomplished with two or three keystrokes rather than requiring the mouse to access the toolbar. Isn't that simpler and more efficient? Excel shortcuts provide a significant speed boost, which decreases work time.
The answer to whether you must recall these shortcuts is no. Still, it would help if you could recall a couple of them. You will be able to identify the majority of common Excel shortcuts with consistent practice.
Keyboard Shortcuts for Dialog Box
Shortcut Keys
Purpose/Description
Alt+F8
This shortcut will open the Macro dialog box
Alt+.
This shortcut is used to open the format style box.
Ctrl+1
To open format cells box
Shift+Ctrl+F,F
This shortcut will allow you to open the Font tab in the Format Cells dialogue box.
Ctrl+T
To open the Create Table dialogue box
Ctrl+Shift+F
To open the Format cells dialogue box
Esc
To close the dialogue box and to cancel the commands.
Data Entering Shortcuts
Shortcuts keys
Purpose/Description
Ctrl + Shift + :
For inserting the current time
Ctrl + '
For filling, the above formula is down
Ctrl + :
For inserting the current time
Ctrl + ;
For inserting the current time
Ctrl + R
To fill the right
Ctrl + Y
It redo the last action
Ctrl +Del
For deleting the end of the world
File Commands:
Shortcut Keys
Purpose/Description
Shift + F11
For Inserting New Worksheet
Shift + F12
For Saving the File
Ctrl + F12
To display the file
Ctrl + Shift + F12
For giving the print
Alt + Shift +F2
For Saving the file
Ctrl + P
For printing the file
Ctrl + S
For saving the file
Ctrl + W
For closing the file
F12
For saving as a file
Ctrl + F2
For printing the file
PGUP
To go page up
PGDN
To go page down
For going left
For going right
For going up
For going down
Tab
For Indentation
Enter
For to go newline
Format Keyboard Shortcuts
Shortcut Keys
Purpose/Description
Ctrl + X
Cut
Ctrl + Shift +
For converting into a general format
Ctrl + Shift + #
For converting into date format
Ctrl + Shift + $
For converting into Currency format
Ctrl + Shift + %
For converting into percentage format
Ctrl + Shift + ^
For converting into an exponential format
Ctrl + +
For row inserting
Ctrl + -
For row deleting
Ctrl + 2
For applying Bold to the font
Ctrl + 3
For applying Italic to the font
Ctrl + 4
For applying underlining to the font
Ctrl + 6
For hiding/Showing objects, the view
Alt + Enter
For Starting the new line in the Same cell
Ctrl + Shift +F
For opening the Font tab in the Format cells dialog box
Ctrl + Shift + P
For opening the Font tab in the Format cells dialog box
Ctrl + B
To make the font bold
Ctrl + U
For applying underlining to the font
Ctrl + V
Paste
Ctrl + Shift + !
For comma format
Shift + I
For editing comment cell
Ctrl + I
For making the font Italic
Ctrl + Shift + 1
For format numbers in comma format
Ctrl + Shift + 4
For format number in currency format
Ctrl + Shift + 3
For format number in date format
Ctrl + Shift + 5
For format number in Percentage format
Ctrl + Shift + 6
For format number in Scientific format
Ctrl + Shift + 2
For format number in time format
Shortcuts for Formulas
Shortcut Keys
Purpose/Description
F4
For repeating the last action
Ctrl + Alt + F9
For calculating the worksheet in all open workbooks
Ctrl + Alt + Shift
This shortcut is useful to rechecks dependent formula
Ctrl + F3
To define the name
Ctrl + Shift + F3
For creating the names in rows and columns
Alt + =
Sum Function
Ctrl + '
For displaying formula
Ctrl + Shift + A
For inserting the argument names into the formula
F3
For pasting the name into the formula
F9
For Evaluating the formula
Shift + F3
For pasting function into the formula
Ctrl + Shift + F2
To go to the last position
Ctrl + Shift + F8
For stepping out
Ctrl + Shift + F9
For clearing all breakpoints
Ctrl + Shift + Enter
Entering the formula as an Array Formula
Ctrl + Shift + U
To toggle Expand or for collapsing formula bar
Basic Keyboard Shortcuts
Shortcut Keys
Purpose/Description
Alt +
For displaying the Autocomplete list
Ctrl + #
Toggle outline symbols
Alt
For Activate menu bar
Ctrl + K
For adding the hyperlink,
Ctrl + Z
Undo the last action
F11
For creating the chart
Shift
For Additional functions, hold on to Shift
Shift + F4
To find the next
Shift + F5
To find the value
Alt + F1
For inserting the chart
F1
For opening Excel, help
F5
For opening the "Go To" dialog box
F7
For opening the spell checker dialog box
F10
For activating menubar
Shift + F7
View object
Shift + F8
For adding selection
Shift + F9
Quick watch
Shift + F10
For showing the right-click menu
Ctrl+ F4
Close the window
Ctrl + F10
For activating menubar
Alt + F4
Closes VBA
Alt + F6
Switch between the last two windows
Alt + F11
For opening VBE
Alt + Spacebar
Go to the System menu
Alt + Backspace
Undo the last action
Ctrl + E
For Exporting the module
Ctrl + G
Show the "Go To Dialog " box
Ctrl + H
To replace the value
Ctrl + J
Methods/List properties
Ctrl +L
For showing the Call Stack
Ctrl + TAB
Go to cycle windows
Ctrl + Shift + I
For editing parameter info
Ctrl + Shift + J
For editing, List constants
Ctrl + F1
To show or hide the ribbons
Alt + Shift +
For grouping Rows or Columns
Alt + Shift +
For Ungrouping Rows or Columns
Ctrl + Shift + L
For Adding/Removing the filter
Essential Hot Keys
Shortcut Keys
Purpose/Description
Ctrl + F7
For moving down
Ctrl + shift + _
For removing the outline border around the selected cell
Ctrl +5
For applying/Removing strikes via formatting
Shift +F6
For moving the previous pane
F6
For moving the next pane
Home
To move the beginning of the line
End
For moving end of line
Shift +
To extend the selection, the left-side
Shift +
To extend the selection, the right-side
Shift +
To extend the selection up side
Shift +
To extend the selection downside
Shift + Tab
Outdent
Alt + Tab
For Moving to cycle applications
Ctrl + Home
Top OF Module
Ctrl + End
End OF Module
Ctrl + PGUP
For Going to the top of the current procedure in another sheet
Ctrl + PGDN
For Going to the top of the current procedure in another sheet
Ctrl +
To move one word to the left
Ctrl +
To move one word to the right
Ctrl +
Go up till the blank cell
Ctrl +
Go down to the blank cell
Shift + Enter
Enter to Move up
Ctrl + Shift + &
For placing the outline border around the selected cell
Ctrl + Shift + *
For inserting the current time
Ctrl + 9
For hiding the rows
Ctrl + 0
For hiding the columns
Ctrl + Shift + (
For unhide the rows
Ctrl + Shift + )
For unhide the columns
Ctrl + Enter
For filling the selected cell range with the current entry
Ctrl + Spacebar
For selecting the entire row
Ctrl + /
For selecting the array containing the active cell
Ctrl + Shift + O
For selecting all the rows containing comments
Ctrl + \
For selecting the cells that don't match the formula
Ctrl + Shift +I
For selecting the cells that don't match the formula
Ctrl + [
For selecting the directly referenced cells by formulas in the selection
Ctrl Shift + {
For selecting cells directly/indirectly referenced by the Formulas
Ctrl + ]
For selecting cells that contain formulas directly referenced, the selection
Ctrl + Shift + }
For selecting cells directly/indirectly referenced by the Formulas
Alt + ;
For selecting the current selection's visible cells
Shift + Backspace
For selecting only active cell
Ctrl + Shift + Spacebar
For selecting the entire worksheet
Ctrl + Alt + L
For reapplying the filter and sorting on the current range
Ctrl + C
Copy
Ctrl + D
For filling down
Ctrl + "
For filling down
F2
For editing active cell
F8
Extend selection mode
INS
To toggle insert mode
DEL
For deleting the selected values
Backspace
For deleting the previous values
Shift + INS
For pasting the data
Shift + Home
For selecting the start of the line
Shift + End
For selecting till the end of the line
Shift + PGUP
For selecting the top of the module
Shift + PGDN
For selecting the end of the module
Ctrl + A
For selecting data without the blanks
Ctrl + F
For finding the value
Ctrl + INS
For copying the selected value
Ctrl + Spacebar
For selecting the complete row
Ctrl + Backspace
Going to delete the start of the word
Shift + DEL
For cut the selection
Shortcut Keys for Windows
Shortcut Keys
Purpose/Description
Windows Symbol
Starts the menu
Windows Symbol + R
Runs dialog box
Windows Symbol + M
For minimizing all
Shift + Windows Symbol + M
To undo minimizing all
Windows Symbol + F1
For help
Windows Symbol + E
For opening Windows Explorer
Windows Symbol + F
For finding files or folders
Windows Symbol +D
To minimize all open windows and displays, the desktop