The easiest way to insert bullet points in Excel is by using custom formatting and here are the steps for this:

  1. Press Ctrl + 1 and you will get the “Format Cell” dialogue box.
  2. Under the number tab, select custom.
  3. In the input bar, enter the following formatting.

● General;● General;● General;● General

excel tips tricks custom formatting for bullet points
  • Click OK.

Now, whenever you enter a value in the cell Excel will add a bullet before that.

excel tips tricks insert bullet points

Visit Now