=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.

G

Guest

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.
 
G

Guest

Hi John of Eltham,

Use the dollar sign $.

Put the dollar sign before the 1.

Have a sunny day!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"$" command will not work in VISTA 4
Skip Reference Sequences during copy 3
Formulas - Daily average at the specific date 3
excel "IF" formula... if this possible ??? 0
Copying cell formulas 1
Excel 2002: How to add without splitting blocks ? 3
Excel In Excel how can I block the contenent of a cell? 0
How to display a value in say B2 in B3 IF a value in B1 is true 11

Top