We rebuilt the editor. Less panel hunting. More shaping.

Guide

How To Add Bullet Points In Google Sheets

This guide will take you through the steps to add bullet points in Google Sheets. Follow these steps to format your data with bullet points effectively.

Interactive tour · Open canonical tour

  1. Double-click the cell where you want to add bullet points.

  2. Press Alt + 7 (Windows) or Option + 8 (Mac) to insert a bullet symbol (•).

  3. Type your text after the bullet point.

  4. Press Enter + Alt + 7 to add more bullet points in the same cell.

  5. Use the CHAR(8226) formula (=CHAR(8226) & " Your Text") to insert bullets dynamically.

  6. Copy and paste bullets into multiple cells if needed.

  7. Use Custom Number Formatting to automatically add bullets to all selected cells.