Sorry if this is obvious, but I don't have much experience with Excel. I have several years of data spread out over several sheets (a sheet for 2000, 2001, etc.). I want to add another sheet with graphs charting the trends in this data over time, but I can't figure out how to select data from one cell in multiple sheets. It seems like there should be an easy way to select cell C1 of every sheet, but I don't see it.
Excel Help
- Thread starter MBulldog
- Start date
I don't know of a short way to link multiple pages, but if you just want to link 1 cell from say, sheet1 to a summary sheet, go to the summary sheet, type "=" then click back to sheet one, highlight the cell you want, and hit enter. If you want the summary sheet to add multiple cells from different sheets, type "=sum" and then hold Ctrl while selecting the cells from multiple sheets.
Normally when entering an equation, it assumes you're talking about the same sheet. to specify which sheet, you enter "sheetname"!"cell"
So, for example:
=SUM(Sheet1!B31, Sheet2!A10)
would add the contents of sheet 1, cell B31, and Sheet 2, Cell A10
So, for example:
=SUM(Sheet1!B31, Sheet2!A10)
would add the contents of sheet 1, cell B31, and Sheet 2, Cell A10
you can select the same cell in multiple by clicking on the first sheet tab and then hold down the shift key and clicking the last sheet tab. You can then format or whatever you want on one sheet and it will effect all those selected
For formulas you can do something like this
=SUM(Sheet1:Sheet4!A1) - this sums cell A1 from sheet1 THROUGH sheet4. If you move sheet3 to the right of sheet4 it would no longer be included in the SUM
Where sheet1 is the sheet name. So if you renamed it you would use that name. If the sheet name has spaces in it, you would need to enclose the sheet name in single quotes.
OR
If the sheets are continous you can do what I've said above:
=sum( (in the cell where you want the result)
click on the first sheet tab
hold shift key down and click on last sheet tab
click on the cell(s) you want to add (or whatever)
closing ) hit enter
Whala
For formulas you can do something like this
=SUM(Sheet1:Sheet4!A1) - this sums cell A1 from sheet1 THROUGH sheet4. If you move sheet3 to the right of sheet4 it would no longer be included in the SUM
Where sheet1 is the sheet name. So if you renamed it you would use that name. If the sheet name has spaces in it, you would need to enclose the sheet name in single quotes.
OR
If the sheets are continous you can do what I've said above:
=sum( (in the cell where you want the result)
click on the first sheet tab
hold shift key down and click on last sheet tab
click on the cell(s) you want to add (or whatever)
closing ) hit enter
Whala
Last edited: