Go to your worksheet and press and hold your left mouse button, dragging your mouse down and to the right to create a text box.Īdding a bulleted or numbered list to your text box Here are three steps to create a text box on your worksheet:Ĭlick on the Insert tab in the Ribbon and select Text on the right side of the tab. The new group now appears on the right side of the Home tab. Click this option and drag it to the new group you just renamed.Ĭlick Ok. Scroll down the list that appears and find the Bullets and Numbering option. On the left side of the Excel Options window, click Choose Commands from the drop-down menu and select All Commands. Type a new name such as 'Bullets' or 'Bullets and Numbering' to rename the group. This adds a new group to the Home group underneath the box you selected.Ĭlick the New Group (Custom) group and then the Rename button at the bottom of the Main Tabs section. On the right side of this window, click the Home box in the Main Tabs section.Ĭlick the New Group button at the bottom of the Main Tabs section. Open Excel and click the File tab located in the Ribbon.Ĭlick Options in the left navigation menu.Ī window titled Excel Options appears, where you can click Customize Ribbon on the left side of the window. Here are 10 steps to make the bulleted and numbered list option appear in the Ribbon: Here are a few lists with steps to help you get started: Adding the numbering and bulleted list options to the Ribbon Related: 25 Best Excel Tips To Optimize Your Use How to add bullet points and numbering using a text boxīulleted and numbered lists aren't commonly used in Excel, so you can manually add that option to the Ribbon before adding a text box. For example, you may want to number each name in a list detailing team members' performance numbers for an entire company for a specific period of time. Numbered lists can also provide clarity if you have a long list of entries. Bullets can help separate entries in a list for readability, or they can provide guidance or assist with comprehension if you have multiple lists on a worksheet. The main use for bullets and numbering in Excel is to organize elements in a worksheet. Related: How To Learn Excel for Office Work: A Complete Guide Uses for bullets and numbering in Excel on Windows

In this article, we discuss the uses for bullets and numbering in Excel on Windows operating systems, several methods for adding bullets or numbering to your spreadsheets and tips to help you use bullets and numbering in the program. Learning how to use organization tools such as bullets and numbering can help you better visualize your data. People in many professions find this software useful, but Excel is accessible to anyone who needs to arrange their information. Excel is a spreadsheet program that helps people organize, analyze and filter large amounts of data.

How to add bullets on word 2013