excel数字前端对齐_放大后使Excel数字正确对齐

excel数字前端对齐

放大后使Excel数字正确对齐 (Make Excel Numbers Line Up Correctly When Zoomed)

At 100% zoom setting in Excel, the numbers display correctly. If I have a column of 7 digit numbers, all 7 numbers line up correctly, all down the column. For example, 1111111 is the same width as 8888888:

在Excel中100％缩放设置下，数字正确显示。 如果我有一列由7位数字组成的数字，则所有7个数字都正确地排列在列的下面。 例如1111111与8888888的宽度相同：

However, if I zoom to something less than 80%, the numbers become proportional, and don't line up correctly. Here are the same numbers and dates, at 70% zoom.

但是，如果缩放到80％以下，数字将成比例，并且排列不正确。 以下是相同的数字和日期，缩放比例为70％。

An entry of 1,111,111 is much narrower than 8,888,888.

1,111,111的条目比8,888,888的条目窄得多。

This can cause problems, if you're skimming down a long column of numbers, to spot entries that are unusually large.

如果您正在浏览一长列数字，这会引起问题，以发现异常大的条目。

更改注册表设置 (Change a Registry Setting)

You can change a registry setting, as described in the following MSKB article, to prevent numbers from displaying in proportional font. As always, you should make a backup copy of the registry before you tweak any settings:

您可以更改注册表设置，如下面的MSKB文章中所述，以防止数字以比例字体显示。 与往常一样，在调整任何设置之前，应制作注册表的备份副本：

Euro Currency Character Is Not Displayed Correctly in Excel 2003

在Excel 2003中不能正确显示欧元货币字符

This is really a fix for a Euro symbol display problem, but it also fixes the proportional font display.

这确实是解决欧元符号显示问题的方法，但它也修复了比例字体显示。

Here's what the article suggests, and you can replace the 11.0 with the version of Excel that you're using:

这是本文的建议，您可以将11.0替换为所使用的Excel版本：

• Quit any programs that are running.
  退出所有正在运行的程序。
• Click Start, and then click Run.
  单击开始，然后单击运行。
• In the Open box, type regedit, and then click OK.
  在“打开”框中，键入regedit，然后单击“确定”。

• HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelOptions

  HKEY_CURRENT_USER软件MicrosoftOffice11.0ExcelOptions

• After you select the key that is specified in step 4, point to New on the Edit menu, and then click DWORD.
  选择在步骤4中指定的键之后，指向“编辑”菜单上的“新建”，然后单击“ DWORD”。

• Type FontSub, and then press ENTER.
  键入FontSub，然后按Enter。
• Right-click FontSub, and then click Modify.
  用鼠标右键单击FontSub，然后单击修改。
• In the Value data box, type 0, and then click OK.
  在“数值数据”框中，键入0，然后单击“确定”。

• On the File menu, click Exit to quit Registry Editor.
  在文件菜单上，单击退出以退出注册表编辑器。
• Start Excel.
  启动Excel。

测试结果 (Test the Result)

After making the registry change, open Excel and zoom to 75% or lower. The numbers should remain displayed in non-proportional font.

更改注册表后，打开Excel并缩放到75％或更低。 数字应仍以非比例字体显示。

Here are those numbers at 70%, after the fix – problem solved!

这些是修复后的70％的数字–问题已解决！

翻译自: https://contexturesblog.com/archives/2009/04/28/make-excel-numbers-line-up-correctly-when-zoomed/

excel数字前端对齐