View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default What is the key shortcut for absolute cell reference?

F4 !!
Regards,
Alan.
"RM in Augusta" <RM in wrote in message
...
When selecting a cell to enter into a formula, there is a key or key
combination that will automatically make the cell an absolute cell
reference
when you point-and-click. You can also highlight the cell reference in
the
formula and use the shortcut to make it an absolute cell reference. This
saves typing the "$" sign. Help! I can't remember it.