| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: changing link formula from absolute to relative
Hi,
I notice that all the formulas link from one work book to another are in form of "absolute" cell refrence. Eg. ='[Budget 2010.xls]jh'!$E$222 This does not serve my need as I need to copy the formulas across the spreasheet. Usually I would remove the $ manually before copying across. May I know if there is a way of changing the formula from absolute to relative, i.e. removing the $ in row only, column only or both automatically? Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing formulas from relative to absolute | Excel Discussion (Misc queries) | |||
| Changing relative to absolute for a column | Excel Worksheet Functions | |||
| changing relative to absolute | Excel Discussion (Misc queries) | |||
| Formula - relative or absolute ref, keeps changing | New Users to Excel | |||
| Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
Threaded Mode
