Excel - how do you label column headings?

Question

EXCEL - how do you label the column headings? like instead of B naming that column with a name? thanks

Answer 1

If it is just for some table representation and not for any formulae to be used upon these,

1. U can go to Menu "Tools-->Options".
2. "View" tab.
3. Uncheck the option "Row & Column headers" check box.
(with this, your column and row headers will not be displayed).
4. You can create the first row with your column name.

(Might be after this U can define the name for each column and start using the values also for some formulae)...

Answer 2

No, you can't change the column headings, but if you really want to, you can make it look like they're changed by making the first row look like those column headings: - Format your first row to look like you want (like the column headings). - hide the real headings: Tools-Options-View-uncheck Row & column headers - go to cell A2 and do Window-Freeze Panes, so that your new headers always stay at the top This will result in column headings, but no row numbers. If you want row numbers, then: - put your new row numbers in column A - format column A to look like you want - go to cell B2 and do Window-Freeze Panes You can still change column widths using Format-Column-Width (and row heights, similarly). If you need more info, add more detail, or e-mail. Cheers. .

Answer 3

You can name any cell, array or range with any name you like. For instance, here is a formula-illustrated before and after with a calculation for average sales.

Before:
=SUM ( A1: A1000 ) / COUNT ( A1: A1000 )

After:
=SUM ( Sales ) / COUNT ( Sales )

To do this I assign the name "Sales" to the range A1:A1000.
1.) Select the desired range, A1:A1000 in this case
2.) On the menu bar, go to Insert | Name | Define...
3.) Type the desired name, in this case: Sales
4.) Click OK or press

Please note that if you assign a name to an entire column or to a column heading (as you describe), this will not allow you to reference other cells in that column using the same name. As shown above, the text "Sales" replaces the cell references, but referencing the cell A2, for example, in a different formula does not mean that Excel interprets that cell as related to the range we have associated with "Sales."

Answer 4

You can't. You can put labels in the top rows as display headers and reformat the heck out of them (centered, word wrapped, different font, colors, etc), but the alphabetic characters have to stay for cell and range definitions.

Sorry.

Answer 5

i'm not sure if got your question right but if you do not provide a column heading yourself during sorting, filtering etc, the only way excel identifies that column is by naming as "columna", "columnb", etc.
besides this, you have to label it yourself. i'm sorry there's no shortcut!

Answer 6

I could be wrong, but I don't think you can. I think you have to use the first row as your headings. Then it's called a header row. And if you use the "function" you can tell it not to include the header row.