how do I add cells on different worksheets in excell

T

T. Valko

If the sheets you want to include are in a contiguous group:

=SUM(Sheet1:Sheet5!A1)

If the sheets are random:

=SUM(Sheet1!A1,Sheet5!A1,Sheet7!A1)
 
F

Farhad

I am not really sure what exactly do you mean but if you mean that you want
to add a column or a row in the same place in several sheets you should
active the place that you want to add row or column in the first sheet and
then press Ctrl and hold it and click on the other sheets that you want to
add and then go to menu: Insert>rows or columns.

Hope this works for you otherwise you gotto give more explanation.
 
Top