I know that dragging a formula down will automatically change the
rownumber within the formula and dragging the formula to the right
will change the column letter. Is there a way to do vice-versa, i.e.,
drag to the right and change the row number?

ex. C2^2 (value of C2 squared)
drag this down and get C3^2
drag this to the right and get D2^2

......looking for a way to drag to the right and go from C2^2 to C3^2
or drag down and go from C2^2 to D2^2 (just opposite of normal - kind
of like me!)