excel字符串插入_如何将字符和符号插入Excel

傷城~ 2021-07-26 20:43 573阅读 0赞

![excel字符串插入][excel]

excel字符串插入

Many times we will want to enter in symbols and character other than the standard.  You might be doing business in Europe and need to enter in Euro’s or other symbology into Excel sheets.  We can achieve this in easily in Excel 2007.

很多时候，我们将要输入标准以外的符号和字符。 您可能在欧洲经商，需要在Excel工作表中输入欧元或其他符号。 我们可以在Excel 2007中轻松实现。

First click on the Cell you want to add the symbol to.

首先单击要向其添加符号的单元格。

![1][]

Next you will want to go to The Ribbon and click on the Symbol Icon.

接下来，您将要转到功能区，然后单击符号图标。

![2][]

This brings up a Virtual Keyboard full of Symbols and Special Characters.

这将弹出一个充满符号和特殊字符的虚拟键盘。

![3][]

Simply select the one or several you wish to use and double click to enter them into the selected cell.  So in this example you can see I am getting carried away and trying out various fonts and languages…

只需选择您要使用的一个或多个，然后双击将它们输入到选定的单元格中即可。 因此，在此示例中，您可以看到我不知所措，并尝试了各种字体和语言…

![5][]

However, this is a great tip to know if you need to get that spreadsheet done by 5pm for Mr. Lumbergh!

但是，这是一个很好的提示，知道您是否需要在下午5点之前为Lumbergh先生完成该电子表格！

![lumbergh][]

> 翻译自: [https://www.howtogeek.com/79978/how-to-insert-characters-and-symbols-into-excel/][https_www.howtogeek.com_79978_how-to-insert-characters-and-symbols-into-excel]

excel字符串插入

[excel]: /images/20210726/4436399cd37c45d1b358112ac35f1e6d.png
[1]: /images/20210726/c6baf6db0839432c8850ef615c548581.png
[2]: /images/20210726/289d49f8cba4479897c21cf3e5cc3cfa.png
[3]: /images/20210726/f248e5cd45b2471483bd69316691e7fd.png
[5]: /images/20210726/b03b5a0e05804ccfaa3685a40854941c.png
[lumbergh]: /images/20210726/f925fd3bb10a48c6aac8a3b8ea37065b.png
[https_www.howtogeek.com_79978_how-to-insert-characters-and-symbols-into-excel]: https://www.howtogeek.com/79978/how-to-insert-characters-and-symbols-into-excel/