| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting to Absolute Cell References - en bloc
I have several similar worksheets with cross-referenced cells.
When I set the original up, I just used normal cell references, eg. Data!AF109, Data!AF110, etc. It would be a great convenience for me if I could re-define all these references as absolute, so that I can copy them into a different part of the worksheet. They would then become Data!$AF$109, Data!$AF$110, etc. Is there a way I can do this without re-typing all the formulae? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
| Cell references change when entering new data | New Users to Excel | |||
Threaded Mode
