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

  • Thread starter Thread starter mscarolina
  • Start date Start date
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
 
The first reply did it. Thank you.

YESHWANT JOSHI said:
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
 
Back
Top