ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Column and Row Titles (https://www.excelbanter.com/excel-worksheet-functions/165732-column-row-titles.html)

whitemordsith

Column and Row Titles
 
I want to change the Column Letters to reflect the 12 months. Column A -
rename to January. Rows will be my construction codes..not Row 1, Row 2,
ect... How do I do this?

JW[_2_]

Column and Row Titles
 
Can't. Just use row headings in column A and column headings in row
1. If you need to extract data from this, you can use a two-way table
lookup via Index, Match, Match.

whitemordsith wrote:
I want to change the Column Letters to reflect the 12 months. Column A -
rename to January. Rows will be my construction codes..not Row 1, Row 2,
ect... How do I do this?




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

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