30 Excel shortcut keys that make Excel user friendly - KING OF EXCEL

Friday, November 13, 2020

30 Excel shortcut keys that make Excel user friendly

 

30 Excel shortcut keys that make Excel user friendly

If you are managing some big data, then Excel shortcuts are used a lot to easily change the data. In this article, we are going to learn about shortcuts on a similar simple that can easily jump, copy, paste and select data.

30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

30 Important Excel Shortcut Keys

  1. Ctrl + Down Arrow
  2. Ctrl + Right Arrow
  3. Ctrl + Up Arrow
  4. Ctrl + Left Arrow
  5. Ctrl + A
  6. Ctrl + Shift + Right Arrow
  7. Ctrl + Shift + Down Arrow
  8. Ctrl + Shift + Left Arrow
  9. Ctrl + Shift + Up Arrow
  10. Ctrl + Home
  11. F2
  12. F4
  13. Esc
  14. Ctrl + PgUp
  15. Ctrl + PgDn
  16. Ctrl + X
  17. Ctrl + Y
  18. Ctrl + Z
  19. Ctrl + C
  20. Ctrl + V
  21. Ctrl + B
  22. Ctrl + I
  23. Ctrl + U
  24. Ctrl + D
  25. Ctrl + R
  26. Ctrl + F
  27. Ctrl + H
  28. Ctrl + S
  29. Ctrl + P
  30. Ctrl + Alt + V
Lets Learn…….

  • Excel will navigate to the last entry of any Arrow button you use with the control button.

1. Ctrl + Down Arrow – Go to the last cell of the column

If you enter any cell and you want to enter the Las cell of the same column, then press and hold down the control and press the down arrow. Excel will navigate to the last entry of the table.

Ctrl + Down Arrow - Go to the last cell of the column 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


2. Ctrl + Right Arrow – Go to the last cell of Row

If you enter any cell and you want to go to the last cell of the same row, press and hold the control and press the right arrow button. Excel will navigate to the cell that is the last entry of the table’s row.

2. Ctrl + Right Arrow - Go to the last cell of Row 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

3. Ctrl + Up Arrow – Go to the table heading cell

This MS Excel shortcut Key is used to access the cell of the headings of any table. Can easily go to headings.

Ctrl + Up Arrow - Go to the table heading cell 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

4. Ctrl + Left Arrow– Go to the cell in the first column of the table

Using this Excel shortcuts Key from any cell, we can enter the cell in the first column of the table.

Ctrl + Left Arrow- Go to the cell in the first column of the table 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

5. Ctrl + A – Selecting all data

Click on any cell in the table and press Ctrl + A. The data of the entire table will be selected.

Ctrl + A - Selecting all data 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


6. Ctrl + Shift + Right Arrow – Selecting the cell on the right side

With this Excel Shortcut Key, you can select all the Right Side Cells.
If any 2 row in the column of 1 number is selected, then the entire row can be selected by using the shortcut Ctrl + Shift + Right Arrow.

Ctrl + Shift + Right Arrow - Selecting the cell on the right side 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

7. Ctrl + Shift + Down Arrow Selecting the table below the selected cell.

Used to select the column from the selected cell to the end of the table.

Ctrl + Shift + Down Arrow -Selecting the table below the selected cell. 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


8. Ctrl + Shift + Left Arrow –Selecting the left table from the selected cell

Ctrl + Shift + Left Arrow  is used to select the row from the selected cell to the end of the table left side.

Ctrl + Shift + Left Arrow -Selecting the left table from the selected cell 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


9. Ctrl + Shift + Up Arrow – To select the data above the selected cell

All the data above the selected cell is selected with this Excel shortcut Keys.

Ctrl + Shift + Up Arrow - To select the data above the selected cell 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

10. Ctrl + Home  – Go to cell A1

You are entered on any cell of the sheet, and if you want to go to the first cell of the sheet, then Press Ctrl+Home. You can go to cell A1 with this Excel shortcut Key.

Ctrl + Home  - Go to cell A1 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


11. F2 – Go to edit mode of cell

If you want to edit the text or formula of any cell, after clicking on that cell, press F2, we can change anything in the data of the cell.

F2 - Go to edit mode of cell 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


12. F4 – Redo last activity

F4 is used to perform any activity again and again. Suppose you delete the Column and again if you want to delete the Column, press F4. The action that was done in the end will repeat again. Only the last one action is repeated.

F4 - Redo last activity 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

13.1. Esc – Deactivating Copy Mode

If you copied any data, some functions do not work on copy mode. The Esc button is used to bring the copy mode to normal mode.

Esc - Deactivating Copy Mode 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

13.2. Esc – Close any window of the function

If the sheet of Excel opens the window of any function, the Esc button is also used to close it.

Esc - Close any window of the function 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

  • Ctrl + PgDn & PgUp – This Excel Shortcut Keys is used to move from one sheet to another.30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

14. Ctrl + PgUp – Go to next sheet

Ctrl + PgDn is used to move to the sheet next to the one on which you are entered.

Ctrl + PgUp - Go to next sheet 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

15. Ctrl + PgDn – Go to back sheet

Ctrl + PgUp is used to go back to the sheet on which you are entering the sheet.

Ctrl + PgDn - Go to back sheet 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details


16. Ctrl + C – Copying Selected Data

We copy and paste the selected data at another place. Common Shortcut Key Ctrl + C is used to copy.

Ctrl + C - Copying Selected Data 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

17. Ctrl + X – Selective data cutting

We use the Cut and Paste option to move the selected data to another place. Ctrl + X cuts the data, and on pasting the data moves to that place.

Ctrl + X - Selective data cutting 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

18. Ctrl + V – To paste

Ctrl + V is the shortcut used to paste cut or copied data.

 Ctrl + V - To paste 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

19. Ctrl + Z – Undo 

Ctrl + Z is used to go into one step reverse of any activity. If a cell contains some text and the text was deleted by mistake. Then we can press Ctrl + Z to bring the same text again. Any such activity can go in reverse with Ctrl + Z.

Ctrl + Z - Undo  30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

20. Ctrl + Y – Redo 

Ctrl + Y is used to Return the activity of Ctrl + Z again.

Ctrl + Y - Redo  30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

21. Ctrl + B – Text bold

Ctrl + B - Text bold 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

22. Ctrl + I  –  Italicizing text

Ctrl + I  -  Italicizing text 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

 23. Ctrl + U – Underline text

Ctrl + U - Underline text 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

24. Ctrl + F  – Search Data 

You can find any data in the workbook by entering text or number in the search box. Ctrl + F This Excel Shortcut Key is used to show the search box.
Ctrl + F  - Search Data  30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

25. Ctrl + H  – Data replacement

Replace is used if you want to change something in the data. Replace Option also finds and replaces the data. Ctrl + H This is the Excel Shortcut Key to show the window of the Replace.

Ctrl + H  - Data replacement 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

26. Ctrl + D  – Fill down

The top cell’s data is Ctrl + D Excel Shortcut Key to fill the cell below.


Ctrl + D  - Fill down 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

27. Ctrl + R  – Fill Right

Ctrl + R is the Excel Shortcut Key to fill the left cell data in the right side cell.

Ctrl + R  - Fill Right 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

28. Ctrl + S   – Save file

Ctrl + S   - Save file 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

29. Ctrl + P – To print

Ctrl + P - To print 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

30. Ctrl + Alt + V   – Paste Special

Ctrl + Alt + V This is the Excel Shortcut Key used to open a paste special window.

Learn Transpose Function 

Ctrl + Alt + V   - Paste Special 30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details
#evba #etipfree #eama #kingexcel 

Popular Posts