EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Excel Bullet Points
Secondary Sidebar
Excel Functions
  • Excel Tips
    • Recover Document in Excel
    • Excel Shortcut to Select Row
    • Excel Header Row
    • Excel Insert Button
    • Excel Translate
    • Budget in Excel
    • KPI Dashboard in Excel
    • Blank Invoice Excel Template
    • Write Formula in Excel
    • Auditing Tools in Excel
    • Autofit Row Height in Excel
    • Formatting Text in Excel
    • Add Rows in Excel Shortcut
    • Divide Cell in Excel
    • Compare Two Columns in Excel for Matches
    • Excel Troubleshooting
    • Unprotect Excel Workbook
    • Subtract Date in Excel
    • Carriage Return in Excel
    • Negative Numbers in Excel
    • Worksheets in Excel
    • Excel Match Multiple Criteria
    • Exponential Moving Average Formula
    • Sentence Case in Excel
    • Excel Reverse Order
    • Excel Timesheet Template
    • Weighted Average in Excel
    • CTRL Shift-Enter in Excel
    • Excel Expense Tracker
    • INDEX MATCH Function in Excel
    • Percent Change in Excel
    • Drag and Drop in Excel
    • Shade Alternate Rows in Excel
    • Excel Database Template
    • Inverse Matrix in Excel
    • New Line in Excel Cell
    • Format Cells in Excel
    • Excel Text with Formula
    • Project Management Template in Excel
    • Vlookup vs Index Match
    • Embedded in Excel
    • Count Colored Cells in Excel
    • Excel Hacks
    • Column Header in Excel
    • Database Function in Excel
    • Excel Spell Check
    • Linear Interpolation in Excel
    • Convert Excel to CSV
    • Excel Not Responding
    • Delta Symbol in Excel
    • Excel Mortgage Calculator
    • Excel Show Formula
    • Break Links in Excel
    • VLOOKUP Examples in Excel
    • Alternate Row Color Excel
    • Checklist in Excel
    • Microsoft Office Tips
    • Excel vs Access
    • Excel Change Case
    • Count Characters in Excel
    • Formula Bar in Excel
    • Invoice Template in Excel
    • Find and Replace in Excel
    • PowerPivot in Excel
    • Wildcard in Excel
    • Line Break in Excel
    • NULL in Excel
    • Text Formula in Excel
    • Family Tree in Excel
    • Insert Calendar in Excel
    • Page Setup in Excel
    • Search For Text in Excel
    • Switching Columns in Excel
    • 3D Cell Reference in Excel
    • Roadmap Template in Excel
    • Cell References in Excel
    • Excel Automation
    • Matching Columns in Excel
    • Evaluate Formula in Excel
    • How to Find Mean in Excel
    • How to Add Cells in Excel
    • Project Timeline in Excel
    • TODAY Formula in Excel
    • Poisson Distribution in Excel
    • YEAR Formula in Excel
    • REPLACE Formula in Excel
    • Create Spreadsheet in Excel
    • SEARCH Formula in Excel
    • HYPERLINK Formula in Excel
    • Pivot Table with Multiple Sheets
    • COLUMNS Formula in Excel
    • DAY Formula in Excel
    • RIGHT Formula in Excel
    • INDIRECT Formula in Excel
    • Excel IRR Formula
    • Pivot Table Sort
    • OR Formula in Excel
    • Pivot Table Formula in Excel
    • How to Edit Drop Down List in Excel?
    • WEEKDAY Formula in Excel
    • Chart Wizard in Excel
    • Time Difference in Excel
    • Lookup Table in Excel
    • SUBTOTAL Formula in Excel
    • LOOKUP Formula in Excel
    • Themes in Excel
    • Group Worksheets in Excel
    • Excel ISNUMBER Formula
    • 3D Maps in Excel
    • VLOOKUP Tutorial in Excel
    • Moving Columns in Excel
    • Grouping Columns in Excel
    • Excel Formula of Percentage
    • Excel Leading Zeros
    • Timesheet in Excel
    • Nested IF Formula in Excel
    • SUMIF Formula in Excel
    • Concatenation in Excel
    • Excel Insert Page Break
    • LEN Formula in Excel
    • Insert Comment in Excel
    • Excel Print
    • Fractions in Excel
    • Excel Add a Column
    • Borders in Excel
    • Excel Sum by Color
    • Excel vs Google Sheets
    • Calculate Percentage Increase in Excel
    • Excel Format Phone Numbers
    • Excel Search Box
    • Excel vs CSV
    • Excel vs Numbers
    • Excel Concatenate Date
    • Excel Bullet Points
    • Calculate Compound Interest in Excel
    • Find External Links in Excel
    • Excel Comma Style
    • Excel Remove Leading Spaces
    • Combine First and Last Name in Excel
    • How to Calculate Ratio in Excel
    • SUMPRODUCT Function with Multiple Criteria
    • Create Excel Template
    • Excel Greater than or Equal
    • Excel Keyboard Shortcuts
    • Excel Row vs Excel Column
    • Excel Operators
    • Excel Text Compare
    • Excel Uppercase Function
    • Excel Auto Numbering
    • Watermark in Excel
    • Excel Delete Row Shortcut
    • Excel Word Count
    • Row Count in Excel
    • Excel Grade Formula
    • Excel Percentage Difference
    • Excel Rows and Columns
    • Excel Group
    • Excel Move Columns
    • Excel Row Height
    • Excel Sparklines
    • Excel Drawing a line
    • Multiple IFS in Excel
    • Excel Strikethrough
    • Numbering in Excel
    • Share Excel Workbook
    • Excel Shortcut For Merge Cells
    • Excel OneDrive
    • Excel Track changes
    • Excel Hide Formula
    • Excel Filter Shortcuts
    • Excel 3D Reference
    • Protect Excel Workbook
    • Excel Moving Averages
    • Excel Row Limit
    • Excel Absolute Value
    • Excel Print Area
    • Excel Format Painter
    • Excel Separate text
    • Excel Autofit
    • Excel Columns to Rows
    • Excel Paste Shortcut Option
    • Excel Rows to Columns
    • Excel Insert Row Shortcut
    • Excel Extensions
    • Excel Unmerge Cells
    • Divide in Excel Formula
    • Excel Compare Two Columns
    • Not Equal To Excel
    • Excel Remove Duplicates
    • Excel Remove Spaces
    • Excel Calculate Age
    • Copy Excel Sheet
    • Excel Conditional Formatting Based on Another Cell Value
    • Excel Cell Reference
    • Excel Split Cell
    • Excel Circular Reference
    • Highlight Every Other Row in Excel
    • Errors in Excel
    • Excel Delete Pivot Table
    • Excel Pivot Table
    • Subtraction in Excel
    • Count Unique Values in Excel
    • Excel Highlight Duplicates
    • Excel Data Formatting
    • Random Numbers in Excel
    • Basic Excel Formulas
    • Page Numbers in Excel
    • Excel CAGR Formula
    • Excel Combine cells
    • IFERROR with VLOOKUP in Excel
    • Column Sort in Excel
    • Print Comments in Excel
    • Cheat Sheet of Excel Formulas
    • Remove Hyperlinks in Excel
    • Excel Drop Down List
    • Remove (Delete) Blank Rows in Excel
    • Relative Reference in Excel
    • Subscript in Excel
    • Superscript in Excel
    • Excel Insert Multiple Rows
    • Excel Absolute Reference
    • Unhide Columns in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL COURSE
  • Online Excel Data Analysis Course
  • Excel for Finance Course

