WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Use the shortcut Alt+= to quickly sum

Uploaded time: October 8, 2021 Difficulty Beginner

Use the shortcut Alt+= to quickly sum

Use the shortcut Alt+= to quickly sum

In tables, we often have to perform summation operations. Using the function to sum and then filling the cells with the fill handle is too troublesome. However, the sum shortcut Alt+= can help us quickly sum.

Take this table as an example. We need to sum the column data of the table, just select the sum range B16:F16, then press the shortcut Alt+= to quickly complete the summation.

Similarly, if we want to sum the row data, we can simply select the range G2:G15 that needs to be summed and press Alt+=.

We can also quickly sum the rows and columns of the table at the same time, select the range B2:G16, press Alt+= to get the results of the calculation.

What an efficient shortcut! Did you get it?To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.