Ctrl + `: To change the view from displaying cell values to formulas.Ģ8. Ctrl + : To enter the current date in a cell.Ģ7. Ctrl + Shift + :: To enter the current time in a cell.Ģ6. Ctrl + 8: To show the outline symbols.Ģ5. Ctrl + 5: To put a strikethrough in a cell.Ģ2. Ctrl + 1: To format the cell contents.Ģ1. Ctrl + W: To close your current workbook.Ģ0. Ctrl + V: To paste anything that was copied.ġ8. Ctrl + U: To underline highlighted cells.ġ7. Ctrl + R: To fill the selected cell with the content of the cell on the left.ġ6. Ctrl + L: To open the create table dialog box.ġ5. Ctrl + K: To insert a hyperlink in a cell.ġ3. Ctrl + H: To find and replace cell contents.ġ1. Ctrl + G: To jump to a certain area with a single command.ġ0. Ctrl + F: To search for anything in a workbook.ĩ. Ctrl + D: To fill the selected cell with the content of the cell right above.Ĩ. Ctrl + C: To copy cells that are highlighted.ħ. Ctrl + B: To turn highlighted cells bold.Ħ. Ctrl + A: To select all the contents in a workbook.ĥ. However, we have picked out some of the most useful shortcuts, and we hope this would be worth your time.Ĥ. Example: 5.Before you proceed, note that the list is pretty long but it is by no means a complete list consisting of all the Excel shortcuts. CTRL + SHIFT + 6 = Format the cell as a standard ‘Scientific Value’ with two decimal points.CTRL + SHIFT + 5 = Format the cell as a standard ‘Percentage’ with no decimal points.CTRL + SHIFT + 4 = Format the cell as a standard ‘Currency’ with $, two decimal points, red negative numbers, and () around negative numbers.CTRL + SHIFT + 3 = Make the cell a custom date with the format d-mmm-yy.CTRL + SHIFT + 2 = Make the cell a custom time with the format h:mm AM/PM.CTRL + SHIFT + 1 = Format the cell as a standard ‘Number’ with (,) separator and two decimal points. Example: 1,000.25.6) CTRL + SHIFT + Īnother quick way to automatically format the text in a cell is to use the CTRL + SHIFT + any number between 1 and 7. While the format options with these keystrokes are limited, you can’t beat the speed when one of these formats is what you’re needing! Just press CTRL + 1, and then use the tab key and arrow keys to cycle through the different options within the Format Cells dialog box. Need to change the format of the cells quickly without having to right click, scroll down through the context menu, and click ‘Format Cells’? CTRL + 1 is the shortcut for the Format Cells dialog box. F2 opens the formula bar, allowing you to immediately edit the formula in the current cell without having to use the mouse to move the cursor up to the formula bar. 4) F2 keyĪnother keystroke for improving your Excel speed is the F2 key. Hold CTRL and press PgUp or PgDown rapidly to move quickly through the tabs list. The CTRL + PgUp and CTRL + PgDown keystrokes move between tabs automatically.ĬTRL + PgDown moves to the tab immediately to the right, and CTRL + PgUp moves to the tab immediately to the left. Moving between worksheet tabs can be time consuming with the mouse, especially when you have so many tabs that the tabs don’t all fit on the screen.
#Excel shortcut keys display formula plus
The SHIFT plus Arrow keystroke allows you to select multiple cells at once.Īdd the CTRL key to your SHIFT + Arrow shortcut to select large ranges of cells at once. If you plan to abandon the mouse in Excel, it is essential that you learn to select cells with your keyboard. Once you master this key stroke, moving around the worksheet becomes much quicker than moving around the worksheet with the mouse. Similarly, if the cursor is in a cell with no data immediately to the right and you press CTRL + Arrow right, the cursor will move to the first cell to the right that contains data (regardless of how far away that cell is). For example, if you are on a row with data filling all cells 15 cells to the right, pressing CTRL + Arrow right will move the cursor 15 rows to the right or to the edge of the data in that row. Pressing CTRL + an Arrow key will move the cursor from its current location to the edge of the current data region in a worksheet. The CTRL + Arrow key sequence remedies this problem. The problem with this is, as your worksheet grows in size, it can take forever to get from one end of a row or column to the other. While the arrow keys are used to navigate around the worksheet, they only move one cell at a time.
#Excel shortcut keys display formula Pc
Note: These keyboard shortcuts are for PC use 1) CTRL + Arrow Key