Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "copy-down" a formula in a Very LONG Column?
Excel 2007...
I put a formula in cell C1. I want to copy it down to the end of the column, but the column has 140,00 records. It takes Several minutes to scroll manually. Is there a faster way to do it? Thanks, in advance. Mark246 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "copy-down" a formula in a Very LONG Column?
Select the range first
type c1:c1400000 into the name box type the formula for C1 (the activecell) but hit ctrl-enter to fill the selection with the formula. Mark246 wrote: Excel 2007... I put a formula in cell C1. I want to copy it down to the end of the column, but the column has 140,00 records. It takes Several minutes to scroll manually. Is there a faster way to do it? Thanks, in advance. Mark246 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "copy-down" a formula in a Very LONG Column?
Hello,
This is probably a hack way of doing it, but you can just copy that first cell, then click on the column letter (B for example) and paste it to the whole column. Now, it'll go past your 14,000 lines, so there's probably a better way of doing it :) "Mark246" wrote: Excel 2007... I put a formula in cell C1. I want to copy it down to the end of the column, but the column has 140,00 records. It takes Several minutes to scroll manually. Is there a faster way to do it? Thanks, in advance. Mark246 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "copy-down" a formula in a Very LONG Column?
With C1 highlighted, put your mouse pointer on the fill box (the small box
on the bottom right corner), and double click. Neat, eh? Regards, Fred. "Mark246" wrote in message ... Excel 2007... I put a formula in cell C1. I want to copy it down to the end of the column, but the column has 140,00 records. It takes Several minutes to scroll manually. Is there a faster way to do it? Thanks, in advance. Mark246 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "copy-down" a formula in a Very LONG Column?
D-click only works if you have data in an adjacent column that runs down to
C14000. I would just enter the formula in C1 then in the namebox type C1:C14000 and ENTER. Then CTRL + D to fill down to C14000. Gord Dibben MS Excel MVP On Mon, 25 Feb 2008 13:33:43 -0600, "Fred Smith" wrote: With C1 highlighted, put your mouse pointer on the fill box (the small box on the bottom right corner), and double click. Neat, eh? Regards, Fred. "Mark246" wrote in message ... Excel 2007... I put a formula in cell C1. I want to copy it down to the end of the column, but the column has 140,00 records. It takes Several minutes to scroll manually. Is there a faster way to do it? Thanks, in advance. Mark246 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy--paste--special "formula" for a whole column | Excel Discussion (Misc queries) | |||
While using find and replace i am getting "formula too long" | Excel Discussion (Misc queries) | |||
"formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) | |||
"Formula too long" when changing linked sources?? | Excel Discussion (Misc queries) | |||
Error message "formula is too long" | Excel Discussion (Misc queries) |