View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default How to set up easy lookup methods

Just to add to Eddie's comments, its called Absolute Reference. In B1 type
in =A1 and before you hit enter, hit F4 four times slowly and your formula
will toggle through all the absolute references possibilities.

HTH
Regards,
Howard

"ET" wrote in message
...
Sorry, having trouble understanding $A etc