EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Excel Bullet Points

Excel Bullet Points

Madhuri Thakur
Article byMadhuri Thakur

Updated August 21, 2023

Bullet Points in Excel

Introduction to Bullet Points in Excel

Microsoft Excel is more about numbers and reports. Sometimes you need to present some information in points in your report, and you can do it by adding bullet points in Excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

There are 6 different ways to use it. But the major drawback is that creating the bulleted list in Excel isn’t as straightforward as in Word documents as there is no direct button for adding bullets on the ribbon in Excel. But that doesn’t mean that we can’t add bullets in Excel.

How to Add Bullet Points in Excel?

As discussed above, we will show you the steps below to add bullet points in Excel by using 6 Different ways with some examples.

You can download this Bullet Points Excel Template here – Bullet Points Excel Template

Example #1 – Using Keyboard Shortcuts

The Simplest and quickest way to add the bullet symbol into the Excel sheet cell is by using keyboard shortcuts.

  • Alt + 7 to insert a Solid Bullet.

Shortcut Key - 1

  • Alt +9 to insert an Empty Bullet.

Shortcut Key - 2

  • Alt +254 for the Square Bullet.

Shortcut Key - 3

  • Alt +16 For Arrow Bullet

Shortcut Key - 4

Note:
You must use your numeric keypad to use the numbers key with Alt+tab. You may need to use different shortcuts if you are working on a laptop.

Users can use square or arrow bullet points instead of the usual solid and empty bullets to add some fancy bullet points.

Bullet points shortcut 5

Example #2 – Using the Symbol Dial Box

You can use Symbol Dial Box if you don’t have a number pad on your keyboard or forget Keyboard shortcuts.

We will show you this step by step and with an example.

  • Open an Excel Sheet.
  • Go to the Insert tab.
  • Select Symbols >Symbol under the Insert Tab.

Symbol option

  • After Selecting the symbol, a dialog box will open; Font Calibri will automatically get selected in the Font Dropdown, but you can select any font, select the bullet symbol you want to use, click Insert, and then click Close.

Types of Symbol

  • You can copy-paste the symbol to the next Row or Column.

So, in the above steps, it is shown how to insert by using the symbol tab under the Insert tab, and now let’s take a simple example.

We need to show the number of children admitted to School in 2019, and we want to show this data in the Excel file.

  • Open the Excel File.
  • Go to Insert Tab, and Select Symbol under Insert Tab.
  • So, in the file, we have created the heading “Name of Students Admitted in School in 2019.”
  • So before adding the names under it, we will add bullet points before the name as we want to show our data in Bullet Points. First, we will select the B3 cell.

Bullet points example 2-3

  • We will click on the Insert tab and select Symbol; a dialog box will appear after selecting the symbol. Next, we will select the Bullet symbol and select Insert.
  • The bullet will insert in a column, and you can update the student’s name.

Recently Used Symbols

  • A bullet is inserted in Column B3 & now you can type a student’s name. This way, you can add a bullet in another column and update the name, or you can copy-paste by using (CTRL+C) for copying and (CTRL +V) for pasting the bullet in other columns till where you want to update the data.

Bullet points example 2-5

  • So this way, the bullets are added using the Symbol tab. For any List or Worksheet, you can use it in a similar way.

Example #3 – Using a Function

It is useful when you want to add bullets to multiple cells at a time to use the CHAR function. It takes a character code and displays the character corresponding to it in the cell. We will show you an example of how to use this function.

  • Open an Excel Sheet.
  • Let’s say we have a list of fruits in Column A of the Excel sheet.

Bullet points example 3-1

  • We will convert the above list of fruits to the bulleted list in Column B using CHAR Formula.

In B2, we will put the formula (=CHAR(149)), adding a bullet to the column.

Bullet points example 3-2

  • If you want to add the name of the fruit after the bullet, you can type this formula (=CHAR (149)&” “&A2). This Formula concatenates a solid bulled character, one space, and the value of the referenced cell(A2).

Bullet points example 3-3

  • This method is useful if you list items in one column without the bullet. To copy the formula in other columns, drag the AutoFill box in the lower-right corner of the cell and scroll it down until you want to fill your data, as shown below.

Bullet points example 3-4

