Thread
:
=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.
View Single Post
#
2
Posted to microsoft.public.excel.misc
BigPig
Posts: n/a
=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!
Reply With Quote
=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.