Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Bullet points in excel are actually symbols which are used to represent text or numbers in a format of list, we can use various keyboard shortcuts to insert a 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.
Bullet Points in Excel (Table of Contents)
- Bullet Points
- Using Keyboard Shortcut
- Using Symbol Menu
- Copying from Word File
- Using Excel Formula
- Creating Custom Bullet Points
Excel Bullet Points
In this article, we are going to discuss what are the Bullet points in Excel, what are their uses and where they are used? As we know that Microsoft Excel is mainly used for numerical data but it is also used to work with data having text such as to-do list, bulletin boards workflows, etc. So it’s really important to represent the information in the right way. And this can be done by making steps or lists using the bullet points so it would be easier to read the information.
Bullet points can be utilized to feature key issues. We would use the bullet points when it’s not vital that things on the list are in a specific order. There are many different ways in which we can use the bullet point to highlight text data or key issues. Sometimes, the bullet list starts with the capitalize word but don’t have a full stop.
School is organizing a trip next Thursday, children will need to bring:
- Packed lunch and drink
- Trainers or walking shoes
- Notebook and pen
- Waterproof clothing in case of rain
Unfortunately, Excel doesn’t provide the in-built characteristic for bullet points like the Mircosoft Word do. In any case, that doesn’t mean there is no real way to embed bullet points in Excel. There are different ways to insert bullet points in Excel.
How to Add Bullet Points in Excel?
Let’s see some simple examples of how to insert bullet points in excel.
Add Bullet Points – Example #1
Inserting Bullet Points using Keyboard Shortcuts
The fastest way to insert a bullet point is a keyboard excel 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 fancy bullet we can insert in excel.
To copy the bullet into other cells we can drag the fill handle to copy it to the alongside cells.
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.
Add Bullet Points – Example #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.
- Click on the Insert tab, then select the Symbols group at last and click on
- A symbol dialog box will appear on the screen
- Select the cell in which you want to insert the bullet point.
- Click on the symbol you would like to use for a bullet point.
- Click on Insert button to insert.
Now that the Symbol will be inserted in the selected cell.
Add Bullet Points – Example #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.
- Simply, select the bullet list in Word.
- Press Ctrl + C to copy it.
- Select the cell in which you want to insert the bullet point in excel.
- To paste the list press Ctrl + V. This will paste all the lists along with the bullet points.
Add Bullet Points – Example #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.
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:
- Select the cells where you want to fill the bullet.
- Write the =CHAR function
- Write the number 149, then close the round bracket and press enter key.
Add Bullet Points – Example #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 in Excel.
Let’s see how this custom bullet format works:
- Select the cell where you want to insert the bullet point.
- Choose Format cells from Context menu, by clicking the right button of mouse or press Ctrl + 1.
- Select the Number tab and click on custom from category.
- Under the type text box write “Bullet point” or Alt+7 and write ‘@’ as a text place holder.
- Then click OK, it will add bullet point in the excel cell.
Things to Remember
- Bullet points are used to display key features of some issue.
- It is used when the order of the list is not important.
This has been a guide to Bullet Points in Excel Cell. Here we discussed how to add Bullet Points in Excel cell using various methods with examples. You can learn more about excel functions from the following articles –