How to Insert Bullets or Numberings in Multiple Cells in Excel Office 365?
Tags: insertbulletornumber, kutools
Published: 2020-08-21 17:00:26

---
title: How to Insert Bullets or Numberings in Multiple Cells in Excel Office 365?
published: true
date: 2020-08-17 05:28:12 UTC
tags: InsertBulletorNumber,Kutools
canonical_url: https://geekexcel.com/how-to-insert-bullets-or-numberings-in-multiple-cells-in-excel-office-365/
---

## Insert Bullets or Numberings in Multiple Cells in Excel:

In this article, we are going to explore how to **Insert Bullets or Numberings in Multiple Cells in Excel 365** using **Kutools**. Because Kutools has a unique function to solve this task, which is **Insert Bullet** or **Insert**  **Numbering** Functions. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) is a third-party plugin. It has more than 120 features, used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
 

## Insert Bullets in Multiple Cells:

If you want to insert bullets in multiple cells, do as follows.

- You have to **select the range of cells** to insert bullets.

![Select the Range of Cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-34.png)<figcaption id="caption-attachment-11844">Select the Range of Cells</figcaption>

- On the **Kutools** tab, **select** the **Insert** option, then, **choose** the **Insert**  **Bullet** option from the menu.

![Select Insert Bullet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-25.png)<figcaption id="caption-attachment-11845">Select Insert Bullet</figcaption>

- Now, you need to **select the type of bullet** (symbols) as you need.

![Select the type of Bullet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-23.png)<figcaption id="caption-attachment-11846">Select the type of Bullet</figcaption>

- Finally, you can see the selected cells have been added with bullets.
- Refer to the below screenshot.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-11.png)

From the above steps, you can learn how to **insert**  **bullets** to the range of cells in **Excel Office 365**.

## Insert Numberings in Multiple Cells:

You can also insert numbering to the multiple cells in Excel, follow the below instructions.

- You need to **select the range of cells** to insert numbering.

![Select the range of cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-35.png)<figcaption id="caption-attachment-11848">Select the range of cells</figcaption>

- Go to the **Kutools** tab, **Select** the **Insert** option, then you have to **choose** the **Insert Numbering** option from the menu list.

![Select insert numbering](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-10.png)<figcaption id="caption-attachment-11849">Select insert numbering</figcaption>

- Then, **select** the **type** of numbering format from the submenu as you need.

![Select the type of numbering](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-10.png)<figcaption id="caption-attachment-11850">Select the type of numbering</figcaption>

- Now, the selected cells have been added with numbering as below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/7-5.png)

From the above image, you can see the selected cells have been added with numbering.

### Note:

- Use bullet options dialog box to configure the settings. If you want to insert bullets in formula cells, blank cells, constant cells, and cells with text values in the selected range only.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/8-4.png)

![Bullet options dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/9-4.png)<figcaption id="caption-attachment-11884">Bullet options dialog box</figcaption>

- If you want to **remove** the **inserted bullets or numberings** from the range of cells, **Click**  **None** from the submenu like below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/10-2.png)

## Closure:

In the above article, you can clearly understand how to **Insert Bullets or Numberings in Multiple Cells in Excel 365** with **Kutools**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Remove Time from Date Time Format Permanently In Excel?](https://geekexcel.com/how-to-remove-time-from-date-time-format-permanently-in-excel/)
- [How to Find Vlookup Value Between Two Numbers in Excel?](https://geekexcel.com/how-to-find-vlookup-value-between-two-numbers-in-excel/)