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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get range names to Apply across multiple tabs 1
need formula to apply to entire column not just one line 2
Apply formula to entire column 2
How can I remove a formula from an entire column? 2
CF Row after CF applied to Column 4
Copying conditional formatting to an entire column in Excel 2007 3
Create One Formula for Entire Column 1
Create Generic Formula for Entire Column 1

Back
Top