View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nabanco nabanco is offline
external usenet poster
 
Posts: 59
Default Automatic Fill of a Formula

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