Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Custom Formatting for bullet points in MS Excel

How to work with Bullet Points in Microsoft Excel ?

Tutorial in Brief

It’s a one-time setup. All you have to do is to create a custom format to insert bullet points. Just follow these simple steps.

  • Press Ctrl + 1 and you will get a format dialog box.
  • Under the number tab, select custom.
  • In the type input bar, enter the following formatting.

● General;● General;● General;● General

  • In the type input bar, enter the following formatting.

Use Custom Formatting To Insert Bullet Point In Excel

How this Works in MS Excel ?

Let us give you a short note to use custom formatting for bullet points. In custom formatting, you have to mention 4 different formats from positive, negative, zero, and text. We have used a black dot for all these four types. And now, when you insert a text or any number whether positive or negative, it will add a bullet in front of it.

More ways to work with Bullet Points in MS Excel

Below are the summarized list of processes you can follow to add and work with Bullet points in excel –



Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes