For all guru's. Can this be done?

  • Thread starter Thread starter michael.beckinsale
  • Start date Start date
M

michael.beckinsale

Hi all,

Using the Options menu it is possible to turn on / turn off Row &
Column headers but is it possible to turn off Column headers leaving
Row numbers visible?

I assume that if this is possible it must be done using VBA

All help greatly appreciated


Regards

Michael Beckinsale
 
Michael,

Cannot be done, row and column headers are either on or off, not mixed.

I would suggest that what you want is row numbering, so my suggestion would
be to turn off row and column headers and then make column A look like row
numbering with numbers and formatting. Not ideal but cosmetically the same.

EA
 
Hi guys,

Thanks for the prompt response.

I feared that might be the answer but if it could be done then this is
the place to find out how!

Regards

Michael Beckinsale
 
You must log in or register to reply here.

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

Similar Threads

I think this is difficult - can it be done? 3
Can this be done? 3
Any ideas on how to do this? 7
Can you turn off the Full Screen toolbar? 3
Can this be done? 2
All MVP's & regular contributors 3
Find Specific Rows in Range and Create New Tab 18
Automatically add Conditional formatting on data/subtotals 12

Back
Top