Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Top Bar
How can I change the top bar to display numbers rather then letters?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|