how do i copy a formula when cell references r not together

G

Guest

in cell reference H5 i have a formula H4*H3, I have copied this formula
through to DG5. In cell reference H7 I have a formula H6*H3 which i have also
copied through to DG7.I have formulas right down to cell reference H299
(H298*H3) Is there a quick way to repeat the copy bearing in mind the cell
references are not together ie H5, H7, H9 and so on.
 
B

Bernie Deitrick

Jon,

Copy cells H6:H7, then select H6:H299 and pastespecial formulas. Just make sure your formula is

=H6*$H$3

HTH,
Bernie
MS Excel MVP
 

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

how do i stop sort from modifing formulas in excel 1
Hyperlink cell references 2
Multiple VBA script 4
inserting data from a row to a cell, when the row number is specified by a formula in a cell 2
Array index, match problem 27
Cell References 1
Showing Last value in a cell 9
How do I write a formula with absolute cell references 3

Top