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 kommentar(er)
