Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Excel worksheets
Is there a way if I make a change on one worksheet it shows on all the others?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Excel worksheets
"Vee" wrote in message
... Is there a way if I make a change on one worksheet it shows on all the others? Your question isn't clear. If you mean that a number changes on Sheet 1 (say in A1) and you want this to affect the results of formulas in other sheets, simply reference this cell in those formulas, including its sheet location, such as =Sheet1!A1 However, if you mean you have many worksheets with identical formulas, and you want to edit a formula in one cell on each of them in the same way, here is what you do. Click the tab of the first sheet you want to edit. Hold down SHIFT and click the tab of the last. This will select all the sheets; their tabs will all go white. Then, edit your formula and it will be edited on all sheets. DO NOT FORGET to deselect the range of sheets (click on another tab, or right click a tab and use Ungroup sheets) as soon as you have finished editing. Until you do this, whatever you do will change all the sheets! Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to link excel worksheets with a reference (indexed) key field. | Excel Worksheet Functions | |||
how do I link to hidden worksheets in excel? | Excel Discussion (Misc queries) | |||
Link worksheets in Excel | Excel Discussion (Misc queries) | |||
How do I link to other worksheets | Excel Worksheet Functions | |||
How to link two different worksheets together in Excel | Excel Worksheet Functions |