View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default In Excel, how do I change the titles of the cells from A,B,C etc?

And then select A1 (to make sure it's visible)
Then select B2
Window|Freeze Panes.

Then your headers will always be visible.

I think most excel users like to see the row and column headings, but you can
turn them off.

In xl2003, it's:
tools|options|view tab|Uncheck Row & Column Headers

In xl2007, it's under the Office button|Excel Options|View (I think) section.



aliceccentric wrote:

In Excel, how do I change the titles of the cells from A, B, C etc and 1, 2,
3 etc? I want to change them to the titles of my rows/columns, which are
words. Can I do this? If so, how?


--

Dave Peterson