a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US. click here to Talk to a Technician (only for users in the US for now) and get all the help you need. Goodluck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.
You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.
you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet
pen both the sheets in the same window as:-
1. View Tab-->New Window --> Arrange All --> tiled
2. Open first sheet in first window and second in second window
3. now create formula simply by clicking in corresponding sheets and selecting cells.
Alternatively you can use following format of addressing:-
1. SheetName!CellAddress (Same Workbook)
2. [WorkbookName]SheetName!CellAddress (Different Workbooks)
For more clarification please mail on email@example.com with screenshots.
I'd say you need to pay better attention to the Excel or other spreadsheet books and help you have handy, and categorize your problem according to the behavior you get inconsistent with the suggested solutions already available.
You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.
Refers to the worksheet named Marketing
Refers to the range of cells between C1 and C10, inclusively
Click the cell in which you want to enter the formula.
Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.