Menu
how to make the formula effect on the whole sheet.
the format is : get each lines number sum. then substract some numbers.
eg: there are 100 lines records. how to make the formula effects on each lines?
namely : A1+B1+C1+D1+....equals a number, then using the number-20 -15....
each line using the same way, thank you.
311
Hold the “Ctrl + Shift” key together. First, press the left arrow to select the complete row. Then, by holding the “Ctrl + Shift” keys together, press the “down arrow” to select the whole column. Like this, we can select multiple rows in Excel without much trouble.
The hotkey or shortcut of AutoSum function are Alt + = keys in Excel. Select a list of data in Excel, and then press the Alt + = keys simultaneously, and then it will add the sum value below this list.
You can input a range into =SUM() like this:
=SUM(A1:X1)
This calculates the sum of the 1. line from A to X. Just copy/paste the formula to ther rows to calculate the some for those.
70
Drag the sum down in corner of cell where cursor becomes + sign
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
