| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I make a row absolute, but column relative, the column stays.
I am trying to copy a formula using the fill option. When i set the column
in the range to relative and the row to absolute, the columns and rows in the range saty the same. I thought that the dollar sign was supposed to allow the range to change in sequential order |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I make a row absolute, but column relative, the column stays.
The contrary: the $ sign hold that item constant
SO dragging cell J1 down the column when it has =$A$1 will produce =$A$1 in all cells. If J1 has =$A1 and you drag it down you get $A2, $a3..... But dragging sideways leaves $A1 in all cells best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "tonefbr" wrote in message ... I am trying to copy a formula using the fill option. When i set the column in the range to relative and the row to absolute, the columns and rows in the range saty the same. I thought that the dollar sign was supposed to allow the range to change in sequential order |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I make a row absolute, but column relative, the column stays.
The $ in front of the row means the row won't adjust.
The $ in front of the column means the column won't adjust. You may want to share the formula (and the cell that it's in). And the range that you're filling. tonefbr wrote: I am trying to copy a formula using the fill option. When i set the column in the range to relative and the row to absolute, the columns and rows in the range saty the same. I thought that the dollar sign was supposed to allow the range to change in sequential order -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I make a row absolute, but column relative, the column st
Many thanks for your help
"Bernard Liengme" wrote: The contrary: the $ sign hold that item constant SO dragging cell J1 down the column when it has =$A$1 will produce =$A$1 in all cells. If J1 has =$A1 and you drag it down you get $A2, $a3..... But dragging sideways leaves $A1 in all cells best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "tonefbr" wrote in message ... I am trying to copy a formula using the fill option. When i set the column in the range to relative and the row to absolute, the columns and rows in the range saty the same. I thought that the dollar sign was supposed to allow the range to change in sequential order |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change a long column of references from relative to absolute | New Users to Excel | |||
| CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
| Excel: Cant copy an relative Cell and make absolute | Excel Discussion (Misc queries) | |||
| Changing relative to absolute for a column | Excel Worksheet Functions | |||
| How do I copy an absolute column and relative row to the right? | Excel Discussion (Misc queries) | |||
Linear Mode
