| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy an absolute column and relative row to the right?
I have 75 items in 1 column. The values for the 10 rows to the right are the
same column but different rows each 1 higher than the last. For instance, C10, C11, C12, C13, etc... I want to keep C as a constant but have the numbers increase. Even when I mare the column as a constant and the row as an absolute $C10 it won't update. It still say $C10 when I copy it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
| Relative column referencing within formulas | Excel Discussion (Misc queries) | |||
| Maintain Relative Reference After Inserting a Column | Excel Worksheet Functions | |||
| Recording macros with relative row and column relationships | Excel Discussion (Misc queries) | |||
| Automatically making formulas "Absolute" or "$ Relative" | Excel Discussion (Misc queries) | |||
Threaded Mode
