Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell Reference
When creating a formula in a cell, and using another cell as part of that
formula, is there a way to select a cell to automatically place the $ in front of the column and row identifiers... looking for a way not to have to type in the "$" every time... Example I enter the "=" sign in a cell... I want the results of another cell to be part of the formula in the original cell I typed the "=" sign... =$b$11 .... Am I forced to type in the "$" signs EVERY time? -- Somecallmejosh |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell Reference
By the way, I am using Office 2K...
-- Somecallmejosh "Joshua K Briley" wrote: When creating a formula in a cell, and using another cell as part of that formula, is there a way to select a cell to automatically place the $ in front of the column and row identifiers... looking for a way not to have to type in the "$" every time... Example I enter the "=" sign in a cell... I want the results of another cell to be part of the formula in the original cell I typed the "=" sign... =$b$11 .... Am I forced to type in the "$" signs EVERY time? -- Somecallmejosh |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell Reference
In reality yes. You can toggle it after entering it using F4, but that is
not much different in practice. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Joshua K Briley" wrote in message ... By the way, I am using Office 2K... -- Somecallmejosh "Joshua K Briley" wrote: When creating a formula in a cell, and using another cell as part of that formula, is there a way to select a cell to automatically place the $ in front of the column and row identifiers... looking for a way not to have to type in the "$" every time... Example I enter the "=" sign in a cell... I want the results of another cell to be part of the formula in the original cell I typed the "=" sign... =$b$11 .... Am I forced to type in the "$" signs EVERY time? -- Somecallmejosh |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell Reference
Thanks Bob...
-- Somecallmejosh "Bob Phillips" wrote: In reality yes. You can toggle it after entering it using F4, but that is not much different in practice. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Joshua K Briley" wrote in message ... By the way, I am using Office 2K... -- Somecallmejosh "Joshua K Briley" wrote: When creating a formula in a cell, and using another cell as part of that formula, is there a way to select a cell to automatically place the $ in front of the column and row identifiers... looking for a way not to have to type in the "$" every time... Example I enter the "=" sign in a cell... I want the results of another cell to be part of the formula in the original cell I typed the "=" sign... =$b$11 .... Am I forced to type in the "$" signs EVERY time? -- Somecallmejosh |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell Reference
If there are certain cells that you use a lot in your formulas it might be easier to DEFINE them (give each a name), say A1 refers to the price of a product, select A1 and type a name in the name box (left of the formula bar) say "price" then use that name in your formula: Ex. =SUM(A1:A10)*price HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=496190 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell Reference
The cells are not static.... the ones I have to copy are peppered throughout
the worksheet. Thanks for your response. -- Somecallmejosh "pinmaster" wrote: If there are certain cells that you use a lot in your formulas it might be easier to DEFINE them (give each a name), say A1 refers to the price of a product, select A1 and type a name in the name box (left of the formula bar) say "price" then use that name in your formula: Ex. =SUM(A1:A10)*price HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=496190 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Cell Refences | Excel Worksheet Functions | |||
Cell reference problem | Excel Worksheet Functions | |||
how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
Excel should have a absolute reference cell property. | Excel Discussion (Misc queries) |