Headers in Excel

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

Can you tell me if it's possible and if so, how I can
change the header cells, i.e. A B C D E ... etc?

Thanks.

Andrea
(508) 842-3880
 
Hi Andrea
no this is not possible. The best workaround you can achieve is:
- use row 1 as header
- goto cell A2 and to the menu 'Windows - Freeze Panes' to always show
row 1
- in 'Tools - Options - view' you can hide the row and column headers
 
Can you tell me if it's possible and if so, how I can
change the header cells, i.e. A B C D E ... etc?

If you'd rather use numbers, try:
Tools >> Options >> General
and check "R1C1 reference style."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top