| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW CAN I PROTECT A FORMULA IN EXCEL
I have 2 questions. I have a formula in a cell and want to copy it to an
adjacent cell without the formula changing based on the cell location. Ex: In A1 I have the formula =M1+T1, when I copy this to B1 it changes the formula to N1+U1, if I copy it to A2 it changes it to M2+T2. How can I copy the cell without changing the formula ? My second question is I have a cell with the formula =D1. When I drag or cut another cell into D1 it changes the formula to =#REF!. Is there a way to maintain the original formula of =D1 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Threaded Mode
