|

FEATURED POSTS

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...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...
ForEach-Powershell

PowerShell ForEach: Syntax, Parameters, Examples

What is PowerShell ForEach? PowerShell ForEach (ForEach PowerShell) is a PowerShell construct used in iterating through values in a...

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...
PowerShell vs CMD

Powershell vs CMD: Differences and Similarities Compared

Introduction This short guide compares PowerShell vs CMD (Windows command prompt). I will cover the history and nature of...
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...

BEST OF ITECHGUIDES

Gmail Mark All as Read: How to Mark all Emails as Read on Gmail

How to Mark all Emails as Read on Gmail

Introduction If you receive a lot of emails that you do not wish to read, you may want to...
How to Check Windows 10 Version

How to Check Windows 10 Version in 4 Easy Ways

Introduction Wondering how you can check your version of Windows 10? Here are 4 easy ways for you -...
GPResult Command

GPRESULT Command: Syntax, Parameters, Examples

What is GPRESULT? GPRESULT is a command line tool that displays the Resultant Set of Policy (RSoP) information for...
how to make Pivot Table

How to Make a Pivot Table in Excel

Introduction A Pivot Table allows you to analyze, summarize and calculate large data to help find relationships. With a...

Change User Name and Rename User Folder in Windows 10

Introduction There are so many reasons why you may want to change user name in Windows 10 or rename...

RECENT POSTS

how to merge cells in excel

How to Merge Cells in Excel in 2 Easy Ways

Introduction You can merge two Cells in Excel using CONCATENATE function or the “&” (ampersand) operator. Though Excel has...
How to Make a Pivot Table in Google Sheets

How to Make a Pivot Table in Google Sheets

Introduction You can make a Pivot Table in Google Sheets to simplify analysis of complex data. A Pivot Table...
how to make Pivot Table

How to Make a Pivot Table in Excel

Introduction A Pivot Table allows you to analyze, summarize and calculate large data to help find relationships. With a...
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....
RAID 5 vs RAID 6

RAID 5 vs RAID 6: Differences, Benefits and Disadvantages

What is RAID 5 vs RAID 6? RAID 5 and RAID 6 uses striping with distributed parity technique. However,...
concatenate excel

Concatenate in Excel: How to Concatenate Columns and Strings

What is Concatenate in Excel? Concatenate in Excel is joining two strings into one continuous string. You can join...

How to Add in Excel (Excel Sum) with Examples

Introduction There are different ways to add numbers in Excel. You could simply select the cells containing the data....
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,...
powershell.exe -command

Powershell.exe Command: Syntax, Parameters and Examples

Introduction You may be wondering why write on Powershell.exe Command. Are there special commands for Powershell.exe? Yes! When you...
how to move columns in excel

How to Move Columns to Rows and Rows to Columns in Excel

Introduction If you receive some Excel data in columns, you can easily move the columns to rows in Excel...

MUST READ

Excel Substring: How to Get (Extract) Substring in Excel

Introduction An Excel substring is a portion of a text in a cell. For instance, if a cell contains...
Windows defender blocked by Group Policy

Windows Defender Blocked by Group Policy [Fixed]

Introduction If you receive the error message Windows Defender is blocked by group policy, your computer may have been...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
dropbox login

Dropbox Login: Your Ultimate Guide to Dropbox

Introduction Dropbox login allows you to sign in to and use Dropbox. But what is Dropbox? Let's kick off...
How to Make a Scatter Plot in Excel

How to Make a Scatter Plot in Excel

Introduction You make a scatter plot in Excel to compare 2 sets of data. Unlike a Line Chart, a...

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

YOU MAY ALSO LIKE:

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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