LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default fill column with formula

I want to fill an entire column with the formula in C2, instead of using the
cell drag function. However, when I select FillDown, the entire column is
filled with the header in C1 instead of the formula in C2 - so I end up with
a column filled with Text, instead of the formula dragged down =A2-B2 =A3-B3
etc.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill Formula Not Adjusting Down the Column lost in excel Excel Discussion (Misc queries) 2 July 5th 07 08:05 PM
Fill a column with the contents of another column based on a choic Sparky56 Excel Discussion (Misc queries) 1 March 31st 07 04:18 AM
Fill a column with a formula kevcar40 Excel Discussion (Misc queries) 1 March 14th 07 12:55 PM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill ers Charts and Charting in Excel 0 March 1st 06 01:05 AM
How do I quickly fill a formula result into a column of cells? ckirch Excel Worksheet Functions 1 September 12th 05 04:40 PM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"