| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do you copy the same cell reference on different worksheets
Hi,
On one of my workbooks (Excel Windows XP Pro), I have information on separate worksheets (sheet 1, sheet 2, sheet 3, etc). On my last sheet, I would like to reference the same cell (ex. A1) on each of the previous sheets. Rather than clicking on each sheet to reference (ie. =sheet1!a1, =sheet2,!a1), is there a way to click and drag so the cell stays the same (A1) but the sheets change? Let me know. Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
| sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
