4 Easy Ways to Insert Bullet points in Excel

-

|

Introduction

Inserting bullet points in excel is not as straightforward as adding bullet points in Word. This guide demonstrates 4 easy ways you can insert bullet points in excel.

Below are the methods for Inserting bullet points in excel discussed in this guide:

  1. Insert Bullet Points in Excel from the Symbol Menu
  2. Add Bullet Points in Excel Using Keyboard shortcuts
  3. By Copying Bullet Points from Word or a Web page
  4. Using Excel Formula
Advertisement

Method 1: Insert Bullet Points in Excel From the Symbols Menu

To add bullet point using this method, follow the steps below:

  • Open Excel and click the cell you wish to insert bullet points. Then click the Insert tab.
bullet points in excel from the Symbol menu
  • Next, click the drop-down below Symbols menu and select Symbol.
  • When the Symbol options opens, from the Subset drop-down, select General Punctuation. Then click on the bullet point you want to use and click Insert. To close the Symbols options, click Close (See the second image below).
Bullet point inserted!
  • To copy the bullet point to other cells, click on the cell containing it. Then move your mouse towards the button right of the cell. When the white + sign turns to black, drag the cell to other cells below it. The bullet points will copy to other cells. See the second image below.
bullet points in excel - copy bullet points
Advertisement
bullet points in excel - copy bullet points

Method 2: Insert Bullet Points in Excel Using Keyboard shortcuts

You must use a numeric keypad for this to work. A numeric keypad is a portion of your keyboard (on the right hand side) with numbers.

To insert a solid bullet point, press the following keyboard combination

Alt + 7 

Or

Alt +  0149

This will insert a bullet point similar to the one in the image below:

Insert Bullet Points in Excel Using Keyboard shortcuts

To insert non-solid bullet point, use this keyboard combination

Alt + 9

Here is the bullet point the above keyboard combination inserts.

Insert Bullet Points in Excel Using Keyboard shortcuts

How to Use On-screen Keyboard for Excel Shortcuts

If your laptop does not have numeric keypad, use on-screen keyboard. On Windows 10, you can enable on-screen keyboard from Start > Settings > Ease of Access > Keyboard. Then click the On button below Use on-screen keyboard.

On-screen keyboard will load.

To enable numeric keypad, click Options. Then check Turn on numeric key pad and click Ok.

Numeric keyboard now available in your on-screen keyboard.

To use the keyboard shortcuts described in Method 2 above, click NumLock. This will show the numeric keypad. You can then insert bullet points using Alt + 7 as described earlier in the previous section.
Advertisement

Method 3: Insert Bullet Points in Excel By Copying Bullet Points from Word or a Web page

Another easy way to insert a bullet point in Excel is to copy the bullet point from Word or a web page then paste it in Excel.

Here are the steps:

  • Insert the bullet point you want to copy in Microsoft Word. Select the bullet point and copy it with either Ctrl + C or right-click and copy.
  • Then paste it in Excel.
To insert a bullet point in Word, open Microsoft Word. Next, click Insert tab. Then click Symbols. Next, click Symbol and select the symbol you wish to use for your bullet point.
Insert Bullet Points in Excel Using By Copying Bullet Points from Word or a Web page
You can repeat the above steps to copy a bullet point from a web page.

Method 4: Insert Bullet Points in Excel Using Excel Formula

In the last section of this guide I will discuss how to insert bullet points using formula. The CHAR function is used to insert bullet points and other special characters.

Syntax of the CHAR function

CHAR (number) 

Number is a number between 1 and 255. Each number will insert a special symbol in Excel.

To create a solid bullet list, use this formula:

=CHAR(149) 
Method 4: Insert Bullet Points in Excel Using Excel Formula - CHAR function

If you have a list of words in excel and wish to create a bullet list with those words, use the formula:

=CHAR(149)&" "&C3

C3 is the cell containing the word.

To include all the words in column C, drag the formula from B3 down.

For a list of CHAR numbers and their symbols, click Windows-1252 (for Windows). For MAC, click Mac OS Roman.

Conclusion

In this guide I discussed 4 ways you can insert bullet points in Excel. I hope you were able to use of them. If you have any question or comment use the “Leave a Reply” form at the end of the page.

Alternatively, you could share your experience making Excel bullet points so other readers can benefit from it.

Other Helpful Guides

Additional Resources and References

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 19H2 Preview Build

