![excel keyboard shortcuts format excel keyboard shortcuts format](https://excelunlocked.com/wp-content/uploads/2020/08/Ctrl-Keyboard-Shorcuts-1.png)
Select Adjacent and Non-Adjacent Cells in Excel with the Keyboard Follow the steps below if the range you wish to select contains a mixture of adjacent and individual cells as shown in the image above.
![excel keyboard shortcuts format excel keyboard shortcuts format](https://i.pinimg.com/736x/0a/e7/51/0ae751d9ca07b8fe8555ffad387da765.jpg)
Use the arrow keys on the keyboard to move to the next cell you want to highlight.Without moving the cell cursor, press and release the Shift+F8 keys to turn off Extended Selection mode.Press and release the F8 key on the keyboard to start Extended Selection mode.Select Single Non-Adjacent Cells in Excel Using the Keyboard Select the first cell.To turn off Extended Selection mode, press the Shift and F8 keys together. To activate Extended Selection mode, press the F8 key on the keyboard. Use the Keyboard in Extended Mode To select non-adjacent cells with just the keyboard, use the keyboard in Extended Selection mode. This can be done using the keyboard and mouse together or using only the keyboard. When these cells are not located in a contiguous block, it's possible to select non-adjacent cells. Select multiple cells in Excel when you want to delete data, apply formatting such as borders or shading, or apply other options to large areas of a worksheet all at one time. To change the selected range, highlight the correct range before pressing the Enter key to complete the function. If the SUM function is entered into a location other than adjacent to a row or column filled with numbers, the range of cells selected as the function's argument may be incorrect. The answer appears in the summary cell.Press the Enter key to complete the function.The SUM function displays in the summary cell with the range of cells above it highlighted as the SUM function's argument.Press and release the equal sign ( = ) on the keyboard.Press and hold the Alt key on the keyboard.
#Excel keyboard shortcuts format series#
Select the cell under the series you want to sum to make it the active cell.To use this keyboard shortcut in a worksheet: This shortcut sums all of the adjacent cells above the selected cell in the worksheet. The key combination to enter the SUM function is: And if you’re working in a different tab, you don’t want to have to keep switching back to the Home tab just to format the data you’re working on.When you want to sum data in rows as well as columns, use a keyboard shortcut to insert the Excel SUM function into your worksheet. Although the formats are accessible from the Home tab in that version, it could be years, possibly decades, before you develop the habit of locating them quickly. These are standard, practical shortcuts that can save you time in earlier versions of Excel - but they’re especially useful in Excel 2007. (I’ve included them here because someone will surely take me to task if I leave them out.) But the rest of these shortcuts are less well known, even though you might actually need to apply, say, the Currency format to data more often than Underline or Italic.
#Excel keyboard shortcuts format pdf#
Ī comprehensive list of Excel shortcuts is available as a PDF download.īy now, most Office users probably know the Bold, Italic, and Underline shortcuts as well as they know their own names. (I’ve included them here because someone will surely take me to task if I leave them out.) But the rest of these. By now, most Office users probably know the Bold, Italic, and Underline shortcuts as well as they know their own names.
![excel keyboard shortcuts format excel keyboard shortcuts format](https://cdn.educba.com/academy/wp-content/uploads/2019/01/paste-shortcut-in-excel-feature-image.png)
10+ keyboard shortcuts to speed formatting in Excel worksheetsĪ comprehensive list of Excel shortcuts is available as a PDF download.