Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formula down
*There has to be an easier way to do this*. I am copying a formula i make in the first cell down to like cell 35000 in that same column. How can i do this quickly w/o clicking on the cell after the formula and dragging down for like 2 minutes to cell 35000? -- iculookn2 ------------------------------------------------------------------------ iculookn2's Profile: http://www.excelforum.com/member.php...o&userid=33783 View this thread: http://www.excelforum.com/showthread...hreadid=535523 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formula down
Click on the cell with the formula (say A1) and COPY Then, in the name box, put A2:A35000 and press enter. Then Paste (CTRL/V) This should fill the selection with your formula. -- iculookn2 Wrote: *There has to be an easier way to do this*. I am copying a formula i make in the first cell down to like cell 35000 in that same column. How can i do this quickly w/o clicking on the cell after the formula and dragging down for like 2 minutes to cell 35000? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=535523 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formula down
Copy the formula, select the entire column by clicking on top of the column, and then do a paste or paste special & select formula. Hope this helps. "iculookn2" wrote: *There has to be an easier way to do this*. I am copying a formula i make in the first cell down to like cell 35000 in that same column. How can i do this quickly w/o clicking on the cell after the formula and dragging down for like 2 minutes to cell 35000? -- iculookn2 ------------------------------------------------------------------------ iculookn2's Profile: http://www.excelforum.com/member.php...o&userid=33783 View this thread: http://www.excelforum.com/showthread...hreadid=535523 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formula down
Here's a keyboard shortcut you can take advantage of: practice a bit
first. Hold down the SHIFT key and press END and the down arrow. This will highlight the range from your starting point to the first non-blank cell. So: go to row like 35001 and type an X or your initials or some other thing. Then go to the first formula cell and press CTRL-C (to copy it into the clipboard); go to the first cell you want to copy it to, then hold SHIFT and press END DOWN to highlight the entire range. Press CTRL-V to paste into that range. Another alternative is to hide rows 2 ~ 34,999, and then do the the click and drag thing. Altho the rows are hidden, the formula is still pasted in. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formula down
thanks for all your help! the keyboard shortcut rocks dave o. -- iculookn2 ------------------------------------------------------------------------ iculookn2's Profile: http://www.excelforum.com/member.php...o&userid=33783 View this thread: http://www.excelforum.com/showthread...hreadid=535523 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formula down
One more to try. Assuming you do want all the rows to have the formula.
Click on the cell with the formula, put cursor over the bottom right corner to display the fill handle (crosshair), double click left mouse button. this should fill all the rows in the column with the fomula. HTH Mark "iculookn2" wrote: thanks for all your help! the keyboard shortcut rocks dave o. -- iculookn2 ------------------------------------------------------------------------ iculookn2's Profile: http://www.excelforum.com/member.php...o&userid=33783 View this thread: http://www.excelforum.com/showthread...hreadid=535523 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
Returned: Copying a formula horizontally, the source data is verti | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I prevent a formula element from incrementing when copying | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |