Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Row and Column Headers
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Row and Column Headers
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. wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Row and Column Headers
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. -- Jay " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
Manipulating a column array into different cell locations | Excel Discussion (Misc queries) | |||
Hide Column Headers but not row (Headers) | Excel Programming | |||
Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
Loop through column headers to search from column name and get cell range | Excel Programming |