Linking multiple formulas

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.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

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 protected] 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.

No excuse for your laziness!

1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
2. In the menu bar, go to Format - Cells
3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
4. Deselect the small box tagged Locked
5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
7. In the menu bar, go to Format - Cells
8. In the popup menu that opens, click on the Protection tab
9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
10. Click on OK
11. In the menu bar, go to Tools - Protection - Protect Sheet
12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

Here is the syntax: =SUMIF(Sheet2!A1:A3,"> 1", Sheet2!B1:B3)

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.

1. Select the cells with the formulas you want to disable.
2. You can now either hide the formula by pressing CTRL and ` at the same time, or you can delete the formula by pressing the delet key on your keyboard.

Here's an easy way to select multiple formulas:

1. Do one of the following:
   • Select the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) that includes the type of cells you want to select.
   • Click any cell to select all cells of this type on the active worksheet.
     
2. On the Edit menu, click Go To.
3. Click Special.
4. Click Formulas, and then select the check box next to the type of data you want to select.

eg if i want to add to numbers
in sheet 1 i have the value 20 in cell B3
in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

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

1. Click the cell in which you want to enter the formula.
2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) , type = (equal sign).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

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.

Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

You can follow this process:

1. Select a cell that contains the external formula
2. Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
3. Push Ctrl+C then push Enter.
4. Select the range of cells you wish to change the reference in and go to Edit>Replace.
5. Select in the Find what box and hold down the Backspace to ensure you do not have a space.
6. Push Ctrl+V.
7. Do the same in the Replace with box and then edit the file path to the new one needed.
8. Click Replace All

if that has helped you please press 'fixya'