copy formula

F

funny girl

how do I copy a formula to a range of cells below without using the drag
method. I'm wanting to do this by entering the range of cells to copy to.
 
S

Shane Devenshire

Sorry, I'm not clear on this one.

Generally Ctrl+C, Ctrl+V does it.

Or the toolbar equivalents. Or the Edit menu commands. Or the right mouse
button commands.
 
M

Max

Copy the top cell's formula, eg copy A2
Enter the range in the namebox, eg: A3:A100,
press ENTER to select the range
Right-click on the range > Paste

Alternatively,
select the entire range via the namebox, viz: A2:A100
Enter the top cell's formula (that for A2) into the formula bar
Press CTRL+ENTER to fill the entire range

success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Lost functionality to copy a formula across rows 1
Fill Options & Formula Help 2
Excel formula to copy/paste formula needed please. 4
copy formulas over merged cells 2
Copying and Pasting VLOOKUP/HLOOKUP Formulas 2
Excel - Want to sort by formula value without losing formula 4
Link to range of cells, so formulas are retained 3

Top