| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place Stored Path Into Formulla
you could name your formula, then you could just insert the named
formula in the cells... goto, insert,name,write a name,in the reference box enter your formula then in the cells with the formula, enter =formulaname another quick way would be to highlite the ranges that require the formula, then write the formula, then instead of pressing enter, hit Ctrl Enter then all the cells highlited will have the formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Relative path for XML data file? | Charts and Charting in Excel | |||
| how to change absolute path to relative path | Excel Worksheet Functions | |||
| Link a cell to another workbook with a different path | Excel Worksheet Functions | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Hybrid Mode
