ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I repeat an item in multiple formulas w/out retyping each (https://www.excelbanter.com/excel-worksheet-functions/91543-how-do-i-repeat-item-multiple-formulas-w-out-retyping-each.html)

Felicity

How do I repeat an item in multiple formulas w/out retyping each
 
Several formulas across a row in each cell with the same base item. Is it
possible to auto fill item without having to type it over and over again to
add it to the formulas?

lk

How do I repeat an item in multiple formulas w/out retyping each
 
Have you tried to use the "$"? $A$1 is an absolute reference to cell A1, but
you can also use $A1 and A$1 which can be copied across rows/columns. The
trick to using $A1 and A$1 is to "lock" the row/column that doesn't change
with the $. You can type the $ or press the F4 key. If you keep pressing
F4, excel will scroll through your options.

"Felicity" wrote:

Several formulas across a row in each cell with the same base item. Is it
possible to auto fill item without having to type it over and over again to
add it to the formulas?



All times are GMT +1. The time now is 03:09 PM.

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