Excel is one of the most amazing tools for data analysis. It saves our lot of time if we will use Excel with shortcut keys. Let me share with you a few most amazing excel shortcut keys:
Moving Around the Excel Worksheet:
Move one cell up = ↑ arrow key
Move one cell down = ↓ arrow key
Move one cell right = → arrow key
Move one cell left = ← arrow key
Move to beginning of row = Home
Move to beginning of worksheet = Ctrl + Home
Move to the bottom right corner of worksheet = Ctrl + End
Move one screen right = Alt + Page Down
Move one screen left = Alt + Page Up
Repeat the last action = F4 ... Especially useful when inserting rows or columns.
Helpful Hints
The + in the description means "and" - not the + key. Just hold down one key while pressing the other key.
If you want to learn in advance level Excel then you may check out this Excel course. Let me show you a few interesting excel shortcut keys below now.
Working With Data in Cells:
Cancel action or selection = ESC ... Also to remove squiggly lines after a Copy.
Undo the last action = Ctrl + Z or Alt + Backspace ...Maybe pressed multiple times to undo multiple actions.
Redo the last action = Ctrl + Y
Edit cell contents inside the cell = Double-click in a cell or Click + F2
Toggle
between cell values and formulas = Ctrl + ` ... The left apostrophe key
is located to the left of the number 1 on many keyboards.
Copy to clipboard = Ctrl + C ... For use in cut and paste.
Cut data = Ctrl + X ... For use in cut and paste.
Paste from clipboard = Ctrl + V
Fill down = Ctrl + D ... Select (highlight) cell with data and desired number of cells below it. Then press **Ctrl + D**.
Fill to the right = Ctrl + R ... Select cell with data and highlight to select an appropriate number of cells to the right to fill. Then press Ctrl + R. Can fill to the right multiple cells in a column.
Format with bold = Ctrl + B
Format with italics = Ctrl + I
Format with underscore = Ctrl + U
Insert a hyperlink = Ctrl + K
Display "Format Cells" window = Ctrl + 1
Display Find and Replace (find tab) = Ctrl + F
Display Find and Replace (replace tab) = Ctrl + H
Insert date = Ctrl + ;
Insert time = Ctrl + Shift + :
Insert date and time = Ctrl + ; press the spacebar Ctrl + Shift + :
This video also helpful for the understanding of the excel use.
Selecting (Highlighting) Cells
Select column = Ctrl + Spacebar
Select row = Shift + Spacebar
Select all cells = Ctrl + A ... Can also click the top left square of the worksheet to select all spreadsheet cells.
Select
adjacent cells = Shift + Click ... Click on the first cell, press and
hold the Shift key, and click in the last cell to be selected.
Select
non-adjacent cells = Ctrl + Click ... Click on the first cell, press
and hold Ctrl key while clicking in other cells to be selected.
This channel also helpful for the understanding of free excel.
Working with Excel Worksheets and Workbooks
Save worksheet = Ctrl + S
Open "Save As" window = F12
Open Print window = Ctrl + P or Ctrl + F2
Insert a new worksheet = Shift + F11 ... inserts it left of the active sheet
Create new workbook = Ctrl + N
Open existing workbook = Ctrl + O
Close current workbook = Ctrl + W
Exit Excel = Alt + F4
Insert chart in worksheet = Alt + F1 ... First, select cells to a graph, then use a shortcut.
Create a chart in a new worksheet = F11 ... First, select cells to the graph, then use a shortcut.
I hope, these shortcut keys will helpful for you. If you belong to the USA Then you may join Self growth growth learn and teach as well.