Thread: Fill formulas into adjacent cells does not take formula only data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Fill formulas into adjacent cells does not take formula only data
ToolsOptionsCalculation.

Make sure you are set the "Automatic".


Gord Dibben MS Excel MVP

On Mon, 28 Aug 2006 14:50:01 -0700, gnshort
wrote:

When using the autofill function to copy a formula down a column, only the
data is being copied so when you click onn on of the filled cells the formula
is correct but the data is a copy of the first cell only.

Reply With QuoteReply With Quote