- Image and text skills
Today I will introduce some tips for quick summing of WPS table 1s:
■ First, the simplest summation
Select the empty row below the table where the summation formula is set, and press "Alt + =" to sum with one click.
■ Second, set the summation formula across rows
"Ctrl+A" selects the entire table, then "Ctrl + G" locates the empty value, and then presses "Alt + =" for quick calculation in 1s and.
■ Third, summation when there are empty cells in the table
If there are empty cells in the data, an error will occur if you directly use the above method to sum.
You can hold down the Ctrl key and select each summing area, then press "Alt+=", and you're done!
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/yi-fen-zhong-zhang-wo-qiu-he-ji-qiao.html
评论列表(196条)
测试