HomeApplicationOffice informationSummary keyboard shortcuts in Excel

Summary keyboard shortcuts in Excel

Summing is one of the many calculations available in Excel and it will serve a great deal in statistical accounting. Sometimes you need to work with a lot of calculations so using keyboard shortcuts will save a lot of working time. Therefore, today TipsMake.com will show you how to use keyboard shortcuts to quickly sum in Excel.

Summary keyboard shortcuts in Excel Picture 1

Normally when we need to sum a cluster, you need to use the SUM function. The formula for the SUM function is: = SUM (the elements to be summed)

As an example of the image below, to calculate the sum of all the numbers in the above column, you need to have the formula = SUM (A1: A5) , whereby the result received will be the sum of the lying numbers. in the array from A1 to A5.

Summary keyboard shortcuts in Excel Picture 2

But a faster method is to use the keyboard shortcut to be able to create quick calculations that are Alt and + . When you want to calculate the total of an array of numbers along a column, you just need to select the data cell immediately below that array of numbers.

Summary keyboard shortcuts in Excel Picture 3

Thus, Excel will automatically fill the SUM function in the current position of your choice on the Excel file and the element of the function will be identified as the seamless number array above.

Summary keyboard shortcuts in Excel Picture 4

If the array of numbers is exactly the array containing the elements you need to sum then you just need to press Enter to confirm.

Then the sum of the array will be calculated at the selected data cell.

Summary keyboard shortcuts in Excel Picture 5

Thank you for reading our article TipsMake about how to use keyboard shortcuts to sum in Excel. Hopefully this tip will be useful for your knowledge, wish you a successful implementation.

5 ★ | 1 Vote

You should read it

May be interested

  • How to install and use Unikey for new usersPhoto of How to install and use Unikey for new users
    how to install and use unikey for new users. unikey is a famous vietnamese percussion with millions of installs on computers. with the advantages of compact, stable operation, unikey is an indispensable vietnamese typing tool on our pc.
  • How to convert numbers to dates in ExcelPhoto of How to convert numbers to dates in Excel
    converting digital data into dates in excel is a pretty useful trick for people who use this software. sometimes your date data cells are converted into digital data cells, then if you do not know how to turn it back into a date, please refer to the following tutorial tips of tipsmake.com .
  • How to delete Watermark, delete stamps in Word documentsPhoto of How to delete Watermark, delete stamps in Word documents
    how to delete watermark, delete stamps in word documents. watermark is stamped in the document to copyright the document. but if you do not want that watermark in your document, tipsmake.com can show you how to delete that watermark.
  • How to round up sums in ExcelPhoto of How to round up sums in Excel
    how to round up sums in excel. in fact, very often accounting work requires rounding the money. when you use an automatic calculation formula, it doesn't always produce whole numbers. however, according to monetary rules: for example, dong, the amount will be whole numbers without fractional parts.
  • How to list conditional lists in ExcelPhoto of How to list conditional lists in Excel
    how to list conditional lists in excel. the lookup function is available in excel so that users can search by conditions but return only the first true value. if you need to list all the conditions and copy it to a different data sheet or another sheet ...
  • How to use CONSOLIDATE to statistic, combine data in ExcelPhoto of How to use CONSOLIDATE to statistic, combine data in Excel
    consolidate is one of excel's useful data statistics tools. consolidate allows you to quickly perform sum, average, maximum value, minimum value ... how to use consolidate to statistic and pool data in excel

Office information