| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping the column constant in a formula
I am trying to drag a formula in a row while keeping the source column
constant and incrementing the column number... A B C 1 1.1 2 2.2 3 3.3 4 4.4 5 6 =A1 =A2 =A3..... I know how to use the $ to keep the row from changing, but how do you keep the comlumn constant? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiplying a column of data by a constant | Excel Discussion (Misc queries) | |||
| Keeping cell references constant | Excel Discussion (Misc queries) | |||
| keeping a shape constant regardless of changes in variables | Excel Discussion (Misc queries) | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Right Filling A Formula Whilst Keeping A Static Column | Excel Discussion (Misc queries) | |||
![Arithmetic functions with embedded text[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
