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

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...
hard drive not detected

How to Fix Hard Drive not Detected Problem

Introduction Some Windows users have experienced a situation where a hard drive is not detected after upgrading to Windows...
How to Change Outlook Password in 3 Different Ways

How to Change Outlook Password in 2 Easy Steps

Introduction Before you change your Outlook Password you have to first change it with your email provider. The reason...
powershell delete folder or File

How to Delete Folders or Files in PowerShell

Introduction You can delete folders and files in PowerShell using the Delete method or Remove-Item Cmdlet. This guide shows...
7 Ways to open Control Panel in Windows 10

7 Ways to open Control Panel in Windows 10

Introduction This guide demos 7 ways to open Control Panel in Windows 10. Options to...

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

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...
remove login password in Windows 10

How to Remove Login Password in Windows 10

Introduction Want to remove login password in windows 10? You are not alone! Apparently, a reasonable...
RAID 3 (Redundant Array of Independent Disks) Explained

RAID 3 (Redundant Array of Independent Disks) Explained

What is RAID 3? RAID 3 is a RAID implementation that uses striping with a dedicated parity disk....
Excel Count

Excel Count: How to Count in Excel With Examples

Introduction Excel COUNT Function is used for counting items in a worksheet. Excel COUNT also has the conditional function,...
file too large for destination file system

The File is Too Large for the Destination File System [Fixed]

Introduction The "The File is Too Large for the Destination File System" error message comes up when you try...

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