| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute referencing
I want to change all references to cells on work sheet 1, to absolute cell
references? Is there any way I can change every cell reference in every formula in every cell in one go, or do I have to edit every single cell. Example of sheet data:- =IF(ISNA(BP$74),"VB","") to equal =IF(ISNA($BP$74,"VB","") etc. (A$3,BP$3:BP$13,1,FALSE) to equal ($A$3,$BP$3:$BP$13,1,FALSE) I'm using Office 97!! Thanks Keith |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statements referencing an absolute value or a range of values | Excel Worksheet Functions | |||
| excel chart - absolute referencing????! | Charts and Charting in Excel | |||
| Relative vs Absolute referencing of Workbooks | Excel Worksheet Functions | |||
| Relative vs Absolute referencing of Workbooks | Charts and Charting in Excel | |||
| Creating a formula using absolute referencing - I think!! | Excel Worksheet Functions | |||
Threaded Mode
