# Use the shortcut Alt+= to quickly sum

Uploaded time: October 8, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

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.

Trending Tutorials

Does this video help you?