title: Copy paste formulas verbatim
body: <p>Say I have a row of 100 cells, each with some formula.</p>
  
  <p>I want to copy them and paste them somewhere else, but with the formulas <em>verbatim</em> exactly the same, without changing the reference.</p>
  
  <p>Is there a quick way to do this (i.e. <em>without macros, without having to add $ signs to the formulas</em>, etc.)? One might have thought that there is some way to do this through Paste Special, but I don't seem to see any such option.</p>