Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) | |||
multiple item entries from drop-down list | Excel Discussion (Misc queries) | |||
PivotTable toolbar, Formulas, Calculated Item | Excel Discussion (Misc queries) | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
Multiple formulas including INDIRECT | Excel Worksheet Functions |