Name a Column

D

DaveB

Is it possible to put a name in place of the "A" at the top of the column? How do I do it?
 
G

Gord Dibben

Dave.

No, is not possible.

Alternative..........

Place names/titles in Row 1 then select A2 and Window>Freeze Panes to keep
these in view as yoi scroll down.

Tools>Options>View. Uncheck "Row and Column Headers".

Gord Dibben Excel MVP
 
D

Debra Dalgleish

You can't change the column letter to a name.

However, you can enter the names in row one.
Then, click on the row 2 button to select that row.
Choose Window>Freeze Panes

This will lock the headings in place, so you can always see them as you
scroll down the worksheet.
 
N

not so new user

----- DaveB wrote: ----

Thank you, I hate can't do people, don't you

Ooooh, such a harsh word 'hate'. :-(

I do hope that you're not rag'in on Peo Sjoblom who DID give you a specific answer to your specific question

Thankfully, there were other people here who offered alternatives for which you did not ask. Hope you realize that you still CAN'T do what you asked for originally, ie: change the column label to one of your choosing

How do you feel about people who don't know how to ask for what they want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Integrating information from Word to Excel (not mail merge) 1
Word VBA - Want to test if Full Name is NOT Present in document 0
How to center adjust text above and image in a two column document. 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Merging from an Excel file with graphics 1
Populate a table based on check box status 2
Autonumber field in Excel that behaves the same as Access 0

Top