Introduction If you are a member of Windows 10 Insider Program you can install Windows 10 19H2 Preview Build....

How to Sign in to Windows 10 with a Microsoft Account

Introduction When you installed Windows 10 you may have created and signed in with a local account. You can...
Disable IPv6 in Windows 10

How to Disable IPv6 in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to disable IPv6 in Windows 10: Disable IPv6 from...

Advertisement

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

Advertisement

BEST OF ITECHGUIDES

windows update stuck featured

How to Get Windows Update to Work If Download is Stuck at 0%

Experiencing Windows Update stuck at 0%? Have you waited for hours already, yet to progress? You are not alone! A lot of...
Excel Not Equal

Excel “Not Equal” Comparison Operator: Syntax, Examples

Introduction Excel "Not Equal" is a Comparison operator that compares two values. "Not Equal" will return TRUE if the...

How to Fix “Your PC Ran into a Problem and Needs to Restart” in...

Introduction "Your PC Ran into a Problem and Needs to Restart" in Windows Server 2016 error may be caused...
mobile hotspot greyed out windows 10

Mobile Hotspot Greyed Out on Windows 10, iPhone or Android [Fixed]

Introduction If mobile hotspot is greyed out on windows 10, iPhone or Android it is likely that you do...
this accessory may not be supported

This Accessory May Not be Supported [Fix]

What Does This Accessory May Not be Supported Mean? You may receive "this accessory may bot be supported" error...

RECENT POSTS

How to Enable Hyper-V in Windows 10 (3 Methods)

How to Enable Hyper-V in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Hyper-V in Windows 10. To install Hyper-V...
RSAT Tools in Windows 10 Explained: Plus How to Install RSAT

RSAT Tools in Windows 10 Explained: Plus How to Install RSAT

Introduction Starting from October 2018 (1809) update, RSAT Tools became part of Windows 10. From this version of Windows...

How to Enable RSAT for Active Directory in Windows 10 (3 Methods)

Introduction This guide demos 3 methods to enable Active Directory in Windows 10. It is not exactly enabling "Active...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 1909 (19H2) Preview Build

Introduction Windows 10 1909 Preview is available for Windows Insiders. Made available early September, 2019 you have to be...
How to Install RSAT in Windows 10 (3 Methods)

How to Install RSAT in Windows 10 (3 Methods)

Introduction This guide demos how to Install RSAT in Windows 10. Starting with Windows 10...

How to Share a Folder in Windows 10 (3 Methods)

Introduction This guide demos how to share folder in windows 10. It covers 3 methods. Options...
Configure Map Network Drive with Group Policy

Map Network Drive in Windows 10 with Group Policy

Introduction This guide demos how to map network drive with group policy. This guide is...

How to Map Network Drive in Windows 10 (5 Methods)

Introduction This guide demos 5 methods to Map Network Drive in Windows 10. Options to...
How to Download Windows 10 ISO with Media Creation Tool

How to Download Windows 10 ISO with Media Creation Tool

Introduction This guide demos the steps to download Windows 10 ISO. You can download Windows 10 ISO with Media...

How to Install Windows 10 from Network Boot (Via WDS Server)

Introduction This guide demos how to install Windows 10 from network boot. The steps discussed in...

Advertisement

MUST READ

PortalOffice365

Portal Office 365: Your Ultimate Guide to Office 365 Admin Portal

What is PortalOffice365? PortalOffice365 (portal.office.com) is a Microsoft cloud-based portal that allows administrators to create and manage users and...
Install Active Directory Role in Server 2016 and Promote to DC

How to Install Active Directory Role in Server 2016 and Promote to DC

Introduction This guide demos how to install Active Directory in Server 2016. It also covers how to promote the...
Microsoft Edge is not in group policy

How to to Make Microsoft Edge Policy Available in Group Policy

Introduction When I was writing How to Set Homepage in Microsoft Edge I realized that Microsoft Edge is not...
dhcp relay agent windows server 2016 not working

DHCP Relay Agent Windows Server 2016 Not Working [Fixed]

Introduction Most reports about DHCP relay agent not working in Windows Server 2016 has to do with clients in...
what is active directory

What is Active Directory (Top 50 AD Questions Answered)

Introduction This article answers the question - What is Active Directory and 49 other most widely asked AD questions....

By using this website you agree to accept our Privacy Policy and Terms & Conditions