Add and cycle bullet formats in Excel - Ampler

Add and cycle bullet formats in Excel

Ampler adds bullets to Excel cells and cycles through standard bullet formats — structured lists in a spreadsheet, on your company standard.

Quick answer: Select the cells and click Cycle bullet format on the Ampler ribbon; click again to cycle to the next bullet format.

How to use it

Adding and cycling bullet formats in Excel with Ampler

Select the cells, then cycle the bullet format.

  1. Select the cells you wish to add bullets to.
  2. Click Cycle bullet format, and click again to cycle to the next format.

The formats it cycles through are the ones defined under Settings → Cycles, so you can set them to your company standards.

Why use it

Excel has no real bullet support, so structured notes in cells look inconsistent. Ampler adds proper bullets and cycles through the standard formats, so lists in a spreadsheet are tidy and consistent.

How consultants use it

Notes and lists in a model — assumptions, caveats, to-dos — read better as proper bullets. Three habits apply:

  • Structured notes: assumptions and caveats sit as clean bulleted lists
  • Consistent bullets: the same bullet format is used throughout
  • Company standard: the formats come from the defined cycle

Bullets bring structured, consistent lists to Excel cells.

Tips & best practices

  • Use bullets for assumptions and notes in a model.
  • Cycle to the level of bullet you need.
  • Define bullet formats under Settings → Cycles.

Availability

Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.

Frequently asked questions

How do you add bullet points in an Excel cell?

Select the cells and click Cycle bullet format on the Ampler ribbon. Ampler adds proper bullets and cycles through the standard formats.

Can you have multi-level bullets in Excel?

Yes. Cycling the bullet format steps through the standard levels defined under Settings → Cycles.

Where are the bullet formats defined?

Under Settings → Cycles, so they match your company standard.

Was this article helpful?

Related Articles

Try free