| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.
When writing a formula such as =B2-B1 and filling right the formula changes
to B3-B2 and I want B3-B1 then for the next cell B4-B1 etc. How can you lock one cell in a formula and the other. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.
Hi John of Eltham,
Use the dollar sign $. Put the dollar sign before the 1. Have a sunny day! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.
=B2-$B$1 and then copy/paste
€œJohn of Eltham€ç¼–写： When writing a formula such as =B2-B1 and filling right the formula changes to B3-B2 and I want B3-B1 then for the next cell B4-B1 etc. How can you lock one cell in a formula and the other. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
