copy formula down column without having to drag the corner

[jennyrabbit]

I am working with a file that has 55,000 rows. I often have to insert a column and then write a formula based on the values in the other columns. The only way I know how to copy the formula down the column is to drag the corner of the cell all the way down. I thought there was a way to do this by using ctrl shift end or something like that, but I don't remember how. Thanks.

 

[Corni]

Re: copy formula down column without having to drag the corn

After selecting all range in the column, write the formula in the first cell on the top, and then Ctrl + Enter.

 

[Gonzalita]

Re: copy formula down column without having to drag the corn

Other way is write the formula in the first cell, then select that cell and put the cursor in the right down corner of the cell and double click....

 

[hkaplan]

Re: copy formula down column without having to drag the corn

Type the formula. Then copy to the clipboard. Then press shift ctrl end. Then hit enter.

 

[Legacy 12630]

Re: copy formula down column without having to drag the corn

Another way:-

Copy the cell
Go to Edit>GoTo, type the destination range ref in the reference box, clickOK
Paste