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
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