40 shortcut keys in Excel that double the speed of your work

We have compiled a list of 40 useful shortcut keys (the first 10 are the most useful) so that you can use them to the maximum and save a considerable amount of time.

Repeat the last command or task you did

Shortcut keys:

  • F4 (on PC)
  • Command + Y (on Mac)

Function:

Repeat the last command or action in the worksheet if possible.

Tips

After performing the desired operation, select any cell you want and then press the F4 key .

Continue the selection operation until the last non-empty cell

Shortcut key:

  • Ctrl + Shift + Arrow Key (on PC)
  • Command + Shift + Arrow Key (on Mac)

Function:

With this shortcut you can select as many cells as you want.

Tips

Select a cell and if you want to select the next cells connected to it, use the shortcut keys and 4-way keys to increase your selection range.

You can also use this shortcut to select a range, a column or a row. For example, if you want to delete rows after the 50th house, select row 51 and press Ctrl + Shift + Down Arrow to select the next cells . Then press Ctrl + – and delete them.

Select the current range

Shortcut key:

  • Ctrl + Shift + Spacebar (on PC)
  • Command + Shift + Spacebar (on Mac)

Function:

If your worksheet contains data, select the shortcut keys Ctrl + Shift + Spacebar for the current range that contains the data.

Press Ctrl + Shift + Spacebar a second time to select its column header and summary cells ( summary _ if any).

Pressing Ctrl + Shift + Spacebar for the third time selects the entire worksheet.

Tips

The selection of titles and summary rows is done only in Excel tables (not applicable in Word and other software). Because summary headers and rows in Excel software tables act differently than regular cells.

Fill several cells together

Shortcut key:

  • Ctrl + Enter (on PC)
  • Cmd + Enter (on Mac)

Function:

Fill multiple cells with a static formula or value (same as copying, but easier and faster).

Tips

Select the cells in which you want to enter or modify the formulas. Then type your formula and press Ctrl + Enter to apply to all selected cells. Note that if you use the “$” character to lock rows or columns, Excel will retain cell resources as before. Otherwise, Excel software matches the resources in a “logical” way to match any row or column list.

You can use this shortcut and easily, instead of copying and pasting the contents of the cell each time, select it once and move it to multiple points.

Automatically adjust column width

Shortcut key:

  • Alt, H, O, I (on computer)

Function:

Adjusts the width of the column to automatically fit its contents.

Tips

Press the shortcut keys, you do not need to hold them all at once (first Alt , then H , then O , then I ). This shortcut is not available for Mac in Excel2016 .

Open the drop-down menu

Shortcut key:

  • Alt + Down Arrow (PC and Mac)

operator:

If the cell has data validation , the data validation lists will open (sliding).

If the cell does not have data validation and there is data in the same column, this function creates a drop-down list of the items you want in that column.

And If the filter feature is applied to a range or table, the filter drop-down menu opens.

Tips

This shortcut also works in some web browsers and other applications.

Go To

Shortcut key:

  • F5 (on PC and Mac)
  • Ctrl + G (on PC)

Performance :

Opens the Go to window . Double-click on this list to select a range or name or reference.

Tips

You can open the Go To Special window by pressing the Special button . Use this feature to find objects, formulas, validations, or other elements in your worksheet.

Paste the name

Shortcut key:

  • F3 (on PC and Mac)

Function:

Opens the Paste Name window . Double-click on a name to enter it into a formula.

Tips

You can also do this via the Insert tab ( Insert > Name > Paste ). This shortcut is not available for Mac version of Excel2016 .

Data navigation

Shortcut key:

  • Ctrl + four-way arrows (on PC)
  • Command + four-way keys (on Mac)

Performance :

Fast scrolling between data. Use this shortcut key to move between cells.

Tips

This shortcut key can be very useful when working with a large data set. Please note that in this method Excel is looking for an empty cell and the navigation keys do not move and stop when they reach an empty cell.

General shortcuts

You may already be familiar with these shortcuts because these shortcuts are usually supported by most software programs.

Save

  • Ctrl + S (on PC)
  • Command + S (on Mac)

New workbook

  • Ctrl + N (on PC)
  • Command + N (on Mac)

Close workbook

  • Ctrl + W (on PC)
  • Command + W (on Mac)

Print

  • Ctrl + P (on PC)
  • Command + P (on Mac)

Select all

  • Ctrl + A (on PC)
  • Command A (on Mac)

