how to repeat the upper row formula without entry formula?

J

JLatham

Could you put the actual complete question into the body of the post so that
we can make sure we know what you're looking for?

For a whole row, you can select the source row and use copy and then paste
into a row farther on down the sheet - note that any relative addresses will
change based on how far down the sheet you placed it. Absolute addresses
would not.

To quickly copy a formula exactly from a cell just above another, choose the
empty cell and press [Ctrl]+['] keys at the same time.

You might also search Excel Help for topic
Fill data in worksheet cells
 
Top