Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert $ to make address absolute
You can place the $ sign where you wish in a formula as you type it.
Alternatively, whilst your cursor is on A1 for example, if you press the F4 function button, Excel will make the entry $A$1. Subsequent pressing of F4 will cycle the address through A$1, $A1 and back to A1 again -- Regards Roger Govier "Tenacity" wrote in message ... Is there a function or macro which will automatically take an existing function, say, SUM(A1..B99) and make it SUM($A1..B99) or SUM(A$1..$B99), etc.? How can you isolate on the one part of the address you want to add the $ to? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make excel insert links | Excel Discussion (Misc queries) | |||
Make default insert sheet to have grid lines | New Users to Excel | |||
Challenging Charting | Charts and Charting in Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) | |||
How do I make and print 3x5 address cards? | Excel Discussion (Misc queries) |