Top Bar
 

How can I change the top bar to display numbers rather then letters?

Hi Beany
This isn't possible !
However, you can put your letters in the top row of the worksheet and then
hide the column headers by going to tools/options/view and uncheck row and
column headers.
You can then put your cursor anywhere in the second row and select
Window/Freeze Panes to keep your new column headers in view all the time.

HTH
Michael

"beany" wrote:

How can I change the top bar to display numbers rather then letters?

Yes You can!!!! ToolsoptionsGeneralSelect 'R1C1 Reference Style"

Mike R.

"Michael" wrote:

Hi Beany
This isn't possible !
However, you can put your letters in the top row of the worksheet and then
hide the column headers by going to tools/options/view and uncheck row and
column headers.
You can then put your cursor anywhere in the second row and select
Window/Freeze Panes to keep your new column headers in view all the time.

HTH
Michael

"beany" wrote:

How can I change the top bar to display numbers rather then letters?

Thanks Mike
You are, of course correct........that's my second one today, so back to the
bottle

Michael

"beany" wrote:

How can I change the top bar to display numbers rather then letters?

Two!!! If I only had two!!! Learned these little things right here thanks
to people like you, and all others that invest in this forum!!!

Mike R.

"Michael" wrote:

Thanks Mike
You are, of course correct........that's my second one today, so back to the
bottle

Michael

"beany" wrote:

How can I change the top bar to display numbers rather then letters?