| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Linear Mode
