您(Did)知道Microsoft Word、Excel、PowerPoint和Outlook都具有测量转换器(Measurement Converter) 功能吗?有了这个,用户应该可以更轻松地生成测量转换,而无需手动进行。然而,就Excel而言,用户需要知道公式。
在Office(Office)中自动转换测量值
奇怪的是,测量转换功能根本不是微软(Microsoft)谈论的东西,这就是为什么大多数Office工具的用户不知道它的存在。好吧(Well),现在你知道了,而且你可能已经知道了,我们将讨论如何使用它。
这个功能默认是不开启的,所以这篇文章也将讲解如何在需要的时候开启和关闭它。
- 在Word和PowerPoint中打开测量转换器(Measurement Converter)
- 在Outlook中启用测量转换器(Measurement Converter)
- (Use)在现实世界中使用测量转换器
- 在 Excel 中使用测量转换器
让我们以更详细的方式讨论这个问题。
1]在Word和PowerPoint中打开(Turn)测量转换器(Measurement Converter)
如果您想充分利用测量转换器工具,您必须首先启用它。然而,这里有一个小问题。你看,在Word(Word)和PowerPoint中启用该功能的步骤是相同的,但在Microsoft Outlook中是不同的。
好的,因此要打开该功能,用户必须单击File然后导航到Options。从那里,转到校对(Proofing)>自动更正选项(AutoCorrect Options)。从弹出窗口中,选择“操作”(Action)选项卡,然后确保勾选“在右键单击菜单中启用其他操作(Enable Additional Actions in the Right-Click Menu)”旁边的框。
最后,选择Measurement Converter,然后点击 OK,就是这样。
2 ]在Outlook中(Outlook)启用测量转换器(] Enable Measurement Converter)
当归结为在Outlook中启用此功能时,这些步骤需要更多的工作。但过分如此,至少从我们的经验来看。
要让事情动起来,请点击File > Options。从那里,查找邮件(Mail)并立即选择它。下一步是单击Edit Options,然后从下一个窗口中选择Proofing 。最后,请单击“自动更正选项(AutoCorrect Options)”以显示弹出窗口。
在该窗口中,单击“操作”选项卡,然后通过勾选框“(Actions)在右键单击菜单中启用其他操作(Enable Additional Actions in the Right-Click Menu)”来浪费时间。
从列表中,选择“测量转换器”,并确保单击“确定”按钮以完全完成任务。
3]在现实世界中使用测量转换器(Use)
当需要使用新启用的功能时,最好在文档中突出显示测量值,然后右键单击它。从那里,选择Additional Actions,然后从弹出的任何选项中进行选择。
阅读:使用(Read)Office 中的信息权限管理服务限制对文档的访问(Access)。
4]在Excel中(Excel)使用(Use)测量转换器公式
在将测量值转换为Microsoft Excel方面,您必须打开文档,然后在 A 列中添加要转换的单位的名称。在 B 列中,键入要将 A 列的测量值转换为的单位名称。
如您所见,我们决定将千英里换算为英里,将磅换算为千克。
将千英里转换为英里时,请务必添加以下代码:=CONVERT(B5,"km","mi")
.
在将磅转换为千克方面,您将需要使用=CONVERT(B8,"lbm","kg")
. 请记住(Bear),当您键入时,Excel将提供可供选择的选项。
因此,我们建议不要复制和粘贴公式,而是输入它们以查看不同情况下的不同测量值。
此外,我们建议访问此链接以查找来自(this link)Microsoft的更多测量系统。
阅读下一篇(Read next):如何在 Word 中插入自定义封面(How to insert a Custom Cover Page in Word)。
How to use Measurement Converter in Microsoft Office
Did you know Microsoft Word, Excel, PowerРoіnt, and Outlook all havе a Measurement Converter feature? With this, users should have an easier time generating measurement conversion without having to do so manually. In terms of Excel, however, users are required to know the formulas.
Automatically convert measurements in Office
Strangely enough, the measurement conversion feature is not something Microsoft talks about at all, which is why most users of the Office tool have no idea it exists. Well, now you do, and as you might already know, we’re going to discuss how to use it.
This feature is not turned on by default, so this article will also explain how to turn it on and off whenever the need arises.
- Turn on Measurement Converter in Word and PowerPoint
- Enable Measurement Converter in Outlook
- Use measurement converter in the real world
- Use measurement converter in Excel
Let us talk about this in a more detailed manner.
1] Turn on Measurement Converter in Word and PowerPoint
If you want to take full advantage of the measurement converter tool, you must first enable it. There is a small problem here, however. You see, the steps to enable the function are the same in Word and PowerPoint, but different in Microsoft Outlook.
OK, so to turn the feature on, the user must click on File and then navigate to Options. From there, go to Proofing > AutoCorrect Options. From the pop-up window, select the Action tab, then be sure to tick the box beside “Enable Additional Actions in the Right-Click Menu.”
Finally, select Measurement Converter, then hit OK, and that’s it.
2] Enable Measurement Converter in Outlook
When it comes down to having this feature turned on in Outlook, the steps require more work. But overly so, at least from our experience.
To get things moving, please click on File > Options. From there, look for Mail and select it right away. The next step from there is to click on Edit Options, then select Proofing from the next window. Finally, please click on AutoCorrect Options to reveal a pop-up window.
From that window, click on the Actions tab, then waste no time by ticking the box, “Enable Additional Actions in the Right-Click Menu.”
From the list, select “Measurement Converter,” and be sure to hit the OK button to complete the task fully.
3] Use measurement converter in the real world
When it is time to use the newly enabled feature, the best thing to do here is to highlight the measurement in your document and then right-click on it. From there, select Additional Actions, then choose from any of the options that popped up.
Read: Restrict Access to your documents using Information Rights Management Service in Office.
4] Use measurement converter formula in Excel
In terms of converting measurements into Microsoft Excel, you must open the document then add the name of the unit you want to convert in column A. In column B, type the name of the unit want the column A measurement to be converted to.
As you can see, we have decided to convert kilo-miles to miles and pounds to kilograms.
When converting kilo-miles to miles, be sure to add the following code: =CONVERT(B5,"km","mi")
.
In terms of converting pounds to kilogram, you will want to use =CONVERT(B8,"lbm","kg")
. Bear in mind that as you type, Excel will provide options to choose from.
So, instead of copy and paste the formulas, we suggest typing them to see different measurements for different cases.
Furthermore, we suggest visiting this link to find more measurement systems from Microsoft.
Read next: How to insert a Custom Cover Page in Word.