How to change numbered columns to alphabet?

Your column labels are numeric rather than alphabetic. For example, instead of seeing A, B, and C at the top of your worksheet columns, you see 1, 2, 3, and so on. or to make it look like that. This behavior occurs when the R1C1 reference style check box is selected in the Options dialog box.

To change this behavior, follow these steps:

In Microsoft Office 2003 or Older

  1. Start Microsoft Excel.
  2. On the Tools menu, click Options.
  3. Click the General tab.
  4. Under Settings, click to clear the R1C1 reference style check box (upper-left corner), and then click OK.

In Microsoft Office 2007 or Microsoft Office 2010

If you select the R1C1 reference style check box, Excel changes the reference style of both row and column headings, and cell references from the A1 style to the R1C1 style.image

  1. Start Microsoft Excel.
  2. click Office Button
  3. Click the Excel Options tab.
  4. Under Formulas tab , uncheck the R1C1 reference style check box and then click OK.

DONE!!

Advertisements
This entry was posted in How To, MS Office, Tips & Trick and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s