How to Add Bullet Points in Google Sheets (4 Easy Ways)

Quick answer: To add bullet points in Google Sheets, double-click a cell and press Ctrl+Shift+8 (Cmd+Shift+8 on Mac), or use Insert > Special characters and paste a bullet, or a =CHAR(8226) formula. For several bullets in one cell, add a bullet then press Alt+Enter. All four methods are below.

‍

Why Bullet Points Matter More Than You Think

If you run a business, agency, or sales team, your Google Sheets are probably bursting with lists: talking points, campaign ideas, next steps, lead notes. Without structure, those cells turn into a wall of text that everybody quietly avoids.

Bullet points fix that. They turn chaos into a quick scan: what matters, what changed, what to do next. The catch? Google Sheets does not have a native "bulleted list" button like Docs. You have to get a little creative.

Below are the most useful manual methods, followed by how a Simular AI computer agent can take over and do this at scale.

‍

Method 1: Keyboard Shortcuts for Single Bullets

This is the fastest way when you are working in just a few cells.

On Windows (with numeric keypad):

1. Double-click the cell.
2. Place your cursor where the bullet should go.
3. Hold Alt and type 7 on the numeric keypad.
4. Release to insert •, then type your text.

On Mac:

1. Double-click the cell.
2. Press Option + 8 to insert •.
3. Type your text.

Pros

• Very fast for a handful of entries.
• Works inside any text cell.

Cons

• Becomes tedious for long columns.
• Easy to forget the key combo.

‍

Method 2: Multi-Line Bullets Inside One Cell

Sometimes you want a mini checklist inside a single cell (for a lead, a project, or a client).

On Mac:

1. Double-click the cell.
2. Press Option + 8 to add a bullet.
3. Type the first line.
4. Press Control + Enter to move to a new line inside the same cell.
5. Repeat bullet + text for each line.

On Windows:

1. Double-click the cell.
2. Use Alt + 0149 (numeric keypad) or Alt + 7 to add a bullet.
3. Type your text.
4. Press Alt + Enter to start a new line in the same cell.
5. Repeat as needed.

Pros

• Perfect for rich notes on a single record.
• Keeps related items together.

Cons

• Harder to filter and sort by individual bullet.
• Still manual and repetitive.

‍

Method 3: Custom Number Formats for Entire Columns

When you want bullets across a whole column, custom formats are your friend.

1. Enter plain text in a few cells (no bullets yet).
2. Select the range where you want bullets.
3. Click Format → Number → More formats → Custom number format.
4. In the box, type: • @
5. Click Apply.

Now every cell in that range shows a bullet followed by the cell content.

Pros

• Instantly adds bullets to an entire range.
• You can still edit the raw text without bullets.

Cons

• Formatting lives on the range, not the data.
• New ranges need the same custom format applied again.

‍

Method 4: Formulas Using the CHAR Function

For formula-driven sheets, you can generate bullets with CHAR.

1. In a new column, use a formula like:
   =CHAR(8226) & " " & A2
2. Drag the formula down to fill the column.

This pulls text from A2, prefixes it with a bullet (•), and outputs a clean, formatted line.

Pros

• Great when your data is coming from imports or other formulas.
• Easy to tweak spacing or add prefixes.

Cons

• Adds extra columns.
• Editing requires working with formulas, not raw text.

‍

Method 5: Automating Bullets at Scale With a Simular's AI Agent Sai

All the methods above work. But if you are:

• Cleaning hundreds of sheets across clients,
• Importing messy lists from CRMs, email, or web scrapes, or
• Rebuilding the same structures every week,

then formatting becomes a quiet tax on your time.

With Sai, you can spin up an AI computer agent that uses your desktop the way a human would:

1. You demonstrate the workflow once.
   • Open Google Sheets.
   • Select ranges that need bullets.
   • Apply custom number formats or insert bullets via keyboard.
   • Clean up any edge cases.
2. The agent learns the steps as a reliable workflow.
   Simular combines flexible reasoning with symbolic steps, so every click, keypress, and menu action is transparent and repeatable.
3. You run it on demand or from your pipeline.
   • Trigger the agent via webhook after new data is pushed.
   • Let it open Sheets, apply bullets, and save.
   • Review its action log if you want to check or tweak behavior.

Pros of the AI-driven approach

• Handles thousands of cells and multiple files without fatigue.
• Production-grade reliability: the same steps, every time.
• Fully transparent: you can inspect and modify its workflow.

Cons

• Best suited once you have a recurring need, not for a one-off.
• Requires a short initial setup to teach your preferred style.

In short, manual methods are perfect when you are hands-on in a single sheet. When your job is running teams and processes, it is far more powerful to let a Simular AI agent own the formatting, so you can own the strategy.

‍