formula in column

H

Homer J

New Member
Joined
Sep 20, 2003
Messages
23
Hello,
Is ther a way I can get a formula to run all down a column? At the moment I just drag the handle in the corner of the cell down - is there an easier way to put the formula down through the whole column ?
Thanks
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Write the formula into the top cell. Do Edit->Copy. Select the whole column by clicking on the column name. Do Edit->Paste.

Regards,
Chris
 
Upvote 0
If you have data in the adjacent column, you can double click the handle and it will fill down.

If not, higlight the column and on your edit menu select "Fill / Down"
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Power Query - Column that Concatenates a column and a text version of a date.
Replies
2
Views
79
jaihawk8
J
J
  • Question
Fill a row without overwriting existing cell data
Replies
0
Views
56
jmichalski81
J
J
  • Question
LARGE function within an index Match (No duplicates)
Replies
7
Views
148
Fluff
Fluff
H
  • Question
An idea on handling serial numbers?
Replies
5
Views
61
Micron
M
O
  • Solved
transferring columns to rows
Replies
5
Views
259
BigBeachBananas
B

Forum statistics

Threads
1,214,615
Messages
6,120,538
Members
448,970
Latest member
kennimack

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top