Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Insert Bullet Points in Excel? 5 Easy Methods

How to Insert Bullet Points in Excel? 5 Easy Methods

(Note: This guide on how to insert bullet points in Excel is suitable for all Excel versions including Office 365)

Using bullet points is a great way to list important things in any document. We use them all the time in our reports and PowerPoint presentations. But, have you ever wondered how to add bullet points in Excel?

Well of course it is possible and easy to insert bullet points in Excel. In fact, you can insert multiple bullet points into a single cell, or in separate cells.

In this article, I’ll show you 5 easy ways to add bullet points in Excel.

You’ll learn to insert bullet points by

  • Using the ALT key
  • Using the Insert Tab
  • Using CHAR formula
  • Using Custom Formatting
  • Copy and Paste from Word or PowerPoint

Watch this short video on How to Insert Bullet Points in Excel

Related:

How to Split Cells in Excel? 3 Easy Methods

How To Find Duplicates In Excel? The Best Guide

How to Unmerge Cells in Excel? 3 Best Methods

Insert Bullet Points in Excel Using the ALT key

This is one of the easiest methods to insert a bullet point in Excel. But, it only works if you have a separate numeric pad on your keyboard.

To insert bullet points using the ALT key, select the cell where you want to insert the bullet point.

Select the cell where you want to insert bullet points
Select the cell where you want to insert bullet points

Now, hold the ALT key and press 7 (or) 9. Once you leave the ALT key, the bullet appears.

Press ALT+7 or ALT+9 to insert a bullet point in Excel
Press ALT+7 or ALT+9 to insert a bullet point in Excel

Here are some other tips while using ALT to enter bullet points:

ALT + 7 gives a different type of bullet(normal bullet), whereas ALT + 9 gives another type of bullet(hollow bullet). Similarly, adding bullets using ALT + 5 or ALT + 6 gives you different types of bullets.

ALT + Number Combo
ALT + Number Combo

You can also add a list within a cell. That is, adding bullets in the same cell one after the other. To make a line break within a cell, hold ALT+ Enter.

Insert a line break using ALT+Enter
Insert a line break using ALT+Enter

You can add bullets to cells that already contain data. Double click on the cell to enter into edit mode. Place the cursor in the desired position to insert the bullet. Press ALT + 7 or ALT + 9.

You can drag the fill handle to copy the bullets points to adjacent cells.

Drag using the fill handle to duplicate the bullet points
Drag using the fill handle to duplicate the bullet points

Insert Bullet Points in Excel Using the Insert Tab

This is an alternate method to add a bullet point in a cell. In case you do not have a numeric keypad on your keyboard, you can insert bullet points by using the Insert option from the main menu.

Select the cell you want to add a bullet point.

Go to the Insert tab and click Symbols.

Go to Insert > Symbol

The Symbol dialog box opens.

There are a variety of bullet points for you to choose from here, based on fonts. Search for the type of bullet pointer you want. 

Click the drop-down and search for the bullet. 

Choose any appropriate font
Choose an appropriate font

Select the bullet point and click on Insert. 

Locate the bullet point and click Insert
Locate the bullet point and click Insert

Add the text next to the bullet. Or, add multiple texts in a single cell using a line break.

Create bullet point lists
Create bullet-point lists

Once, you have added the bullets. You can then copy and paste the bullets onto other cells and lists whenever you want.

Note: Instead of searching for the bullets in different fonts. You can use the default bullet by selecting the font as (normal text) and Character code as 2022 from Unicode(hex). 

Use the Character code as 2022 from Unicode(hex) to quickly locate the bullet point
Use the Character code 2022 from Unicode(hex) to quickly locate the bullet point

Also Read: 

How To Use Excel Countifs: The Best Guide

Excel Conditional Formatting -the Best Guide (Bonus Video)

The Best Excel Project Management Template In 2021

Insert Bullet Points in Excel Using the CHAR formula

If you are using Excel for some time, you will be aware of various shortcut formulas and their functionalities.

You can also use the formula method to insert a bullet point. This is mostly used when you have an existing list and want to add bullets to the list.

To insert bullets using the CHAR function. Select a cell you want to add bullets.

Use the formula =CHAR(149)&” “&(cell_reference) in the destination cell or the formula bar.

Here, (cell_reference) is the name of the cell where the bullet is to be added. In this case B12.

Use the CHAR formula to convert normal text into bullet points
Use the CHAR formula to convert normal text into bullet points

Drag the fill handle of the cell to add bullets to the other cells. 

Drag the fill handle to copy the formula to other cells
Drag the fill handle to copy the formula to other cells

Note: Change the CHAR number to add different types of bullet points based on your preferences. For example, =CHAR(150) inserts a hyphen. 

Change the CHAR code to insert other characters
Change the CHAR code to insert other characters

Insert Bullet Points in Excel Using Custom Formatting

This method is very helpful when you are working with huge lists and you have to add bullets very often.

To add a custom format. Select a cell or a group of cells. Right-click on the cells and select Format Cells. 

Right-click on any cell and choose Format Cells from the context menu.
Right-click on any cell and choose Format Cells from the context menu.

This opens up a dialog box. Select Number > Category: Custom.

In the Type bar, type • @. You can add the bullet point in the type bar by copying the bullet, or ALT + 7 method. Where @ is a variable.

Click Okay.

Type in .@ in the Custom category of the Number section
Type in [email protected] in the Custom category of the Number section

The text you add into the formatted cells will have bullet points. And, if you want to want to add bullet points to any other cells. Right-click > go to Format Cells > Custom > select •@ and click OK.

You can also drag the formatted cell to apply bullet points to the other cells.

Copy and Paste from MS Word or Powerpoint

If all this seems too much work for you, you can just copy and paste the list, or bullets from other Microsoft Word documents or PowerPoint presentations.

You can just copy the bullet points or you can copy the whole list.

Copy the bullet points from MS Word or PowerPoint
Copy the bullet points from MS Word or PowerPoint

Double click a cell to enter edit mode and paste the copied list. You can see the list populating a single cell with bullet points.

Paste the copied bullet points into Excel
Paste the copied bullet points into Excel

While copying and pasting, the selected list will be copied onto a single cell. If you want to split the list into separate cells, just click on the cell without going into edit mode. Right-click and paste (or) Ctrl + V to copy the list onto Excel.

Use the Ctrl+V shortcut to paste them into separate rows
Use the Ctrl+V shortcut to paste them into separate rows

Suggested Reads:

How to Extract an Excel Substring? – 6 Best Methods

Excel Quick Analysis Tool – The Best Guide (5 Examples)

How to Lock Cells in Excel?— 4 Best Methods with Examples

Let’s Wrap Up

In this guide, we saw five easy ways to insert bullet points in Excel. You can use the ALT key, Insert tab or use custom formatting to insert bullet points in Excel. Choose the method which suits you best and save time.

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Set Out Of Office in Outlook App? 2 Easy Methods

What’s New in QuickBooks 2013?

Automate Incoming Email in Outlook 2013

How to Use the Excel NOW Function? 3 Examples

The Most Used Access Shortcuts – Download

Microsoft Planner vs Project – The 5 Key Differences [2022]

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)