excel公式数字列转列号_Excel列标题显示数字

excel公式数字列转列号

Have you ever opened an Excel workbook and found that the column headings show numbers instead of letters? The formula look strange too, showing references like RC[-1] instead of D2.

您是否曾经打开过Excel工作簿，发现列标题显示的是数字而不是字母？ 该公式看起来也很奇怪，显示了诸如RC [-1]而不是D2的引用。

This is R1C1 reference style -- a handy feature, and I use it sometimes when programming or setting up a workbook.

这是R1C1参考样式-一个方便的功能，在编程或设置工作簿时有时会使用它。

Numbers on the column headings make it easier to set up formulas that need a column number, such as VLOOKUP. I don’t have to get fingerprints on my screen, as I count across to column R, where the lookup value is.

列标题上的数字使设置需要列号的公式(例如VLOOKUP)更加容易。 我不必在屏幕上留下指纹，因为我可以跨过查找值所在的R列。

视频：将Excel列标题从数字更改为字母 (Video: Change Excel Column Headings from Numbers to Letters)

To see why this happens, and how to switch the column headings back to letters, watch this short video tutorial. The written instructions are below the video.

要了解为什么会发生这种情况以及如何将列标题切换回字母，请观看此简短的视频教程。 书面说明在视频下方。

演示地址

为什么会发生 (Why It Happens)

Maybe you’ve never heard of R1C1 reference style, and certainly didn’t change any settings. If you didn’t turn that option on, why did the numbers suddenly appear? Probably because someone sent you a workbook, and that’s the first Excel file that you opened today.

也许您从未听说过R1C1参考样式，并且肯定没有更改任何设置。 如果您没有打开该选项，为什么数字突然出现？ 可能是因为有人向您发送了一个工作簿，这是您今天打开的第一个Excel文件。

The first workbook that you open, when opening Excel, sets the reference style. For example, perhaps I built a workbook for you, and saved it while I was using R1C1 reference style.

打开Excel时，打开的第一个工作簿将设置引用样式。 例如，也许我为您构建了一个工作簿，并在使用R1C1参考样式时将其保存。

I sent you the workbook overnight, and it was the first thing you opened this morning. Surprise! There are numbers in the column headings.

我一夜之间将工作簿发送给您，这是您今天早晨打开的第一本书。 惊喜！ 列标题中有数字。

打开或关闭R1C1参考样式 (Turn R1C1 Reference Style On or Off)

If you close Excel, then open a workbook that you created yourself, with letters in the column headings, that will change the reference style back to A1, which has letters in the column headings.

如果关闭Excel，则打开您自己创建的工作簿，该工作簿的列标题中包含字母，这会将引用样式更改回A1，该列标题中包含字母。

Or, to manually change the reference style, you can change the option setting.

或者，要手动更改参考样式，可以更改选项设置。

在Excel 2010中： (In Excel 2010:)

1. • 
2. Click the Formulas category.
   单击公式类别。
3. In the Working with Formulas section, add or remove the check mark from 'R1C1 reference style'
   在“使用公式”部分中，从“ R1C1参考样式”中添加或删除复选标记
4. Click OK to close the Options window.
   单击“确定”关闭“选项”窗口。

在Excel 2007中： (In Excel 2007:)

1. 1. At the left end of the Ribbon, click the Office Button, then click Excel Options.
      在功能区的左端，单击“ Office按钮”，然后单击“ Excel选项”。
   2. Click the Formulas category.
      单击公式类别。
   3. In the Working with Formulas section, add or remove the check mark from 'R1C1 reference style'
      在“使用公式”部分中，从“ R1C1参考样式”中添加或删除复选标记
   4. Click OK to close the Options window.
      单击“确定”关闭“选项”窗口。

在Excel 2003和早期版本中： (In Excel 2003 and earlier versions:)

1. On the Tools menu, click Options and select the General tab.
   在工具菜单上，单击选项，然后选择常规选项卡。
2. Add or remove the check mark from 'R1C1 reference style'
   在“ R1C1参考样式”中添加或删除复选标记
3. Click OK to close the Options dialog box.
   单击“确定”关闭“选项”对话框。

使用宏切换标题 (Use a Macro to Switch Headings)

If you frequently change the headings from numbers to letters, or letters to numbers, you can create a macro to do the work for you.

如果您经常将标题从数字更改为字母，或将字母更改为数字，则可以创建一个宏来为您完成工作。

There are instructions in this blog post: Excel VBA: Switch Column Headings to Numbers ________________________

此博客文章中有说明： Excel VBA：将列标题切换为数字 ________________________

翻译自: https://contexturesblog.com/archives/2009/04/13/excel-column-headings-show-numbers/

excel公式数字列转列号