Results 1 to 4 of 4

Thread: Excel Help

  1. #1
    Recruit
    Join Date
    Dec 2009
    Location
    Johnston
    Posts
    89
    Thumbs Up
    Received: 0
    Given: 0

    Excel Help

    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.



  2. #2
    Addict
    Points: 120,414, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 12.0%
    Achievements:
    SocialVeteran50000 Experience Points
    ianoconnor's Avatar
    Join Date
    Nov 2007
    Location
    Des Moines
    Posts
    7,114
    Points
    120,414
    Level
    100
    Thumbs Up
    Received: 258
    Given: 541

    Re: Excel Help

    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.



  3. #3
    Speechless
    Points: 404,747, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 3.0%
    Achievements:
    SocialVeteran50000 Experience Points
    alarson's Avatar
    Join Date
    Mar 2006
    Location
    West Des Moines, IA
    Posts
    21,069
    Points
    404,747
    Level
    100
    Thumbs Up
    Received: 252
    Given: 107

    Re: Excel Help

    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



  4. #4
    Starter
    Points: 20,348, Level: 43
    Level completed: 56%, Points required for next Level: 402
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points
    RoseClone's Avatar
    Join Date
    Oct 2006
    Location
    Rose Capital of Iowa
    Posts
    937
    Points
    20,348
    Level
    43
    Thumbs Up
    Received: 3
    Given: 14

    Re: Excel Help

    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


    Last edited by RoseClone; 01-14-2010 at 12:45 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM