ExcelBanter - Fill formulas into adjacent cells does not take formula only data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Fill formulas into adjacent cells does not take formula only data (https://www.excelbanter.com/excel-worksheet-functions/107428-fill-formulas-into-adjacent-cells-does-not-take-formula-only-data.html)

gnshort

Fill formulas into adjacent cells does not take formula only data

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.

Gord Dibben

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.

All times are GMT +1. The time now is 05:52 AM.