Thread: [Solved] excel absolute reference
View Single Post
 
Old 06-16-2015, 03:18 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
OK, the help file doesn't deal with pressing F4 while the formula bar is active. When I press F4 with the formula bar active, the referencing for a cell reference adjacent to the insertion point alternates between A1, $A$1, A$1 and $A1 referencing.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote