View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SimonCC SimonCC is offline
external usenet poster
 
Posts: 79
Default Filling a formula in entire column

Copy the cell with the formula
Click the column header to select the entire column
Go to Edit | Paste Special, select Formulas radio button and OK

-Simon

"dzuy" wrote:

Is there any way to fill (pattern) a formula in every cell in a column
(without the use of a macro)?

Thanks.