| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to automatically put the $ sign into the formula?
I want to turn this =A1 into =$A$1.
How is the best way of doing this. Is there a shortcut....keyboard stroke to do this?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to automatically put the $ sign into the formula?
Hit [F4] several times and watch the results.
Micky "hrb_2001" wrote: I want to turn this =A1 into =$A$1. How is the best way of doing this. Is there a shortcut....keyboard stroke to do this?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to automatically put the $ sign into the formula?
Hi,
Enter =A1 then tap F4 Repeated taps of F4 scroll through the referencing options -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) "hrb_2001" wrote: I want to turn this =A1 into =$A$1. How is the best way of doing this. Is there a shortcut....keyboard stroke to do this?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to automatically put the $ sign into the formula?
use F4
"hrb_2001" wrote: I want to turn this =A1 into =$A$1. How is the best way of doing this. Is there a shortcut....keyboard stroke to do this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why put a plus sign after = sign in a formula | Excel Worksheet Functions | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| In 2003 Excel I can't get the = sign to automatically come up. | Excel Discussion (Misc queries) | |||
| Can excel automatically place a negetive sign in a number | Excel Discussion (Misc queries) | |||
| Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) | |||
Linear Mode
