ExcelBanter - Cell addresses

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell addresses (https://www.excelbanter.com/excel-discussion-misc-queries/34570-cell-addresses.html)

doggone

Cell addresses

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

VoG via OfficeKB.com

Tools | Options, General tab. Untick R1C1 Reference Style

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

garfield-n-odie

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?

doggone

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

doggone

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?

All times are GMT +1. The time now is 08:04 AM.