Awesome Excel Shortcuts keys

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.

3 views