ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to repeat the upper row formula without entry formula? (https://www.excelbanter.com/excel-discussion-misc-queries/196461-how-repeat-upper-row-formula-without-entry-formula.html)

LPCHUA ^_^

how to repeat the upper row formula without entry formula?
 
Anyone know that kind of function? Please help .....

JLatham

how to repeat the upper row formula without entry formula?
 
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


"LPCHUA ^_^" wrote:

Anyone know that kind of function? Please help .....



All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com