Microsoft Excel支持很多东西,其中之一就是能够将项目符号列表(bullet list)添加到电子表格中。不幸的是,该工具没有提供一种直接的方式来做到这一点,这令人非常失望。
但不用担心,我们已经找到了一种在您的电子表格中添加项目符号的方法,虽然与在Microsoft Word、PowerPoint等中添加项目符号相比并不容易,但在(PowerPoint)Excel 中(Excel),一旦您看到它就不会太棘手了我们做了什么。现在,请记住,添加项目符号时没有很多视觉提示。尽管如此,相信我们会让这个过程尽可能简单。
在 Excel 中添加项目符号点
在Excel(Excel)中向文本添加项目符号的过程如下:
- 打开 Excel 工作表
- 单击文本框图标
- 选择文本框
- 调整大小并将文本添加到框中
- 将项目符号添加到您的列表中,
或者,我们也可以通过Symbol Menu来做到这一点。将(Will)在下面更详细地讨论该选项。
(Add)通过文本框(Text Box)选项添加项目符号
向电子表格添加项目符号的最佳方式可能是利用文本框(Text Box)功能。
1]单击文本框图标
在我们开始之前,您必须首先从功能区中选择(Ribbon)插入(Insert),然后从那里单击文本框(Text Box)图标。
2]调整大小并将文本添加到框中
现在的下一步是在您想要拥有项目符号文本的区域中绘制框。按下左键,然后向右拖动鼠标以创建框。完成后,以列表格式在文本框中添加相关文本。
3]将项目符号添加到您的列表中
归结为将项目符号添加到列表中时,突出显示框中的所有文本,然后单击鼠标右键。马上(Right),应该会弹出一个菜单。只需(Simply)单击项目符号,您就应该立即使用项目符号文本。
(Insert)从符号(Symbol)菜单插入项目符号
符号菜单是另一种添加项目符号的好方法,但与以前相比需要更多的工作。尽管如此,它仍然运行良好,因此请试驾一下,看看您可能喜欢或不喜欢它。
选择符号图标
您需要在这里做的第一件事是单击符号(Symbol)图标以启动菜单。您可以通过单击“插入(Insert)”选项卡来执行此操作,然后从那里选择“Symbol > Symbols” 。在执行所有操作之前,请务必选择一个空白单元格。
找到子弹符号
当涉及到定位子弹符号时,这非常容易。从符号(Symbol)菜单中,请在字符代码框中(Character Code box)添加 2022 ,然后点击插入(Insert)按钮将项目符号添加到所选单元格。
这些是在Microsoft Excel(Microsoft Excel)中添加项目符号的最佳方法,因此请使用最适合您的方法。请务必与您的朋友、家人和其他任何人分享本指南。
How to add bullet points to text in Excel with these easy tips
Microsoft Excel supports a lot of things, and one of them is the ability to add a bullet list to your spreadsheet. Unfortunately, the tool does not offer a straightforward way of doing this, which is quite disappointing.
But worry not, we have found a way to add bullet points to your spreadsheet, and while it is not as easy when compared to doing it in Microsoft Word, PowerPoint, etc., it won’t be too tricky in Excel once you see what we’ve done. Now, bear in mind that there aren’t many visual cues when adding bullet points. Despite that, trust us to make the process as super easy as possible.
Add bullet points in Excel
The procedure to add bullet points to text in Excel is as follows:
- Open the Excel sheet
- Click on the Text Box icon
- Select Text Box
- Resize and add text to the box
- Add bullets to your list,
Alternatively, we can also do this via the Symbol Menu. Will discuss that option in more detail below.
Add bullet points via the Text Box option
Probably the best way to add bullet points to a spreadsheet is to take advantage of the Text Box feature.
1] Click on the Text Box icon
Before we get down to that, you must first select Insert from the Ribbon, then from there, click on the Text Box icon.
2] Resize and add text to box
The next step right now is the draw the box in the area where you want to have your bulleted text. Press the left-click button, then drag the mouse in the right direction to create the box. Once that is done, add the relative text within the text box in a list format.
3] Add bullets to your list
When it comes down to adding bullets to your list, highlight all text in the box, then hit right-click. Right away, a menu should pop up. Simply click on Bullets, and right away, you should have bulleted texts to work with.
Insert bullet points from the Symbol menu
The symbol menu is another great way to add bullet points but requires more work when compared to the previous. Still, it works quite well, so give it a test drive to see how well you may or may not like it.
Select the Symbols icon
The first thing you will need to do here is click on the Symbol icon to launch the menu. You can do this by clicking on the Insert tab, then from there, select Symbol > Symbols. Be sure to select a blank cell before doing all of that.
Find the bullet symbol
When it comes down to locating the bullet symbol, this is super easy. From the Symbol menu, please add 2022 in the Character Code box, then hit the Insert button to add the bullet to the selected cell.
These are the best ways to add bullets in Microsoft Excel, so use the one that speaks to you the best. And be sure to share this guide with your friends, family, and whomever else.