WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Bullet Points in Excel

Bullet Points in Excel

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

How to Add Bullet Points in Excel? (Top 5 Methods)

Bullet points in excel are actually symbols which are used to represent text or numbers in a format of the list, we can use various keyboard shortcuts to insert bullet points in excel such as ALT+7 from the numeric keyboard for a solid bullet point, or we can use the edit tab to insert a bullet point in excel.

Below is the list of Top 5 Methods to Insert Bullet Points in Excel

  1. Using Keyboard Shortcut
  2. Using Symbol Menu
  3. Copying a Bullet List from Word File
  4. Using Excel Formula
  5. Creating Custom Bullet Points

Now let us discuss each of the methods in detail along with an example

bullet-points-in-excel

#1 Inserting Bullet Points using Keyboard Shortcuts

The fastest way to insert a bullet point is by using a keyboard shortcut.

Select the cell in which you want to insert the point, then press the Alt + 7 or Alt + 0149 for a solid bullet.

There are many different types of the fancy bullet we can insert in excel.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

bullet points in excel example 1.1

To copy the bullet into other cells, we can drag the fill handle to copy it to the alongside cells.

bullet points in excel example 1.2

The cells which are not adjacent, we can copy-paste the bullet point to it by copying the bullet using Ctrl + C and press Ctrl + V in order to paste the copied bullet.

#2 Adding Bullet Point in Excel Cell using Symbol Menu

If you don’t have a Numpad or don’t remember the key combination, using the symbol menu is the quickest way to insert bullet points.

  • Step 1: Click on the Insert tab, then select the Symbols group at last and click on

bullet points in excel example 2.1

  • Step 2: A symbol dialog box will appear on the screen

bullet points in excel example 2.2

  • Step 3: Select the cell in which you want to insert the bullet point.
  • Step 4: Click on the symbol you would like to use for a bullet point.

bullet points in excel example 2.3

  • Step 5: Click on the Insert button to insert.

bullet points in excel example 2.4

Now that the Symbol will be inserted in the selected cell.

#3 Copying a Bullet List from Word File

Suppose we have already created a bullet list in Word, we can copy all the lists and can paste it in the Excel.

  • Step 1: Simply select the bullet list in Word.

bullet points in excel example 3.1

  • Step 2: Press Ctrl + C to copy it.

bullet points in excel example 3.2

  • Step 3: Select the cell in which you want to insert the bullet point in excel.
  • Step 4: To paste the list, press Ctrl + V. This will paste all the lists along with the bullet points.

bulletpoints in excel example 3.3

bulletpoints in excel example 3.4

#4 Inserting Bullet Points in Excel Cell using Excel Formula

Suppose, at the same time, we want to insert multiple bullet points, we can use CHAR Function in Excel.

CHAR function will return the specific character based on a set of charters used by the computer.

As we have seen above that code 0149 is used for the round filled bullet. So here it goes with the CHAR formula:

  • Step 1: Select the cells where you want to fill the bullet.
  • Step 2: Write the =CHAR function

bulletpoints in excel example 4.1

  • Step 3: Write the number 149, then close the round bracket and press the enter key.

bulletpoints in excel example 4.2

#5 Creating Custom Bullet Points in Excel

Custom number format will help you spare the difficulty of inserting bullet points again and again and help you to automatically insert the bullet points.

Let’s see how this custom bullet format works:

  • Step 1: Select the cell where you want to insert the bullet point.
  • Step 2: Choose Format cells from the Context menu by clicking the right button of mouse or press Ctrl + 1.
  • Step 3: Select the Number tab and click on custom from category.

bulletpoints in excel example 5.1

  • Step 4: Under the type text box, write “Bullet point” or Alt+7 and write ‘@’ as a text place holder.

bulletpoints in excel example 5.2

  • Step 5: Then click OK; it will add a bullet point in the cell.

Things to Remember

  • Bullet points are used to display key features of some issues.
  • It is used when the order of the list is not important.

Recommended Articles

This has been a guide to Bullet Points in Excel Cell. Here we discussed how to add Bullet Points in Excel cells using various methods with examples. You can learn more about excel functions from the following articles –

  • $ symbol in Excel
  • Change Case in Excel
  • Excel Drop Down List
  • SIN Excel Function
3 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More