ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet Borders/Labels (name???) both coming up as numbers (https://www.excelbanter.com/excel-discussion-misc-queries/29821-worksheet-borders-labels-name-both-coming-up-numbers.html)

Kerri Schultz

Worksheet Borders/Labels (name???) both coming up as numbers
 
I have probably an obvious question, but nonetheless, here it goes....One of
our users has an excel worksheet where it shows up as A, B, C,, etc. along
the top and 1, 2, 3, etc. along the left side. When she sends it to someone
else in our office, it is coming up as 1, 2, 3 along the top and sides. Is
this a setting that the second user has? I haven't been able to find a
solution online for it. Help!

Thanks,
Kerri

Dave Peterson

Tools|Options|General Tab
Check R1C1 reference style to see numbered columns.
Uncheck it to see lettered columns.

Kerri Schultz wrote:

I have probably an obvious question, but nonetheless, here it goes....One of
our users has an excel worksheet where it shows up as A, B, C,, etc. along
the top and 1, 2, 3, etc. along the left side. When she sends it to someone
else in our office, it is coming up as 1, 2, 3 along the top and sides. Is
this a setting that the second user has? I haven't been able to find a
solution online for it. Help!

Thanks,
Kerri


--

Dave Peterson

Kerri Schultz

Thanks for your help!

"Dave Peterson" wrote:

Tools|Options|General Tab
Check R1C1 reference style to see numbered columns.
Uncheck it to see lettered columns.

Kerri Schultz wrote:

I have probably an obvious question, but nonetheless, here it goes....One of
our users has an excel worksheet where it shows up as A, B, C,, etc. along
the top and 1, 2, 3, etc. along the left side. When she sends it to someone
else in our office, it is coming up as 1, 2, 3 along the top and sides. Is
this a setting that the second user has? I haven't been able to find a
solution online for it. Help!

Thanks,
Kerri


--

Dave Peterson



All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com