| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill column with formula
Probably you selected the entire C column. Instead select range C2:C65536
then choose FillDown! Simple way of selecting range C2:C65536 : EditJump(Ctrl+G)/Reference:C2:C65536 Regards, Stefi €˛Margo€¯ ezt Ć*rta: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill column with formula
One way:
Copy cell C2 (CTRL-c). Select column C. Paste (Ctrl-v) In article , Margo wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill column with formula
Copy C2. Go to C3, hold SHIFT while pressing END then down arrow. If
you already have data in the column, you may need to do this twice. Once the last row highlighted is 65535, paste. On Oct 31, 7:44 am, Margo wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Formula Not Adjusting Down the Column | Excel Discussion (Misc queries) | |||
| Fill a column with the contents of another column based on a choic | Excel Discussion (Misc queries) | |||
| Fill a column with a formula | Excel Discussion (Misc queries) | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| How do I quickly fill a formula result into a column of cells? | Excel Worksheet Functions | |||
Linear Mode
