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
- F4 (on PC)
- Command + Y (on Mac)
Repeat the last command or action in the worksheet if possible.
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
- Ctrl + Shift + Arrow Key (on PC)
- Command + Shift + Arrow Key (on Mac)
With this shortcut you can select as many cells as you want.
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
- Ctrl + Shift + Spacebar (on PC)
- Command + Shift + Spacebar (on Mac)
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.
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
- Ctrl + Enter (on PC)
- Cmd + Enter (on Mac)
Fill multiple cells with a static formula or value (same as copying, but easier and faster).
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
- Alt, H, O, I (on computer)
Adjusts the width of the column to automatically fit its contents.
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
- Alt + Down Arrow (PC and Mac)
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.
This shortcut also works in some web browsers and other applications.
- F5 (on PC and Mac)
- Ctrl + G (on PC)
Opens the Go to window . Double-click on this list to select a range or name or reference.
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
- F3 (on PC and Mac)
Opens the Paste Name window . Double-click on a name to enter it into a formula.
You can also do this via the Insert tab ( Insert > Name > Paste ). This shortcut is not available for Mac version of Excel2016 .
- Ctrl + four-way arrows (on PC)
- Command + four-way keys (on Mac)
Fast scrolling between data. Use this shortcut key to move between cells.
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.
You may already be familiar with these shortcuts because these shortcuts are usually supported by most software programs.
- Ctrl + S (on PC)
- Command + S (on Mac)
- Ctrl + N (on PC)
- Command + N (on Mac)
- Ctrl + W (on PC)
- Command + W (on Mac)
- Ctrl + P (on PC)
- Command + P (on Mac)
- 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 .|
|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.|
|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.|
|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
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 ..|