columns

G

Guest

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
 
G

Guest

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

Excel Help to copy information from one row at a time to another sheet 1
Consistent Sheet column header rows 2
SUM - IF - AND 7
Excel Concatenate with line breaks but ignore blank cells 3
Excel Subtracting multiple columns from another column 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Linking Data Columns 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Top