Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
I know how to use F4 to cycle through reference choices for a single cell.
Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
Hi,
You can do it by find and replace if you have any question give me an example then i explane based on your example. Thanks, -- Farhad Hodjat "PZ" wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
You could use a macro.
Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
Yeah sure......pick the posting with the spelling mistake........."formulaws"
Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
"The" posting? <g
Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
I just knew someone would question "which" posting considering my track record
lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
Hi Gord,
You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
I think you meant:
Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
Yes Dave, but on this side of the "pond", in English, you're is a
shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Regards Roger Govier "Dave Peterson" wrote in message ... I think you meant: Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
Roger, I think your <g missing Dave's attempt at humo(u)r.
Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
Hi Deb
Your<g quite right<g It went flying over my head - put it down to :- a) very late (early) over here b) too many beers at the pub before coming back to the computer c) stupidity!!! No prizes for the correct answer ( yes we use a "z" as well<g) Dave, Apologies, what else can I say? The beer's on me? Collect any time, at the Black Bear, Bettws Newydd<bg -- Regards Roger Govier "Debra Dalgleish" wrote in message ... Roger, I think your <g missing Dave's attempt at humo(u)r. Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
It was a (failed) attempt at humor. I thought correcting, er, changing your
response so that it was incorrect would be funny. But sometimes my humor doesn't translate into English very well. Sorry for jumpling in! (Just to get Gord going!) Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Regards Roger Govier "Dave Peterson" wrote in message ... I think you meant: Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
And I should have scrolled down a bit more. I would have seen that Debra
esplained it all! Roger Govier wrote: Hi Deb Your<g quite right<g It went flying over my head - put it down to :- a) very late (early) over here b) too many beers at the pub before coming back to the computer c) stupidity!!! No prizes for the correct answer ( yes we use a "z" as well<g) Dave, Apologies, what else can I say? The beer's on me? Collect any time, at the Black Bear, Bettws Newydd<bg -- Regards Roger Govier "Debra Dalgleish" wrote in message ... Roger, I think your <g missing Dave's attempt at humo(u)r. Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Dave Peterson |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
No probs Dave.
My fault entirely, nothing wrong with your humo(u)r<g Luckily Debra was wide enough awake to spot my jaded state.. I do enjoy a good laugh and joke adn when tpying, my speeeling often leeves a lot to be desried. -- Regards Roger Govier "Dave Peterson" wrote in message ... It was a (failed) attempt at humor. I thought correcting, er, changing your response so that it was incorrect would be funny. But sometimes my humor doesn't translate into English very well. Sorry for jumpling in! (Just to get Gord going!) Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Regards Roger Govier "Dave Peterson" wrote in message ... I think you meant: Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson -- Dave Peterson |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
I knew that would come back to haunt me.
On Tue, 10 Apr 2007 22:07:34 -0500, Dave Peterson wrote: It was a (failed) attempt at humor. I thought correcting, er, changing your response so that it was incorrect would be funny. But sometimes my humor doesn't translate into English very well. Sorry for jumpling in! (Just to get Gord going!) Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Regards Roger Govier "Dave Peterson" wrote in message ... I think you meant: Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
I'm not sure if you saw a "thank you" post to one of your and DaveF's (IIRC)
suggestions. It was something like: Thank you Dave and God for the help.... I thought it may have been a typo, but maybe not...Have you accepted more responsibility lately?????? Gord Dibben wrote: I knew that would come back to haunt me. On Tue, 10 Apr 2007 22:07:34 -0500, Dave Peterson wrote: It was a (failed) attempt at humor. I thought correcting, er, changing your response so that it was incorrect would be funny. But sometimes my humor doesn't translate into English very well. Sorry for jumpling in! (Just to get Gord going!) Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Regards Roger Govier "Dave Peterson" wrote in message ... I think you meant: Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson -- Dave Peterson |
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Cells from Relative to Absolute Reference
I did see it and it was "Dave and Gods"
I assumed it was directed at DaveF and all the other regulars who use spellchecker. On Wed, 11 Apr 2007 13:19:05 -0500, Dave Peterson wrote: I'm not sure if you saw a "thank you" post to one of your and DaveF's (IIRC) suggestions. It was something like: Thank you Dave and God for the help.... I thought it may have been a typo, but maybe not...Have you accepted more responsibility lately?????? Gord Dibben wrote: I knew that would come back to haunt me. On Tue, 10 Apr 2007 22:07:34 -0500, Dave Peterson wrote: It was a (failed) attempt at humor. I thought correcting, er, changing your response so that it was incorrect would be funny. But sometimes my humor doesn't translate into English very well. Sorry for jumpling in! (Just to get Gord going!) Roger Govier wrote: Yes Dave, but on this side of the "pond", in English, you're is a shortened form of "you are" Your - the possessive form of you - belongs to you. <GD&WVVF -- Regards Roger Govier "Dave Peterson" wrote in message ... I think you meant: Your not alone. <gd&r Roger Govier wrote: Hi Gord, You're not alone<bg -- Regards Roger Govier "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I just knew someone would question "which" posting considering my track record lately. I set myself up for that<g On Tue, 10 Apr 2007 19:38:22 -0400, Debra Dalgleish wrote: "The" posting? <g Gord Dibben wrote: Yeah sure......pick the posting with the spelling mistake........."formulaws" Gord On Tue, 10 Apr 2007 17:12:55 -0500, Dave Peterson wrote: You could use a macro. Gord Dibben shared this: http://groups.google.co.uk/group/mic...60f32287258372 or http://snipurl.com/1g005 PZ wrote: I know how to use F4 to cycle through reference choices for a single cell. Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+ cells. Thanks, in advance Phil -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing formulas from relative to absolute | Excel Discussion (Misc queries) | |||
changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
Changing relative to absolute for a column | Excel Worksheet Functions | |||
changing relative to absolute | Excel Discussion (Misc queries) | |||
changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) |