how do I add cells on different worksheets in excell

  • Thread starter Thread starter reidser
  • Start date Start date
R

reidser

Having trouble adding same cell on different worksheets can anyone help
 
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)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
how do I select every third cell in a row in excel? 8
How to lock cell and worksheet? 3
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Code to format cells on several worksheets 2

Back
Top