![]() ![]() Press Shift+F8 to highlight the second cell.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. ![]() 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: 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |