Excel is a computational tool in Office 2016. In the updated version of Excel 2016 is the latest version today. With the increasing number of users, the optimization of the calculation is Microsoft’s focus. Today I will introduce you to the keyboard shortcuts in Excel, to see how it is optimal progress offline.
Keyboard shortcuts Excel 2007, 2010, 2016
Arrow Keys: Move the cursor up, down, left, or right in a spreadsheet.
Page Down / Page Up: Move the user window to the bottom of the workbook at the top of the spreadsheet.
Alt + Page Down / Alt + Page Up : Move the screen right / left in a spreadsheet.
T / Shift + Tab: Move the cursor one cell right / left in a spreadsheet.
Home: Move the cursor to the beginning of a row in a spreadsheet.
Ctrl + Home: Move the cursor to the first cell of a spreadsheet.
Ctrl + End: Move the cursor to the last cell containing the content on a worksheet.
Ctrl + F: Displays the Find and Replace dialog box.
Ctrl + H: Displays the Find and Replace dialog box.
Shift + F4: the Previous search is repeated.
Ctrl + G (or F5) : Opens the ‘Go to’ dialog box.
Ctrl + left arrow / Ctrl + Right arrow: Inside a cell: Move the cursor to the left or right cell of the cell.
Alt + Down arrow: Opens the AutoComplete list.
Manipulate selected data
Shift + Space key: Select the entire row.
Ctrl + Space : Select the entire column.
Ctrl + Shift + * (star) : Selects the entire area around active cells.
Ctrl + A (or Ctrl + Shift + spacebar) : Selects the entire worksheet (or areas of data).
Ctrl + Shift + Page Up: Select the current and previous sheet in the same Excel file.
Shift + arrow keys: Extend the selection from the selected cell.
Shift + Page Down / Shift + Page Up: Extend the selected area to the bottom of the page/screen to the top of the screen.
Shift + Home: Expands the selected area to the first cell of the row.
Ctrl + Shift + Home: Expands the selection to the first of the spreadsheets.
Ctrl + Shift + End: Expands the selection to the last cell used on the spreadsheet (lower right corner).
Management in selected areas
F8: Enables the selection extension (by using additional arrow keys) without holding down the Shift key.
Shift + F8: Add an (adjacent or not adjacent) range of cells to choose from. Use the arrow keys and Shift + Arrow Keys to add to the selection.
Enter / Shift + Enter: Moves the current selection of cells to / from the selected area.
Tab / Shift + Tab: Moves the current selection of cells to the right / left in the currently selected area.
Esc: Remove the selected area.
Edit inside the box
Shift + left arrow / Shift + right arrow : Select or deselect a character on the left / right.
Ctrl + Shift + left arrow / Ctrl + Shift + right arrow : Select or deselect a word on the left / right.
Shift + Home / Shift + End : Select from text cursor to beginning / end of cell.
Keyboard shortcuts in Excel 2007, 2010, 2016 insert and edit data
Undo / Redo shortcut
Ctrl + Z : Undo previous action (multiple levels) – Undo.
Ctrl + Y: Go to the next action (multiple levels) – Redo.
Work with the Clipboard
Ctrl + C: Copy the contents of the selected cell.
Ctrl + X: Cut the contents of the selected cell.
Ctrl + V: Paste contents from the clipboard into the selected cell.
Ctrl + Alt + V: If data exists in the clipboard: Displays the Paste Special dialog box.
Shortcut keys to edit cells inside
F2: Edit the selected cell with the cursor placed at the end of the line.
Alt + Enter: Down a new line in the same cell.
Enter: Complete enter a cell and move down to the bottom cell.
Shift + Enter: Complete one cell and move it to the top cell.
Tab / Shift + Tab : Complete enter a cell and move to the right / left cell.
Esc: Remove the edit in a cell.
Backspace: Clear the left character of the text cursor, or delete the selection.
Delete: Delete the character to the right of the text cursor, or delete the selection.
Ctrl + Delete: Delete the text to the end of the line.
Ctrl + Shift +: (colon) : Insert the current time.
Edit the active or selected cells
Ctrl + D: Copy the content in the box above.
Ctrl + R : Copy left cell.
Ctrl + “: Copy the text above and in the edit state.
Ctrl + ‘: Copy cell formula above and in edit state.
Ctrl + – : Displays the menu for clearing cells / rows / columns.
Ctrl + Shift + + : Show menu insert cells / rows / columns.
Shift + F2 : Insert / Edit a comment box.
Shift + F10, then M: Delete comment.
Alt + F1: Create and insert a chart with data in the current range.
F11: Creates and inserts charts with data in the current range in a separate chart sheet.
Ctrl + K: Insert a link.
Enter (in a cell containing the link): Activate the link.
Hide and Show Elements
Ctrl + 9 : Hide selected row.
Ctrl + Shift + 9: Unhide the hidden row in the selection containing that row.
Ctrl + 0 (number 0) : Hide the selected column.
Ctrl + Shift + 0 (number 0) : Unhide the hidden column in the selection.
Note: In Excel 2010 does not work, to show the hidden column, press: Ctrl + Z.
Alt + Shift + Right arrow : Row or column heading.
Alt + Shift + left arrow : Remove rows or columns.
Keyboard shortcuts Excel 2007, 2010, 2016
Ctrl + 1: Display the Format dialog box.
Ctrl + B (or Ctrl + 2) : Apply or deselect bold format.
Ctrl + I (or Ctrl + 3) : Apply or deselect the italic format.
Ctrl + U (or Ctrl + 4 ): Apply or cancel an underscore.
Ctrl + 5: Apply or cancel the dash format.
Alt + ‘ : Displays the Style dialog box.
Ctrl + Shift + $ : Apply currency format with two decimal places.
Ctrl + Shift + ~ : Apply the number format of General.
Ctrl + Shift + # : Apply date format style: date, month and year.
Ctrl + Shift + @: Apply the time format to hours and minutes and specify AM or PM.
Ctrl + Shift + ^ : Apply scientific number format with two decimal places.
F4: Repeat the final format selection.
Alt + H, A, R: Right cell.
Alt + H, A, C: Centered cells.
Alt + H, A, I: Left cell aligned.
= : Start a formula.
Shift + F3: Display the Insert Function dialog box.
Ctrl + A: Displays the input method after entering the name of the formula.
Ctrl + Shift + A: Insert arguments in the formula after entering the name of the formula.
Shift + F3: Insert a function into a formula.
Ctrl + Shift + Enter: Enter the formula as an array formula.
F9: Calculates all tables in all spreadsheets.
Shift + F9: Calculate the active worksheet.
Ctrl + Shift + U: Turns the formula bar on or off.
Ctrl + ‘: Switch to display formula in a cell instead of value.
Ctrl + PageDown and Ctrl + PagrUp : move between sheets together.
Ctrl + arrow keys: Move to the top, bottom, left, and right edges of the worksheet. This shortcut will help us not have to use the mouse to drag the slider to find the bottom of the table, especially the long table. When using the Ctrl key with any arrow keys in the direction you want to move, you will quickly get to the location to find.
Ctrl + arrow keys + Shift: Select the data area to the bottom of the table instead of just moving the selection to the bottom of the table.
Left-click in the cell: copy the formula to the bottom of the table. The normal operation to copy down the rows below when + appears, hold and drag to the bottom of the table. However, faster, you place your mouse on the plus sign, double-click on the left mouse button and the formula will be copied to the bottom.
Ctrl + Shift + 1 (!) : Decimal cell number format with two digits after the comma.
Ctrl + Shift + 4 ($) : $ currency format.
Ctrl + Shift + 5 (%) : the cell format is%.
F4: turns a cell into an absolute value. When copying the formula from different cell positions such as B1, C2, … will automatically change when the copy to the bottom line becomes B2, C3. In order not to let the formula jump like this, use the $ key before and after the cell character to lock it. And quickly lock a cell can use F4.
&: combine two cell contents. Jump to the third column and type the formula = cell 1 & “” & cell 2, where the “” to create a space between the two cells after transplant. Then copy the formula to the bottom of the table will appear columns of mixed content from columns 1 and 2.
Alt + =: Quickly sum a column. Highlight the area you want to calculate and add an empty box below then press Alt + =, the last cell value is the sum of the cells in the selection.
Ctrl + Shift +; (semicolon): Fill in the current time with the cell in the spreadsheet.
Ctrl +; (semicolon) : Enter the current date in the cell.
Ctrl + ~ (edge 1) : view all cells in formulas.
Here is the summary of the shortcuts in Excel 2007, 2010, 2016 to help you work more efficiently with Excel worksheet. With this set of shortcuts, you will shorten the time to complete the work, a simple operation is gentle, not tired when the mouse click too much. You also become more professional when using keyboard shortcuts in Excel.