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

M

mscarolina

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

Jacob Skaria

Copy formula cell>Select column>Right click>Paste Special>Select
Formulas>Click OK
 
Y

YESHWANT JOSHI

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
 
M

mscarolina

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 remove a bracket that is itallicised for an entire document 1
New computer, how do i move outlook 365 ENTIRELY? 0
Wrapping and Anchors 0
How do I link a cell in a workbook? 1
Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Consolidation Table from Different Excel Tabs with Different Format 1

Top