|

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

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...

DHCP vs Static IP: How to Set a Static IP or Enable DHCP in...

What is DHCP vs Static IP Address? This tutorial will compare the difference between DHCP vs Static IP addressing....
gmail archive

How to Archive and Unarchive Emails in Gmail

Introduction When you archive Gmail emails it helps to free up your inbox. In Gmail archived emails are moved...
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...

Get Help With File Explorer in Windows 10

Introduction Need to get help with the new file explorer in Windows 10? You are in the right place....

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

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...

Powershell For Loop Explained: Syntax and Examples

Introduction "Powershell For Loop" (or Statement) is a construct that is used to run a command in a...
Amazon Baby Registry

Amazon Baby Registry: Your Definitive Guide

Introduction Amazon Baby Registry allows expectant mothers to create a list of items they need for their baby. Friends...
Windows Cannot Find GPEDIT.MSC or GPEDIT.MSC Not Found [Fixed]

Windows Cannot Find GPEDIT.MSC or GPEDIT.MSC Not Found [Fixed]

Introduction If you try opening gpedit.msc from Windows 10 Home you will receive the error message windows cannot find...
How to Make a Line Graph in Google Sheets

How to Make a Line Graph in Google Sheets

Introduction You can represent your data visually using a line graph in Google Sheets. This guide demonstrates how to...

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