How do I apply a cell formula to an entire column?
 

I have been through what I thought to be a few different solutions but to no
avail.

How do I apply a cell formula to an entire column?
 

Copy formula cellSelect columnRight clickPaste SpecialSelect
FormulasClick OK
--
If this post helps click Yes
---------------
Jacob Skaria


"mscarolina" wrote:

I have been through what I thought to be a few different solutions but to no
avail.

How do I apply a cell formula to an entire column?
 

hi mscarolina, i m not sure what u want to do. however my suggestions are :
1. If u r trying to copy the same formula (not being constant) simply drop
down the cell value or copy and paste the cell and paster over the entire
column.
2. If u r trying to copy the formula with constant reference or formula,
try using $ sign in the formula & copy and paste the cell and paster over the
entire column.

for any further assistance, give the full details of the case

"mscarolina" wrote:

I have been through what I thought to be a few different solutions but to no
avail.

How do I apply a cell formula to an entire column?
 

Perfect! I knew it was supposed to be fairly easy. Thank you.

"Jacob Skaria" wrote:

Copy formula cellSelect columnRight clickPaste SpecialSelect
FormulasClick OK
--
If this post helps click Yes
---------------
Jacob Skaria


"mscarolina" wrote:

I have been through what I thought to be a few different solutions but to no
avail.

How do I apply a cell formula to an entire column?
 

The first reply did it. Thank you.

"YESHWANT JOSHI" wrote:

hi mscarolina, i m not sure what u want to do. however my suggestions are :
1. If u r trying to copy the same formula (not being constant) simply drop
down the cell value or copy and paste the cell and paster over the entire
column.
2. If u r trying to copy the formula with constant reference or formula,
try using $ sign in the formula & copy and paste the cell and paster over the
entire column.

for any further assistance, give the full details of the case

"mscarolina" wrote:

I have been through what I thought to be a few different solutions but to no
avail.

How do I apply a cell formula to an entire column?
 

good to receive feedback ........... tks

"mscarolina" wrote:

The first reply did it. Thank you.

"YESHWANT JOSHI" wrote:

hi mscarolina, i m not sure what u want to do. however my suggestions are :
1. If u r trying to copy the same formula (not being constant) simply drop
down the cell value or copy and paste the cell and paster over the entire
column.
2. If u r trying to copy the formula with constant reference or formula,
try using $ sign in the formula & copy and paste the cell and paster over the
entire column.

for any further assistance, give the full details of the case

"mscarolina" wrote:

I have been through what I thought to be a few different solutions but to no
avail.