View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Adding $ to fomulas

Hi,

Place the cursor between C & 3 in the formula bar and tap F4

Mike

"Neil Boycott" wrote:

Is there a way to select a cell with a formula in and use some kind of
keyboard function to a $s around it. I.E.

Original
=cards!c3

After some kind of keyboard function
=cards!$c$3

??