| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying a formula down 20K rows
I have a rather large spread sheet and would like to copy formulas from one
row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
If there are entries immediately to the left (or the right) of the column
where the formulas are to do, then all you need do is double click the fill handle best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "lizhere" wrote in message ... I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
One way:
With your formula already entered in A1, Right click in A1 and choose "Copy", Click in A2, Click in the Name Box (left of formula bar) Type in a20000 Hold down <Shift Hit <Enter Release <Shift Hit <Enter again, You're done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "lizhere" wrote in message ... I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
If no adjacent columns of data use this method.
In the namebox type A1:A20000 and ENTER Then CTRL + D to copy down. Gord Dibben MS Excel MVP On Mon, 18 Feb 2008 08:43:05 -0800, lizhere wrote: I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
I couldn't get the double click to work, but this one did! Thanks so much
"RagDyeR" wrote: One way: With your formula already entered in A1, Right click in A1 and choose "Copy", Click in A2, Click in the Name Box (left of formula bar) Type in a20000 Hold down <Shift Hit <Enter Release <Shift Hit <Enter again, You're done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "lizhere" wrote in message ... I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
use this method if the formula is in A1 correct?
"Gord Dibben" wrote: If no adjacent columns of data use this method. In the namebox type A1:A20000 and ENTER Then CTRL + D to copy down. Gord Dibben MS Excel MVP On Mon, 18 Feb 2008 08:43:05 -0800, lizhere wrote: I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
Yes
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "lizhere" wrote in message ... use this method if the formula is in A1 correct? "Gord Dibben" wrote: If no adjacent columns of data use this method. In the namebox type A1:A20000 and ENTER Then CTRL + D to copy down. Gord Dibben MS Excel MVP On Mon, 18 Feb 2008 08:43:05 -0800, lizhere wrote: I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
Thank you!
"Bernard Liengme" wrote: Yes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "lizhere" wrote in message ... use this method if the formula is in A1 correct? "Gord Dibben" wrote: If no adjacent columns of data use this method. In the namebox type A1:A20000 and ENTER Then CTRL + D to copy down. Gord Dibben MS Excel MVP On Mon, 18 Feb 2008 08:43:05 -0800, lizhere wrote: I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying a formula down 20K rows
Double-click won't work unless there is contiguous data in an adjacent column.
Gord On Mon, 18 Feb 2008 09:14:02 -0800, lizhere wrote: I couldn't get the double click to work, but this one did! Thanks so much "RagDyeR" wrote: One way: With your formula already entered in A1, Right click in A1 and choose "Copy", Click in A2, Click in the Name Box (left of formula bar) Type in a20000 Hold down <Shift Hit <Enter Release <Shift Hit <Enter again, You're done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "lizhere" wrote in message ... I have a rather large spread sheet and would like to copy formulas from one row to the next. It seems like there should be an easier way of copying to 20K rows than grabbing the fill handle and moving down that long. I tried reviewing some of the tips in "programing" but I have no idea how or where to type those directions (macros???I hope not). Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying formula without scrolling 9000 rows | Excel Worksheet Functions | |||
| Copying a formula that contains a range of cell rows | Excel Discussion (Misc queries) | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
| Same formula in each cell of column; insert rows w/o copying down | Excel Discussion (Misc queries) | |||
Linear Mode
