Hướng dẫn how to label rows and columns in excel - cách gắn nhãn hàng và cột trong excel

Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Columns and rows are labeled numerically in Excel

• Article
• 05/05/2022
• 2 minutes to read
• Applies to:Excel 2000

In this article

Symptoms

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.

Cause

This behavior occurs when the R1C1 reference style check box is selected in the Options dialog box.

Resolution

To change this behavior, follow these steps:

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

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.

More information

A1 Reference Style vs. R1C1 Reference Style

The A1 Reference Style

By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65,536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50. To refer to a range of cells, type the reference for the cell that is in the upper-left corner of the range, type a colon (:), and then type the reference to the cell that is in the lower-right corner of the range.

The R1C1 Reference Style

Excel can also use the R1C1 reference style, in which both the rows and the columns on the worksheet are numbered. The R1C1 reference style is useful if you want to compute row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number.

References

For more information about this topic, click Microsoft Excel Help on the Help menu, type about cell and range references in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel 2020 series. Today I will show you two ways in which you use Column and Row labels as named ranges.

About Named Ranges.

A named range is simply a name that refers to either a cell, a range of cells, a constant value or a formula. These names can then be used in a formula to replace a constant value or a cell reference.

If you want to read more about named ranges I have a blog post right here.  In summary, my  top three reasons for using named ranges are

1. Your formulas will make more sense
2. You can easily edit your formulas
3. Formulas created really quickly

Two Ways To Use Column and Row Labels As Named Ranges.

So, let’s look at the two ways to use the column or row labels as named ranges in Exel. 

First, if you are starting with a new workbook you can actually get Excel to recognise the column and row labels as names. To do this before you create any formulas in your workbook

1. Tools
2. Options
3. Calculation
4. Check accept labels for in formulas box.

Second, if you are working on an existing workbook you have the option to convert existing labels to range names.  The labels can be positioned at any edge of the range of values to name.

Open a new workbook. Type in the data as below

Next, select the cells containing the text labels and at least 1 of the adjacent cells that contain your value. In this case it would be cells A1:C2 to incorprate the the labels and row one of our data.

1. Insert
2. Name
3. Create