Forum Discussion
Solved
Stop First Row Being Numbered in Excel
Only Excel can make you spend an hour on Google trying to find the answer and figure out what should be the most ridiculously simple thing to do: Stop the First Row Being Numbered. Seriously w...
Based on my experience and everything I've ever read, there is no way to change excel's row/column labels via excel's menu or vba, which is what it appears you are asking.
You can hide or unhide the row/column labels, and while you might be able to use a formula to visually replicate row/column label(s), either the custom row or column label won't agree to the actual cell references in your existing formulas, which comes back to Peter's comment regarding it would work better in a structured named environment.
You could do this (replicating excel's column letters), for example, but your data table row 1 will actually be Excel's row 3 (still mismatched, but it wouldn't be as obvious).
Seriously, I don't see any available options that I think you will like based on what you've said thus far.
Seriously, can anyone tell me how to do this or not??
Thanks.
Thanks.
Based on my experience and everything I've ever read, there is no way to change excel's row/column labels via excel's menu or vba, which is what it appears you are asking.
You can hide or unhide the row/column labels, and while you might be able to use a formula to visually replicate row/column label(s), either the custom row or column label won't agree to the actual cell references in your existing formulas, which comes back to Peter's comment regarding it would work better in a structured named environment.
You could do this (replicating excel's column letters), for example, but your data table row 1 will actually be Excel's row 3 (still mismatched, but it wouldn't be as obvious).
Seriously, I don't see any available options that I think you will like based on what you've said thus far.