View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Switching view on/off for row & column headers?

ToolsOptionsView. Uncheck "row and column headers"

Or a macro to toggle off/on

Sub Toggle_Headers()
With ActiveWindow
.DisplayHeadings = Not .DisplayHeadings
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 18 Jul 2007 13:08:04 -0700, J@Y wrote:

How do you make the row and column headers( ie: A ~Z and 1~100000) viewable /
not-viewable?