If you have trouble with your formula as posted, perhaps use a real cell
reference rather than just "B"

Maybe B1 or B2


Gord Dibben MS Excel MVP


On Fri, 22 Jun 2007 10:03:01 -0700, nabanco
wrote:

Thank you!

"Gary''s Student" wrote:

Usually people just select a cell, enter the formula, and touch ENTER.

Select a column (or part of a column) type the formula and touch CNTRL-ENTER
--
Gary''s Student - gsnu200732


"nabanco" wrote:

Hello,

is there a way to have a formula automatically fill through the entire column?

For example, if column F was [=today()-B], how would I get the sheet to
always recognize that formula for that column and carry it all the way down
the sheet indefinetely?

Thanks for your help