ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you change the column names e.g. A B C D E F (https://www.excelbanter.com/excel-discussion-misc-queries/66219-how-do-you-change-column-names-e-g-b-c-d-e-f.html)

dan

How do you change the column names e.g. A B C D E F
 
How do you change the column names e.g. A B C D E F
in exel

Ron Coderre

How do you change the column names e.g. A B C D E F
 
Here are your options:
You can Show/Hide column and row headings
You can use the R1C1 style, instead of the A1 style

If you want your users to see something else, try this:
Put your "new" column headings in Row_1
Example:
A1: InputDate,
B1: Customer Name
etc

Then: ToolsOptionsView tab
Uncheck Row & Column Headers

I hope that helps?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dan" wrote:

How do you change the column names e.g. A B C D E F
in exel



All times are GMT +1. The time now is 04:13 PM.

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