Posted by Nic Domondon on November 23, 2001 12:15 AM
Typically in building a spreadsheet, I use row 1 for the column headers. My question is, is there a way to change the column headers in excel such that instead of letters, i can place my own header? This way, row 1 immediately becomes a data cell not a column header cell.
This is so that i do not have to refer to a cell address as A143. Instead i can refer to a cell as NAME143 for example. It is a lot easier to navigate through a large spreadsheet instead of remembering combinations of letters and numbers.
Can I also do this with the rows?