Free tools Windows power users keep installed
One-click scans. No signup required.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
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.
Option 1: Insert Bullet Points From the Symbols Menu
To add bullet points using this method, follow the steps below:
- Open Excel and click the cell you wish to insert bullet points. Then click the Insert tab.
- 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).
- 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.
Option 2: Add Bullet Points Using Keyboard Shortcuts
To insert a solid bullet point, press the following keyboard combination
Recommended Free Tools
Alt + 7
Or
Alt + 0149
This will insert a bullet point similar to the one in the image below:
Popular on Amazon
- Easy Setup: Simply insert the nano USB receiver into your computer and use the keyboard instantly.
- Ergonomic design: Scissors X structure gives you the comfortable typing experience, low-profile keys offer quiet and comfortable typing.
- 6-Month Battery Life: Rechargeable lithium battery with an industry-high capacity lasts for 6 months with single charge (based on 2 hours non-stop use per day).
- Ultra Thin and Light: Compact size (16.7 X 4.5 X 0.24in) and light weight (17.4oz) but provides full size keys, arrow keys, number pad, shortcuts for comfortable typing.
- Package contents: Arteck 2.4G Wireless Keyboard, nano USB receiver, USB-C charging cable, welcome guide, our 24-month warranty and friendly customer service.
To insert non-solid bullet point, use this keyboard combination
Alt + 9
Here is the bullet point the above keyboard combination inserts.
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.
Also popular on Amazon
- Full-Size Layout: This Lenovo 305 USB-C keyboard offers a complete, full-size layout with a numeric keypad, making it ideal for data entry, calculations, and spreadsheets
- Slim and Stylish: Ultra-thin design with low-profile keys delivers a modern, sleek look without compromising on typing comfort. Perfect for minimalist workspaces
- USB-C Connectivity: Features a USB-C connection for fast, reliable data transmission, offering plug-and-play convenience with modern devices including laptops, PCs, and tablets
- Durable and Responsive: Built to last, the Lenovo 305 keyboard is made with high-quality materials and features robust keys, offering excellent tactile feedback for long-lasting use
- Versatile Functionality: Includes dedicated function keys, Windows keys, and multimedia controls, enhancing your productivity with every keystroke
The 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.
Option 3: Insert Bullet Points by Copying Bullet Points
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.
Also popular on Amazon
- Easy Setup: Simply insert the nano USB receiver into your computer and use the keyboard instantly.
- Ergonomic design: Stainless steel material gives heavy duty feeling, low-profile keys offer quiet and comfortable typing.
- 6-Month Battery Life: Rechargeable lithium battery with an industry-high capacity lasts for 6 months with single charge (based on 2 hours non-stop use per day).
- Ultra Thin and Light: Compact size (16.9 X 4.9 X 0.6in) and light weight (14.9oz) but provides full size keys, arrow keys, number pad, shortcuts for comfortable typing.
- Package contents: ALLIFE Stainless 2.4G Wireless Keyboard, nano USB receiver, USB charging cable, welcome guide, our 24-month warranty and friendly customer service.
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.
Option 4: Add Bullet Points 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.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →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) 
If you have a list of words in excel and wish to create a bullet list with those words, use the formula:
Also popular on Amazon
- All-day Comfort: This USB keyboard creates a comfortable and familiar typing experience thanks to the deep-profile keys and standard full-size layout with all F-keys, number pad and arrow keys
- Built to Last: The spill-proof (2) design and durable print characters keep you on track for years to come despite any on-the-job mishaps; it’s a reliable partner for your desk at home, or at work
- Long-lasting Battery Life: A 24-month battery life (4) means you can go for 2 years without the hassle of changing batteries of your wireless full-size keyboard
- Simply plug the USB receiver into a USB port on your desktop, laptop or netbook computer and start using the keyboard right away without any software installation
- Simply Wireless: Forget about drop-outs and delays thanks to a strong, reliable wireless connection with up to 33 ft range (5); K270 is compatible with Windows 7, 8, 10 or later
=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 use to add bullet points in Excel. I hope you were able to use one of them to meet your goal.
Also popular on Amazon
- Compact, Clutter-Free Design: Streamline your workspace with the Lenovo 100 Wireless Compact Keyboard. Its slim, space-saving design fits neatly on any desk and easily stores away for hybrid workers and flexible office setups
- Effortless Productivity Boost: Work smarter with 11 Fn shortcut keys for instant access to essential functions. Quickly navigate between apps, control media, and manage your tasks to stay focused and efficient all day
- Dedicated Numeric Keypad: Enjoy fast, accurate number entry with a built-in numeric keypad. Whether you're handling budgets, spreadsheets, or reports, this keyboard delivers precision and speed for data-driven tasks
- Whisper-Quiet Typing Experience: Stay focused in shared spaces with silent key clicks operating at just 45 dB. Type comfortably without disturbing coworkers, classmates, or family in open offices or study sessions
- Reliable Wireless Performance: Plug and play functionality with the included USB nano receiver offers a seamless, cordless connection with no setup required. Powered by a single AA battery for extended use
Let us know your thoughts by responding to the “Was this page helpful” question below. Alternatively, use the “Leave a Reply” comments form at the bottom of this page.
You could also use the “Was this page helpful?” buttons below to give us your feedback.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
