![]() |
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? |
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