O'Reilly logo
  • Russell Welsh thinks this is interesting:

=ADDRESS(1,$F$1)&":"&":"ADDRESS(7,$F$1)

From

Cover of Excel Hacks

Note

There is an error in the formula. It should be:

=ADDRESS(1,$F$1)&":"&ADDRESS(7,$F$1)