ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Column Labels (https://www.excelbanter.com/setting-up-configuration-excel/260000-column-labels.html)

Jennifer H

Column Labels
 
Hi - Currently my column labels are numbers not letters. I can not for the
life of me figure out how to change them to letters. I would like the rows
to be numbers and the columns to be labels.

Help


trip_to_tokyo[_3_]

Column Labels
 
In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas

- make sure that there is no tick in the box called:-

R1C1 reference style

If my comments have helped please hit Yes.

Thanks.



"Jennifer H" wrote:

Hi - Currently my column labels are numbers not letters. I can not for the
life of me figure out how to change them to letters. I would like the rows
to be numbers and the columns to be labels.

Help



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

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