Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 99
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I chang



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I chang

Hi Wendy
GotoToolsOptionsGeneraluncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on the
subject title.
"Wendy" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 99
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I c

thanks, never had to ask a question before...we just upgraded to 2007, where
is the tools option???


"John" wrote:

Hi Wendy
GotoToolsOptionsGeneraluncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on the
subject title.
"Wendy" wrote in message
...




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I c

Hi Again
try this : Office Button | Excel Options | Add-Ins
Not sure
HTH
John
"Wendy" wrote in message
...
thanks, never had to ask a question before...we just upgraded to 2007, where
is the tools option???


"John" wrote:

Hi Wendy
GotoToolsOptionsGeneraluncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on the
subject title.
"Wendy" wrote in message
...





  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 161
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I c

The biggest icon in upper left corner (Office button) - Options of Excel
appliation (bottom section of the window) - Formulas (left panel) - Work
with formulas (middle section of right panel) - Reference style (all is my
translation, I am not native english speaker neither my Excel :-) )

"Wendy" wrote:

thanks, never had to ask a question before...we just upgraded to 2007, where
is the tools option???


"John" wrote:

Hi Wendy
GotoToolsOptionsGeneraluncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on the
subject title.
"Wendy" wrote in message
...






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I c

Office | Excel Options (at bottom of window) | Formulas (at left side panel)
| "working with Formulas " (second group down) | uncheck "R1C1 reference
style" (first item)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Wendy" wrote in message
...
thanks, never had to ask a question before...we just upgraded to 2007,
where
is the tools option???


"John" wrote:

Hi Wendy
GotoToolsOptionsGeneraluncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on
the
subject title.
"Wendy" wrote in message
...






  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I c

Hi Wendy
If you are just starting with XL07 and accustom to the old menu.
You can download the Interactive Command Guide at
http://www.microsoft.com/downloads/d...displaylang=en
Also a Ribbon Mapping Workbook at
http://office.microsoft.com/en-us/te...128621033.aspx

HTH
John

"Wendy" wrote in message
...
thanks, never had to ask a question before...we just upgraded to 2007, where
is the tools option???


"John" wrote:

Hi Wendy
GotoToolsOptionsGeneraluncheck R1C1 reference style.
HTH
John
P.S. You should write your message in this big white space not only on the
subject title.
"Wendy" wrote in message
...





  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default columns and rows labeled the same (cell 1-1 vs a-1) how do I chang

hi
toolsoptionsgeneral tabuncheci R1C1 reference

Regards
FSt1

"Wendy" wrote:



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns labeled with numbers not letters plumeria54 Excel Worksheet Functions 9 April 22nd 10 01:40 PM
Columns are labeled as numbers in the grid!! Dinosaur Pete Excel Discussion (Misc queries) 2 September 30th 08 07:41 PM
I have columns labeled as numbers instead alpha why? Ajay Chadha Excel Discussion (Misc queries) 2 September 26th 08 07:04 PM
Columns Labeled Wendy Excel Discussion (Misc queries) 1 April 18th 07 12:41 AM
Columns in Excel labeled numbers rather than letters? zrossing Excel Discussion (Misc queries) 2 October 19th 06 06:13 PM


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"