Excel Bullet Points

By Madhuri ThakurMadhuri Thakur

Bullet Points in Excel

Excel Bullet Points (Table of Contents)

  • Introduction to Bullet Points in Excel
  • How to Add 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.

But the major drawback is that creating the bulleted list in Excel isn’t as straightforward as it is in Word Document 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. In fact, there are 6 different ways to use it.

How to Add Bullet Points in Excel?

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

Start Your Free Excel Course

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

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.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,452 ratings)
  • 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 need to use your numeric keypad for using the numbers key with Alt-tab. If you are working on a laptop, you may need to use different shortcuts.

Usually, Solid and empty bullets are used, but if you want to add some fancy bullet points in excel, you can add square or arrow 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 symbol, a dialog box will open; Font Calibri will automatically get selected in the Font Dropdown, but you can select any font, and then select the bullet symbol you want to use and 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, 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; after selecting the symbol, a dialog box will appear. Next, we will select the Bullet symbol and select Insert.
  • The bullet will be inserted in a column, and you can update the name of the student.

Recently Used Symbols

  • A bullet is inserted in Column B3 & now you can type the name of a student. 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 that corresponds to that code 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 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 already have a list of items in one column without the bullet. To copy the formula in other columns, you can then drag the AutoFill box in the lower-right corner of the cell and scroll it down till where 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 it 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 shown 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, as shown in the above screenshot. 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 and then space and then @ character and Click OK.

Bullet points example 4-3

  • Now, 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, which was only Little Elly School, remains the same.

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.
  • Using the same function, we have added the data on all the 15 cells with the school names. 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 the word with Bullet Points and 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 in the Excel sheet.

Note: You can either double click the cell or press F2 before pasting the data for getting 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 any other above methods and enter the text you want to enter.
  • 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 and not for confusion, so you should avoid using more bullets and sub-bullets.
  • Never have only one bullet. However, if you have a list of information, then 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 methods in Excel along with 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
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Finance Training (18 Courses, 7+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • 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

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

EDUCBA
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

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

EDUCBA Login

Forgot Password?

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

EDUCBA
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

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

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

Let’s Get Started

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

EDUCBA

Download Bullet Points Excel Template

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