Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column Heading Chnge

Status
Not open for further replies.
tapks

tapks

IS-IT--Management
Sep 6, 2001
72
IN
Whenever I am opeing any of my Excel Sheet I found that Column heading has changed tp 1,2,3....so on in place of A,B,C,D.....

How to set it back to the origional one.

Can anybody help me out.


Thankx in advance.

Tap_Ks
 
Sort by date Sort by votes
You have got the column setting set to R1C1 setting. Go to TOOLS->OPTIONS and under the General tab, uncheck the R1C1 checkbox.

That should resolve it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
293
Andrzejek
Andrzejek
titanif
  • Locked
  • Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
226
SkipVought
S
TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
544
TrekBiker
TrekBiker
Saif_Abc
  • Locked
  • Question
How to change Grid Heading
Replies
10
Views
242
combo
combo
TheLazyPig
  • Locked
  • Question
Separate name per column in Excel
Replies
5
Views
236
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top