Manipulating Row and Column Headers

  • Thread starter Thread starter google
  • Start date Start date
G

google

Hello,

in the following I am talking about those row and column headers that
show A, B, C,... for columns and 1,2,3,... for rows.

Is it possible to manipulate these headers in for eaxample give them
other names than A,B,C, ... and omitting those bars between two
columns A and B? The header should look like

A | B C D | E | F | cat | G | H | dog | ...

Would that be possible?

Thanks a lot in advance,
best regards,
Markus
 
Nope.

You could hide the row and column headers (tools|options|view tab) and use row
one to hold anything you want.

I'd leave the headers and just put the data in row 1. And if you freeze the
window so that row 1 is always visible, it'll look "normal" to most excel users.
 
Hi Markus -

I don't know how this could be done directly nor have I seen it done.
Others may have a solution though.

As an alternative, you could emulate by turning off the Row&Column Headers
and using the first row and column by merging cells as necessary. Setting
the color to match the color of Excel's worksheet frame would come very close
to your goal (|Format|Cells|Patterns Tab).

To turn off the Row&Column Headers, choose |Tools|Options|View Tab and
uncheck the "Row & column headers" option.
 
Back
Top