columns

M

Melisa

How do I re-name the columns for A, B, C, etc... to what I want- I am trying
to make a guest list and need to change the column names.

Please help me
 
G

Gord Dibben

A workaround since you cannot change the letters as JE points out.

Use row 1 for your titles then select A2 and Window>Freeze Panes so row 1 is
always in view.

Tools>Options>View. Uncheck Row and Column Headers if you don't want to see
them.


Gord Dibben MS Excel MVP
 
E

Elkar

Place your Column Names in Row 1, then start your data in Row 2. The (A, B,
C...) names cannot be customized.

HTH,
Elkar
 

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

Incorporating the User Profile location into a document template path 1
MS Project Center-Autolink column fields 0
How to center adjust text above and image in a two column document. 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Footer text appears "squished" 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Two columns followed by single page-width column on same page 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top