Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOw do I change group of cells from absolute reference?
When I do a Paste SpecialPaste Link, the cell looks something like ='MAIN'!$A$3. This is great, its just what I want. Now I remove the $ beofre the 3 and drag the cells so my list is linked correctly, like: ='MAIN'!$A3, ='MAIN'!$A4, ='MAIN'!$A5, and so on. If I don't remove the $, it just stays as $A$3 for every item. Here's my question. Is there and easy way to convert the cells back to being locked with the $ in place again like: ='MAIN'!$A$3, ='MAIN'!$A$4, ='MAIN'!$A$5, and so on? Sometimes the list is long and its a pain putting those $ back again. I seem to remember some kind of toggle that would turn absolute ref on and off. I guess that my question. Is there some way usinf the keyboard to turn a cell into absolute referencing and back again? Thanks. -- bre ------------------------------------------------------------------------ bre's Profile: http://www.excelforum.com/member.php...o&userid=20765 View this thread: http://www.excelforum.com/showthread...hreadid=470485 |
#2
|
|||
|
|||
Highlighting the address in the formula bar, then hitting F4 will toggle between
all the absolute/relative possibilities. $a$1 $a1 a$1 a1 bre wrote: When I do a Paste SpecialPaste Link, the cell looks something like ='MAIN'!$A$3. This is great, its just what I want. Now I remove the $ beofre the 3 and drag the cells so my list is linked correctly, like: ='MAIN'!$A3, ='MAIN'!$A4, ='MAIN'!$A5, and so on. If I don't remove the $, it just stays as $A$3 for every item. Here's my question. Is there and easy way to convert the cells back to being locked with the $ in place again like: ='MAIN'!$A$3, ='MAIN'!$A$4, ='MAIN'!$A$5, and so on? Sometimes the list is long and its a pain putting those $ back again. I seem to remember some kind of toggle that would turn absolute ref on and off. I guess that my question. Is there some way usinf the keyboard to turn a cell into absolute referencing and back again? Thanks. -- bre ------------------------------------------------------------------------ bre's Profile: http://www.excelforum.com/member.php...o&userid=20765 View this thread: http://www.excelforum.com/showthread...hreadid=470485 -- Dave Peterson |
#3
|
|||
|
|||
THanks. Guess that's where I saw the toggle thing. Is there a way to do a range of cells? -- bre ------------------------------------------------------------------------ bre's Profile: http://www.excelforum.com/member.php...o&userid=20765 View this thread: http://www.excelforum.com/showthread...hreadid=470485 |
#4
|
|||
|
|||
You could have a macro do it.
Gord Dibben recently posted this: http://groups.google.co.uk/group/mic...c824e9ba8ce2f7 or http://snipurl.com/hx8y If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm bre wrote: THanks. Guess that's where I saw the toggle thing. Is there a way to do a range of cells? -- bre ------------------------------------------------------------------------ bre's Profile: http://www.excelforum.com/member.php...o&userid=20765 View this thread: http://www.excelforum.com/showthread...hreadid=470485 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
% change in the last two cells in a row | Excel Worksheet Functions | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
define group of cells | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |