Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Is it possible to change the column name in Excel?
Can we change A, B, C, D,... columns into a user defined name? (for instance Invoices, Taxes, Profit,...)
5 Answers
- garbo7441Lv 71 decade agoFavorite Answer
As Jamie K stated, no you cannot change the column 'names' to 'Taxes', etc. You can only change them to numbers, using the R1C1 reference style, or retain them as letters.
You must use the first row as your column headers. If you want to lose the 'A, B, C, D', etc then hide the row and column headers.
Excel 2003:
Go to Tools > Options > View
Remove the check mark from 'Row & Column Headers' in the Window Options
Excel 2010:
Select the View tab.
Remove the check mark from 'Heading' in the 'Show' group.
- Anonymous1 decade ago
Why are you wanting to do this? Is it because when you scroll down, you can't see the headers? Why not just freeze the top row....In Excel 2007 and later, click the View tab, then "Freeze Panes", then "Freeze Top Row". (not sure how to do it in earlier versions).
If the reason you are wanting to this is so it can be used in formulas, then move the cursor over the A column name and when the cursor changes to a down arrow, click. Then in the name box (the box to the left of the formula box), type Invoices. You can now use Invoices instead of the column in your formulas. Example below
=INDEX(Invoices,33)
- Anonymous7 years ago
If you want to change the column name for sorting purposes just be sure to check the "my data has headers" box in the sort dialogue box. Then whatever titles are in your top row will become the names of your columns.
- 1 decade ago
Rows numbers and column letters are used for reference. It is easy to name your columns then fill in the data. When you sort or use subtotals the first column of you data block will be recognized as the header.
- How do you think about the answers? You can sign in to vote the answer.
- Anonymous1 decade ago
no