Example #4 – Using Custom Formatting

Custom Number Formatting is an amazing technique useful in a long Bulleted list as it adds the bullets to your list items faster and is useful when you don’t have a number pad.

Let’s discuss this feature with an example.

  • Open an Excel File.
  • We will select 15 cells in the Excel sheet in column A.
  • After Selecting the cells, we will press (CTRL+1) to open the Format Cell dialog box, or you can go to the Home tab and click the small icon below to open the dialog box.

Bullet points example 4-1

  • When the dialog box appears, we will go to the Number tab and select Custom from the below list.

Bullet points example 4-2

  • After Selecting Custom, a General Field will appear after Selecting Custom, as shown in the screenshot above. This field allows you to specify the format of the selected cells, which we selected in our second step (15 cells) from Column A1 to A15.
  • Now we will add bullet points by putting Bullet Symbol(you can copy the symbol from anywhere) and paste it in the type box, space, and then @ character, and Click OK.

Bullet points example 4-3

  • If you type “Little Elly School” in the A1 Cell and hit Enter, it will automatically come with the bullet point. If you check the formula bar, the value remains the same, which was only Little Elly School.

Bullet points example 4-4

  • Similar formatting will be applied for the 15 cells we selected in the starting & whatever you type in these cells, they will come up with bullet points.
  • We have added the data on all 15 cells with the school names using the same function. It will all come up with the bullet points in the Excel worksheet.

Bullet points example 4-5

Example #5 – By copying it From Microsoft Word

This feature is very simple and easy as we all know that we have the Bullet Feature in Word, so we can add our list of items in word with Bullet Points, copy the data from Word, and paste it into Excel by double-clicking the cell of a column.

  • Open the Microsoft Word Document.

Bullet points example 5-1

  • Select the Bullet Point feature in Word and type the data you want to update in Excel File. Then, copy the data by using CTRL+ C.
  • Open the Excel File and Paste the data by double-clicking on the cell (or press F2) and then Press (CTRL+V) in the Excel file. The Data copied from Word will be pasted into the Excel sheet.
Note: You can either double click the cell or press F2 before pasting the data to get the data in one cell; otherwise, bullet points will be pasted in one cell & data will be pasted in another cell.

Bullet points example 5-2

Example #6 – Entering Multiple Bullets in One Cell (ALT + ENTER)

Suppose you want to enter multiple bullet points in one cell. You can simply do this by following the below steps.

  • Double click on the cell or press F2.
  • Now insert the bullet point by following the above methods and enter the text you want.
  • After entering the text, press ALT + Enter

Bullet points example 6-1

  • This will take you to another line in the same cell.
  • Now you can add bullets again and enter the text.

For example, Look at the below screenshot, where I have entered multiple bullet points line items in a cell.

Bullet points example 6-2

Things to Remember

  • Bullet Point helps Clarify Writing as it avoids information in long texts and adds just the brief with quick information, but you should use it Wisely and in Limit.
  • Bulleted Lists should be arranged in an order that makes them as efficient as possible.
  • Bullets are designed for clarity, not confusion, so you should avoid using more bullets and sub-bullets.
  • Never have only one bullet. However, if you have a list of information, these bullet points are useful.

Recommended Articles

This has been a guide to Bullet Points in Excel. Here we discussed How to add Bullet Points with different Excel methods, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Wrap Text in Excel
  2. Header and Footer in Excel
  3. Watermark in Excel
  4. Strikethrough in Excel
SONY VEGAS PRO Course Bundle - 23 Courses in 1
132+ Hours of HD Videos
23 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
BLACKMAGIC FUSION Course Bundle - 10 Courses in 1
26+ Hour of HD Videos
10 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
DAVINCI RESOLVE Course Bundle - 4 Courses in 1
28+ Hours of HD Videos
4 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
FL STUDIO Course Bundle - 2 Courses in 1
18+ Hours of HD Videos
2 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
MAGIC BULLET LOOKS Course Bundle - 2 Courses in 1
 7+ Hours of HD Videos
2 Courses
Verifiable Certificate of Completion
  Lifetime Access
4.5
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Bullet Points Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Bullet Points Excel Template

EDUCBA

डाउनलोड Bullet Points Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more