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 Rhinorhino 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
Joined
Sep 6, 2001
Messages
72
Location
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
Thanks a lot.

Tap_ks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question Question
Trim Multiple items in one column
Replies
2
Views
505
Andrzejek
Andrzejek
titanif
  • Locked
  • Question Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
426
SkipVought
S
Kim296
  • Question Question
Need Genius Help - Finding multiple duplicates between columns - EXCEL
2
Replies
38
Views
3K
mintjulep
M
TrekBiker
  • Locked
  • Question Question
Use 2 columns in Detail Section of report
Replies
8
Views
1K
TrekBiker
TrekBiker
Saif_Abc
  • Locked
  • Question Question
How to change Grid Heading
Replies
10
Views
623
combo
combo

Part and Inventory Search

Sponsor

Back
Top