Excel Shortcuts – 10 Must know shortcuts to speed up your working

Excel shortcuts keys - Feature images

10 Must know Excel Shortcuts to speed up your working: –

We can do our work in excel more efficiently with excel shortcuts key. Today we will discuss 10 daily use excel shortcuts keys. With help of these shortcuts, you will save your time more and done work quickly.

Please Note: – Your mind will take few days to store these all shortcuts, Firstly you will spend more time on using it after some time you will very fluent in it and then you will release it easy to remember.

 

Download the PDF file of all Excel shortcuts from the Following link: –

 

The Following are the Key symbol of the Mac 

Mac Keys symbols  - Excel Shortcuts -  10 Must know shortcuts to speed up your working
Mac Keys symbols

1. Copy, Cut and Paste 

Most of the people already knew it. But these are the very important excel shortcuts if you don’t Know then remember it first.

  • Copy: –  This command is used to copy the value/Formula of one or a group of cells.
  • Cut: –  This command is used to move the value/Formula of one or a group of cells.
  • Paste: –  This command is used to Paste the value/Formula of one or a group of cells which is already copied or cut with above commands.
Command to   Window shortcut Mac Shortcut
Copy  Ctrl + C Command Key + C
Cut Ctrl + C Command Key + X
Paste Ctrl + V Command Key + V

 

2. Copy to Right and Down Cell: 

To do more fast copy-paste shortcuts in the next row or column, you can use this commands because in copy and paste you have to copy the content first with “Ctrl + C” and then paste it with “Ctrl + V” but you will perform both the actions together with a single shortcut key.

  • Copy Right: –  This command is used to copy the value/Formula from left cell to the right cell.
  • Copy Down: –  This command is used to copy the value/Formula from above cell to the below cell.
Command to   Window shortcut Mac Shortcut
Copy Right Ctrl + R Command Key +  R
Copy Down Ctrl + D Command Key + D

 

3. Special Paste: 

If you want to paste the value(or other options) of the cell, not a formula included in it, then you have to use a special paste option of excel. Here is the shortcut to perform this instead of using a mouse.

  • Show Special Paste Window: –  This command is used to copy the value/Formula from left cell to the right cell.
  • Paste Value only: –  This command is used to copy the value/Formula from above cell to the below cell.
Command to  Window shortcut Mac Shortcut
Show Special Paste Window Ctrl + Alt + V Command Key + Control Key +  V
Paste Value only Ctrl + Alt + V  and then press the Only V Enter Command Key + Control Key+V and then press the Only V Enter

4.The shift from one cell to another: 

If you want to shift cursor fast from one cell to another then use these shortcuts. These shortcuts will allow you to shift from the first filled cell to the last filled cell within the row or column.

Shift your cursor from: –

  • Left to Right between the filled cells: –  This command is used to shift from the left side to the right side form the selected cell to the last filled cells in the row.
  • Right to Left between the filled cells: –  This command is used to shift from the right side to the left side form the selected cell to the last filled cells in the row.
  • Up to Down between the filled cells: –  This command is used to shift from the upside to the downside form the selected cell to the last filled cells in the column.
  • Down to Up between the filled cells: –  This command is used to shift from the downside to the upside form the selected cell to the last filled cells in the column.
Command to   Window shortcut Mac Shortcut
Shift Left to Right between the filled cells Ctrl +  Right arrow - Excel Shortcuts -  10 Must know shortcuts to speed up your working Control Key Right arrow - Excel Shortcuts -  10 Must know shortcuts to speed up your working
Shift Right to Left between the filled cells Ctrl +  left arrow - Excel Shortcuts -  10 Must know shortcuts to speed up your working Control Key +  left arrow - Excel Shortcuts -  10 Must know shortcuts to speed up your working
Shift Up to Down between the filled cells Ctrl +Down arrow 150x150 - Excel Shortcuts -  10 Must know shortcuts to speed up your working Control Key +Down arrow 150x150 - Excel Shortcuts -  10 Must know shortcuts to speed up your working
Shift Down to Up between the filled cells Ctrl +up arrow - Excel Shortcuts -  10 Must know shortcuts to speed up your working Control Key +up arrow - Excel Shortcuts -  10 Must know shortcuts to speed up your working
Shift left, right, up and down  Use arrow keys Use arrow keys

5. Select Entire Row, and Column, Table, or worksheet

If you want to select an entire row, column, table or worksheet fast then use the following excel shortcuts key: –

Select An entire: –

  • Row: –  This command is used to select an entire row of the selected cell. if you have selected more then one cell then this command will select all rows of selected cells.
  • Column: –  This command is used to select an entire column of the selected cell. if you have selected more then one cell then this command will select all column of selected cells.
  • Workbook, Table: –  This command is used to select an entire worksheet or table.
Command to  Window shortcut Mac Shortcut
Select a Row Shift + Space Bar Shift Key + Space Bar
Select a Column Ctrl + Space Bar Control Key + Space Bar
Select a worksheet, Table Ctrl + A Command Key + A

6. Hide Row and Column: 

If you want to select hide row or column fast then use the following excel shortcuts key: –

  • Hide Row: –  This command is used to hide the row of the workbook. You can hide more than one row together by selecting them.
  • Hide Column: – This command is used to hide the column of the workbook. You can also hide more than one column together by selecting them.
Command to  Window shortcut Mac Shortcut
Hide Row Ctrl + 9 Control Key + 9
Hide Column Ctrl + 0 Control Key + 0

7. Redo, Undo and Repeat the last action: 

  • Redo: – Redo means do your last actions of undo command.
  • Undo: – Undo means undo your last action. If you did anything wrong then you can use this command.
  • Repeat the last action: – It is similar to Redo but with redo command you can only redo your all undo actions. In repeat command, you can perform this action as many time as you want.
Command to  Window shortcut Mac Shortcut
Redo the last action Ctrl + Y Command Key + Y
Undo the last action Ctrl + Z Command Key + Z
Repeat the last action F4 Command Key + Y

8. Find and Replace value: 

  • Find: – Use this command to find the desired value from the entire worksheet or selected row or column.
  • Replace: – Use this command to Replace the desired value with the already exit value in the entire worksheet or selected row or column.
Command to  Window shortcut Mac Shortcut
Find any value Ctrl + F Command Key + F
Replace any value Ctrl + H Control Key + H

9. Print and Print Preview: 

  • Print: – Use this command to print the current worksheet.
  • Print Preview: – Use this command to get the print preview the current worksheet.
Command to   Window shortcut Mac Shortcut
Print Ctrl + P Command Key + P
Print Preview Ctrl + F2  N/A

10. Save and Save as workbook: 

  • Save: – Use this command to save the current workbook.
  • Save as: – Use this command to save a copy of the same workbook.
Command to  Window shortcut Mac Shortcut
Save  Ctrl + S Command Key + S
Save as  alt+ F2 or F12 Command Key + Shift Key + S

 

Thanks for reading the topic of “Excel Shortcuts – 10 Must know shortcuts to speed up your working, please comment your feedback whatever you want. If you have any question please ask us by commenting.