Cut, copy, paste

  • Ctrl + X, Ctrl + C, Ctrl + V (on PC)
  • Command + X, Command + C, Command + V (on Mac)

Select with Shift and Ctrl

  • Hold down the Shift key and click on another point to select the entire range between the two cells.
  • Select multiple cells one at a time by holding down the Ctrl (Command) key .

Home, End, Page Up, Page Down

  • The Home key moves you to the leftmost cell, Ctrl + Home moves you to the top-left cell ( you move to A1 by default ).
  • The End key moves you to the rightmost cell, Ctrl + End moves you to the bottom-right cell.
  • The Page Up and Page Down keys move the worksheet up and down.

Undo and Redo

  • Ctrl + Z, Ctrl + Y (on PC) ( Redo action in Excel is different from Shift + Ctrl + Z shortcut in other MS Office software)
  • Command + Z , Command + Y (on Mac) ( Redo function in Excel is different from the shortcut Shift + Command + Z in other MS Office software)

Find and Find and replace

Ctrl + F finds the Find   menu , in which you can search for your worksheet values. Ctrl + H ( Command + H on Mac) Opens the Find and Replace menu, where you can search for values ​​and replace them with a different value. (On computer)

List of other Excel shortcuts

Tip: The plus sign “+” means that the keys must be pressed at the same time. The Ctrl and Alt keys are on the left and bottom right of most keyboards.

Ctrl + N Creates a new worksheet
Ctrl + O Opens an existing worksheet
Ctrl + S Saves the active worksheet
F12 Saves the active worksheet with a new name and opens the Save as dialog box
Ctrl + W Closes the active worksheet
Ctrl + C Copies the contents of the selected cells to the Clipboard .
Ctrl + X Cuts the contents of the selected cells and saves them on the Clipboard .
Ctrl + V Inserts the contents of the Clipboard into the selected cell (s).
Ctrl + Z Cancel your last action with this shortcut and go back.
Ctrl + P Opens the ” Print ” dialog box .

Data formatting

Ctrl +1 Opens the “Format Cells” dialog box .
Ctrl + T Use this shortcut to convert selected cells into a table. You can also select any cell in a range of related data and press Ctrl + T to convert them to a table.

Working with formulas

Tab Complete the function name. For example, type = and add vl , press Tab . You will receive the phrase = vlookup .
F4 Use different types of formulas. Place the cursor inside a cell and hit F4 to show you the types of reference formulas: absolute, relative, or mixed (relative column and absolute row, absolute column, and relative row).
Ctrl + ` Shows cell values ​​and formulas in a related way.
Ctrl + ‘ Insert the top cell formula into the selected cell or formula bar.

Scroll and view data

Ctrl + F1 Show or hide the excel bar. Hiding the ribbon reveals 4 more rows of data.
Ctrl + Tab Move to another open worksheet.
Ctrl + PgDown Go to the next worksheet. Press Ctrl + PgUp to go to the previous tab.
Ctrl + G Open the “Go to” dialog box . To do this you can press F5 .
Ctrl + F Open the ” Find ” dialog box .
Home Navigate to the first cell in the current worksheet row.
Ctrl + Home Go to the beginning of the worksheet (cell A1 ).
Ctrl + End Navigate to the last cell used in the worksheet, the bottom row and the rightmost column.

Enter data

F2 Edit the current cell.
Alt + Enter In cell editing mode, insert a new line ( carriage return – moves the cursor to the first row) into a cell.
Ctrl +; Enter the current date. To enter the current time Ctrl + Shift +; Press.
Ctrl + Enter Fill the selected cells with the contents of the current cell. For example: Select multiple cells. Press and hold Ctrl , click on any number of cells you want and press F2 to edit it. Then press Ctrl + Enter . The contents of the edited cell are copied to all selected cells.
Ctrl + D Copy the contents and format of the first cell to the cells at the bottom of the selected range. If more than one column is selected, the contents of the top cell are copied down in the next columns.
Ctrl + Shift + V When the clipboard is not empty (you have copied something), open the “Paste Special” window.
Ctrl + Y If possible, cancel the last operation and return to the previous state.

Data selection

Ctrl + A Select the entire page. If the cursor is currently in a table, press the shortcut once to select the table, press it again to select the entire worksheet.
Ctrl + Home
then
Ctrl + Shift + End
Select the range of data you use in your current worksheet.
Ctrl + Space Select the entire column.
Shift + Space Select the entire row ..

Leave a Reply

Your email address will not be published. Required fields are marked *