The easiest way to insert bullet points in Excel is by using custom formatting and here are the steps for this:
- Press Ctrl + 1 and you will get the “Format Cell” dialogue box.
- Under the number tab, select custom.
- In the input bar, enter the following formatting.
- ● General;● General;● General;● General
- In the end, click OK.
![excel tips tricks custom formatting for bullet points](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/images/optimized/rev-a53ee6c/wp-content/uploads/2018/01/9-excel-tips-tricks-custom-formatting-for-bullet-points.png)
Now, whenever you enter a value in the cell Excel will add a bullet before that.
No comments:
Post a Comment