AutoSum is a feature in Excel that quickly allows you to sum the range of data that is located just above the active cell. Many of you know that I am one of those people who dislike clicking the mouse and am always looking for an equivalent keyboard shortcut for the many tasks I perform on the computer. So I was quite happy when I discovered a quick way to sum data in Excel using a simple keyboard combination – Alt and the equal (=) symbol (Alt + =).
To Sum a Range of Data using a Keyboard Combination:
- Click in the cell directly below the range of data you want to sum.
- Hold down the Alt key and then press the Equal (=) key on your keyboard.
- Press Enter to confirm the formula.
Similar Posts:
- None Found
