Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to copy values in various rows automatically
I have a worksheet function for a cell.
Now I would like to copy this function for all the rows in this column. How can it be done? Like copy A1 to A2 thru' A900 Thank you, -Me |
#2
|
|||
|
|||
Me,
Select A1. Drag the Fill Handle (lower right corner button) down. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Me" wrote in message ... I have a worksheet function for a cell. Now I would like to copy this function for all the rows in this column. How can it be done? Like copy A1 to A2 thru' A900 Thank you, -Me |
#3
|
|||
|
|||
Earl,
Thank you very much, it works! -Me "Earl Kiosterud" wrote: Me, Select A1. Drag the Fill Handle (lower right corner button) down. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Me" wrote in message ... I have a worksheet function for a cell. Now I would like to copy this function for all the rows in this column. How can it be done? Like copy A1 to A2 thru' A900 Thank you, -Me |
#4
|
|||
|
|||
Me
Select A1 then in Name Box to the left of the Formula Bar type in A1:A900 and hit ENTER key. Type your formula in A1 and hit CTRL + ENTER. If formula is already entered in A1, hit F2 then CTRL + ENTER after selecting the range. Gord Dibben Excel MVP On Fri, 4 Mar 2005 14:25:01 -0800, "Me" wrote: I have a worksheet function for a cell. Now I would like to copy this function for all the rows in this column. How can it be done? Like copy A1 to A2 thru' A900 Thank you, -Me |
#5
|
|||
|
|||
Gord,
Thank you, this helps! -Me "Gord Dibben" wrote: Me Select A1 then in Name Box to the left of the Formula Bar type in A1:A900 and hit ENTER key. Type your formula in A1 and hit CTRL + ENTER. If formula is already entered in A1, hit F2 then CTRL + ENTER after selecting the range. Gord Dibben Excel MVP On Fri, 4 Mar 2005 14:25:01 -0800, "Me" wrote: I have a worksheet function for a cell. Now I would like to copy this function for all the rows in this column. How can it be done? Like copy A1 to A2 thru' A900 Thank you, -Me |
#6
|
|||
|
|||
Earl,
Thanks a lot, this is what I was looking for! -Me "Earl Kiosterud" wrote: Me, Select A1. Drag the Fill Handle (lower right corner button) down. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Me" wrote in message ... I have a worksheet function for a cell. Now I would like to copy this function for all the rows in this column. How can it be done? Like copy A1 to A2 thru' A900 Thank you, -Me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
copy / paste selective rows | Excel Discussion (Misc queries) | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
copy qualifying rows to another spreadsheet | Excel Worksheet Functions | |||
Identifying exact values in alternate rows | Excel Worksheet Functions |