ExcelBanter - copy formula into the subsequent cells, not contents

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy formula into the subsequent cells, not contents (https://www.excelbanter.com/excel-discussion-misc-queries/152291-copy-formula-into-subsequent-cells-not-contents.html)

Janis

copy formula into the subsequent cells, not contents

How do you copy just the formula from the first cell into all the subsequent
cells in a column? I know if you double-click the box on the bottom corner
it will copy both the formula and the cell contents to all other cells but I
only want the formula.

tia,

David Biddulph[_2_]

copy formula into the subsequent cells, not contents

Copy
Edit/ Paste Special/ Formulas
--
David Biddulph

"Janis" wrote in message
...
How do you copy just the formula from the first cell into all the
subsequent
cells in a column? I know if you double-click the box on the bottom
corner
it will copy both the formula and the cell contents to all other cells but
I
only want the formula.

tia,

All times are GMT +1. The time now is 03:31 PM.