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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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
90
jaihawk8
J
J
  • Question
Fill a row without overwriting existing cell data
Replies
0
Views
64
jmichalski81
J
J
  • Question
LARGE function within an index Match (No duplicates)
Replies
7
Views
153
Fluff
Fluff
H
  • Question
An idea on handling serial numbers?
Replies
5
Views
66
Micron
M
O
  • Solved
transferring columns to rows
Replies
5
Views
263
BigBeachBananas
B

Forum statistics

Threads
1,214,832
Messages
6,121,850
Members
449,051
Latest member
excelquestion515

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