Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I change the cell dispay in Excel 2007 from C1:R2 to A2


--
Managing Director
Alliance Best Practice Ltd
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default How do I change the cell dispay in Excel 2007 from C1:R2 to A2

Office button/Excel options/Formulas/ 2nd section has "R1C1 reference style"
turn it on/off here

"Mike Nevin" wrote:


--
Managing Director
Alliance Best Practice Ltd

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
*.csv format change if .xlt save as .csv in Excel 2007 Khayae Excel Discussion (Misc queries) 1 December 14th 07 12:54 PM
Change Box Line Weight - Excel 2007 RAH[_2_] Excel Discussion (Misc queries) 2 July 14th 07 12:46 AM
Dispay two values in one cell with the / border separating them. pshofstetter Excel Worksheet Functions 2 June 7th 07 06:12 PM
Excel 2007: numbers randomly change SJ Excel Discussion (Misc queries) 3 May 20th 07 12:35 AM
Excel 2007 change data source Bart Excel Discussion (Misc queries) 1 October 4th 06 11:19 AM


All times are GMT +1. The time now is 12:20 AM.

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

About Us

"It's about Microsoft Excel"