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

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

From

Cover of Excel Hacks
  • Excel Hacks
  • from Excel Hacks
  • by Raina Hawley, David Hawley
  • Publisher: O'Reilly Media, Inc.
  • Released: March 2004

Note

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

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