How to Indent Bullet Points of a Cell in Excel (3 Effective Ways)

Looking for ways to know how to indent bullet points in Excel cell? Sometimes, we want to both insert and indent bullet points in an Excel cell. Here, you will find 3 ways to indent bullet points in an Excel cell.


Download Practice Workbook


3 Ways to Indent Bullet Points of a Cell in Excel

Here, we have a dataset containing the Date and a list of Works to Do on that particular date. Now, we will first add bullet points to this list and then show you 3 different ways to indent the bullet points in the Excel cell.

Ways to Indent Bullet Points of a Cell in Excel


1. Manually Indenting Individual Lines

In the first method, we will show you how to add bullet points and then Manually indent individual lines to indent bullet points in an Excel cell. Follow the steps given below to do it on your own dataset.


Step-01: Inserting Bullet Points in Excel

Here, we will show you how to insert bullet points using Keyboard Shortcut in Excel. Go through the steps given below to do it on your own.

  • Firstly, select Cell C5.
  • Then, double-click on the cell and place the cursor where you want to insert the bullet point.

Inserting Bullet Points in Excel

  • After that, press ALT +7 from your Numerical Keyboard.

  • Next, press ENTER.
  • Now, you will see that a bullet point has been inserted.

Inserting Bullet Points in Excel

  • Similarly, insert bullet points in the rest of the cells.


Step-02: Manually Indenting Bullet Points in Excel

Now, we will show you how to manually indent bullet points in Excel. Follow the steps given below to do it on your own.

  • In the beginning, select Cell C5.
  • Then, double-click on the cell and place the cursor where you want to indent.

Manually Indenting Bullet Points in Excel

  • After that, enter Space from your Keyboard to get the desired indentation.

  • Next, press ENTER.
  • Now, you will have indentation before the bullet point.

Manually Indenting Bullet Points in Excel

  • Similarly, indent the bullet points for the rest of the cells.

Read More: How to Insert Tab in Excel Cell (4 Easy Ways)


2. Using Keyboard Shortcuts to Indent Bullet Points

We can also use Keyboard Shortcuts to indent bullet points in Excel. The Keyboard Shortcut ALT+H+6 is used for right indentation and ALT+H+5 is used to indent the cell value to the left.

Steps:

  • Firstly, select Cell range C5:C10.

Using Keyboard Shortcuts to Indent Bullet Points

  • Then, press ALT+H+6 to indent the cell value to the right.

  • Now, you will have a right indentation before the bullet points.

Using Keyboard Shortcuts to Indent Bullet Points

  • On the other hand, to get a left indentation, select Cell range C5:C10.

  • Then, press ALT+H+5 to indent the cell value to the left.

Using Keyboard Shortcuts to Indent Bullet Points

  • Thus, you can have a left indentation before the bullet points.

Read More: How to Change Indent in Excel (5 Efficient Methods)


3. Use of Indent Feature from Alignment Group to Indent Bullet Points

In the final method, we will show you how to indent bullet points using the Indent feature from the Alignment group. Go through the steps given below to do it on your own.

Steps:

  • In the beginning, select Cell range C5:C10.
  • After that, go to the Home tab >> click on Increase Indent from Alignment group.

Use of Indent Feature from Alignment Group to Indent Bullet Points

  • Thus, you can have an indentation before the bullet points.

Read More: How to Tab to Certain Cells in Excel (2 Easy Ways)


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find 3 ways to indent bullet points in an Excel cell. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo