linking formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Formulas

Linking Formulas

resolvedResolved · Low Priority · Version 2003

Ben has attended:
Excel Intermediate course

Linking Formulas

Are there anyother was to link formulas?

RE: Linking Formulas

Hiya Ben

Hope you are well, the two ways that we did in the class, where by clicking the places in the file or files that are open, that look like the example below

=b4+sheet2!h5,[test.xls]sheet3!d5

and the other type was by using the dollar signs in the formulaand then moving the cell or cells to a different location

these are the only ways i know to do linking formulas


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

RE: Linking Formulas

Hi Ben, just to add a little bit to Mark's answer; perhaps a variation on the theme:
You will need two workbooks to create a link. Call the first one Source. The second workbook we can call Dependent. It is now time to create a link between the workbooks; Have both workbooks open.
In the Source Workbook: select a cell; this is the cell you want to refer to. You want to insert this value into your Dependant workbook.
Click the Copy button or choose Copy from the Edit menu. A moving border (marching ants) should appear around the cell.
Switch to the Dependant workbook. This is the workbook where you want to paste the linked data.
Select a cell; This is the cell in which you want the linked data to appear. Choose Paste Special from the Edit menu. The Paste Special dialog box should appear:
Choose All in the Paste box and None in the Operation box.
Choose the Paste Link button to paste the link into the cell.
Observe the cell; Excel has created an external reference formula that links the workbooks. This formula appears in the formula bar. You have successfully linked two documents. Best regards Pete


 

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips


Server loaded in 0.09 secs.