ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column heading (https://www.excelbanter.com/excel-discussion-misc-queries/33179-column-heading.html)

rml

column heading
 
I recently open a file that had numbers accross the top and down the sides as
column headings and row headings. Usually, their are letters accross the top
of a worksheet. Now, every time a create a new file, it uses numbers
accross the top. How can I change it back to letters.

Thanks.

Earl Kiosterud

Tools - Options - General. Deselect R1C1 reference style.


--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"rml" wrote in message
...
I recently open a file that had numbers accross the top and down the sides
as
column headings and row headings. Usually, their are letters accross the
top
of a worksheet. Now, every time a create a new file, it uses numbers
accross the top. How can I change it back to letters.

Thanks.





All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com