Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formula to apply to entire column not just one line | Excel Worksheet Functions | |||
How to apply a function to an entire column | Excel Worksheet Functions | |||
How to apply the same formula to an entire column | New Users to Excel | |||
How do I apply formula to entire column | Excel Discussion (Misc queries) | |||
I want to apply a formula to an entire column. | Excel Discussion (Misc queries) |