View Single Post
  #1   Report Post  
photon63
 
Posts: n/a
Default Quick method to add absolute references in Excel using keyboard

It would be useful for absolute references to be added in Excel when holding
a key down on the keyboard, instead of having to re-edit each cell every
time. Say, hold down the mouse button, press 'r' to toggle rows between
absolute and relative, and the same for 'c' and columns.