#1   Report Post  
Old July 9th 05, 07:07 PM
doggone
 
Posts: n/a
Default Cell addresses

Columns are no longer designated by letters - please help me understand the
new cell references?

  #2   Report Post  
Old July 9th 05, 07:20 PM
VoG via OfficeKB.com
 
Posts: n/a
Default

Tools | Options, General tab. Untick R1C1 Reference Style


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1
  #3   Report Post  
Old July 9th 05, 07:27 PM
garfield-n-odie
 
Posts: n/a
Default

In Excel, click on Tools | Options | General | uncheck the "R1C1 reference
style" box | OK.

"doggone" wrote:

Columns are no longer designated by letters - please help me understand the
new cell references?

  #4   Report Post  
Old July 9th 05, 07:59 PM
doggone
 
Posts: n/a
Default

Duh! Thank you!

"VoG via OfficeKB.com" wrote:

Tools | Options, General tab. Untick R1C1 Reference Style


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

  #5   Report Post  
Old July 9th 05, 07:59 PM
doggone
 
Posts: n/a
Default

Thanks!

"garfield-n-odie" wrote:

In Excel, click on Tools | Options | General | uncheck the "R1C1 reference
style" box | OK.

"doggone" wrote:

Columns are no longer designated by letters - please help me understand the
new cell references?



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
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
How do I have a cell fill in addresses from another file when I t. Cbrat Excel Discussion (Misc queries) 2 April 8th 05 06:07 PM
Problems copying street addresses and dates C. Dales Excel Discussion (Misc queries) 4 February 11th 05 01:43 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017