How to change numbered columns to letters?
My Excel spread sheets used to have letters across the top adn numbers down
the left side. Now there are numbers both across the top and down the left side. How can I get back to the lettered columns? |
How to change numbered columns to letters?
Tools Options General clear the R1C1 reference checkbox.
-- Gary''s Student - gsnu200818 |
How to change numbered columns to letters?
With XL2003 or earlier, click on Tools | Options | General tab,
unclick R1C1 reference style, then click OK. Hope this helps. Pete On Dec 6, 12:17*am, anwillia wrote: My Excel spread sheets used to have letters across the top adn numbers down the left side. *Now there are numbers both across the top and down the left side. *How can I get back to the lettered columns? |
How to change numbered columns to letters?
Perfect -- thanks for such a quick and concise reply.
"Gary''s Student" wrote: Tools Options General clear the R1C1 reference checkbox. -- Gary''s Student - gsnu200818 |
All times are GMT +1. The time now is 02:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com