CHANGING COLUMN NAME

[Dsuperc]

Just for what its worth. Is it possible to remane the columns from "A" "B" "C" etc. to something else?

 

[Jim North]

You can change it to 1 2 3 4 ...

by changing the reference style in your options. Is this what you are looking for?

 

[Joe Was]

Turn off "Headers" then in row 1 col's A, make it a lable (any content you want), do this for as many columns as you need. You now have custom column headers. If you want to use this for all your default workbooks save it as a project.

Build a macro to hide and un-hide row 1, with a hot key, like: Ctrl+h. Now you can turn On and Off your custom header, by hitting: Ctrl+h.

Note: You can format the font and cells of that header row, with more options than you can with the real header's. Just remember, Excel will only reference your row-columns as R1C1 or A1 styles in formulas and code. JSW

 

[Dsuperc]

Thanks.

 

[Dsuperc]

This solves half of my problem. The other half is, how could I get the column name on every page. Do I have to use the Custom header feature?

 

[Joe Was]

Record a macro: First wile recording,
Hide the "Headers" (Tools-Options-View, un-check "Row & Column headers"), then
add your new header names.
Stop the recorder.
Edit the macro: remove hard-coded sheet names and replace with "ActiveSheet" now when you run your macro what ever sheet is active will get your new headers. JSW