eclipse自动更正_创建和复制自动更正列表项

eclipse自动更正

To save time, create AutoCorrect entries for words, phrases, and even symbols that you type frequently. Then, type a short code, and Excel automatically changes it to the full text. See how to create an entry, then print a list of all your entries, and copy them to a different computer, using the AutoCorrect macros below.

为了节省时间，请为您经常键入的单词，短语甚至符号创建自动更正条目。 然后，输入一个短代码，Excel会自动将其更改为全文。 了解如何创建条目，然后打印所有条目的列表，然后使用下面的“自动更正”宏将它们复制到另一台计算机上。

创建Excel自动更正条目 (Create Excel AutoCorrect Entries)

The programs in Microsoft Office share a common list of AutoCorrect entries. Any entries that you create or change in Excel, will also be available in Word, Outlook, and PowerPoint.

Microsoft Office中的程序共享一个自动更正条目的公共列表。 您在Excel中创建或更改的所有条目也将在Word，Outlook和PowerPoint中可用。

To see the AutoCorrect list:

要查看自动更正列表：

• On the Excel Ribbon, click the File tab, and then click Options
  在Excel功能区上，单击“文件”选项卡，然后单击“选项”。
• Click the Proofing category, and then click the AutoCorrect Options button.
  单击“打样”类别，然后单击“自动更正选项”按钮。

To add a text entry:

要添加文本条目：

• In the Replace box, type a short code that will be easy to remember.
  在“替换”框中，键入一个容易记住的简短代码。
• In the With box, type the full word or phrase that will replace the short code, after you type it.
  在“使用”框中，键入完整的单词或短语，然后将其替换为短代码。

For example, I entered the short code: .dd

例如，我输入了短代码：.dd

When I type that on a worksheet, it will be replaced by my full name: Debra Dalgleish

当我在工作表上键入该名称时，它将被我的全名代替：Debra Dalgleish

创建自动更正符号 (Create AutoCorrect Symbols)

In the AutoCorrect Options window, there is a tab for Math AutoCorrect. Unfortunately, those shortcuts don't work in Excel.

在“自动更正选项”窗口中，有一个“数学自动更正”选项卡。 不幸的是，这些快捷方式在Excel中不起作用。

However, you can copy the symbols from that tab, and create regular AutoCorrect entries for them.

但是，您可以从该选项卡复制符号，并为其创建常规的自动更正条目。

This animated screen shot shows the steps - type a short code, copy and paste a symbol from the Math tab, then use the short code on your worksheet, any time you need it.

此动画屏幕快照显示了步骤-键入短代码，从“数学”选项卡中复制并粘贴符号，然后在需要时在工作表上使用该短代码。

Excel自动更正条目列表 (List of Excel AutoCorrect Entries)

If you'd like to see everything that's in your AutoCorrect list, run this macro, written long ago by Dana DeLouis, and he shared it in the Excel newsgroups.

如果您想查看“自动更正”列表中的所有内容，请运行此宏，该宏是Dana DeLouis很久以前编写的，他在Excel新闻组中共享了此宏。

I added a line to insert a new sheet, so you don't accidentally overwrite anything. The macro lists the short codes (Replace) items in column A, and the full text (With) in column B.

我添加了一行以插入新工作表，因此您不会意外覆盖任何内容。 宏在A列中列出了短代码(替换)项，在B列中列出了全文(带有)。

Copy this macro, and paste it into a regular code module.

复制此宏，然后将其粘贴到常规代码模块中 。

Sub AutoCorrectEntries_Display()
'// Dana DeLouis
'// Backup AutoCorrect to Worksheet
'2018-01-30 added line to insert new sheet
   Dim ACE
   ACE = Application.AutoCorrect.ReplacementList
   Sheets.Add
   Range(Cells(1), Cells(UBound(ACE), 2)) = ACE
   Columns("A:B").AutoFit
End Sub

编辑自动更正条目列表 (Edit the AutoCorrect Entries List)

After the list is created on a worksheet, you can manually edit it, before you import the list to a different computer.

在工作表上创建列表后，您可以手动编辑它，然后再将列表导入另一台计算机。

For example,

例如，

• add new codes and replacement text
  添加新代码和替换文本
• modify the replacement text for personal entries that you previously created
  修改您先前创建的个人条目的替换文本
• delete any personal entries that won't be needed on the other computer
  删除其他计算机不需要的任何个人条目

Or, just leave the list as is, then save and close the workbook.

或者，仅保留列表不变，然后保存并关闭工作簿。

从列表添加自动更正条目 (Add AutoCorrect Entries From List)

After you create your list of AutoCorrect entries, use the following macro (also by Dana DeLouis)  to add those entries on a different computer.

创建自动更正条目列表之后，使用以下宏(也是Dana DeLouis编写的)将这些条目添加到另一台计算机上。

• Open the workbook with the list,
  用列表打开工作簿，
• Activate the sheet that has the exported list of AutoCorrect items.
  激活具有自动更正项目的导出列表的工作表。
• Run the macro below, to add those items to the new computer's list.
  运行下面的宏，以将这些项目添加到新计算机的列表中。

What the macro does:

宏的作用：

• adds any new items
  添加任何新项目
• overwrites any matching codes
  覆盖任何匹配的代码
• does NOT remove any existing entries that are not in the list
  不会删除列表中没有的任何现有条目

Copy this macro, and paste it into a regular code module.

复制此宏，然后将其粘贴到常规代码模块中 。

Sub AutoCorrectEntries_Add()
'// Dana DeLouis
'// Add AutoCorrect entries.
'// Column A -> Wrong   Word
'// Column B -> Correct Word
   Dim rng As Range
   With Application.AutoCorrect
      For Each rng In Columns(1) _
      .SpecialCells(xlConstants, _
          xlTextValues).Cells
         .AddReplacement rng, rng.Offset(0, 1)
      Next
   End With
End Sub

翻译自: https://contexturesblog.com/archives/2018/02/01/create-and-copy-autocorrect-list-items/

eclipse自动更正