| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
columns
How can I add columns without moving formulas. I need to have formulas stay
in column a,b,c, When I add column formula goes to b,c,d, it needs to stay where is is. Thanks for any help Casey |
|
#2
|
|||
|
|||
|
Add a column after c? -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=466290 |
|
#3
|
|||
|
|||
|
the vallues in the columns have to move but not the formula
"Morrigan" wrote: Add a column after c? -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=466290 |
|
#4
|
|||
|
|||
|
use indirect() - see help.
=INDIRECT("B1")/INDIRECT("A1") "Casey" wrote: the vallues in the columns have to move but not the formula "Morrigan" wrote: Add a column after c? -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=466290 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| can't insert columns between columns | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Linear Mode
