To use nested numbers or letters (for example, 3., 3.1., 3.1.1.), select the Tiered Numbers checkbox.

You can also select text, then format it as a simple list or one with a complex hierarchy.

Tiered lists, such as those used in legal documents, use nested numbers or letters (for example, 3., 3.1., 3.1.1.).

You can change the number or letter style, change the indentation, and create your own text and image bullets to customize a list.

If you create a list whose formatting you want to use again in the same spreadsheet, you can save it as a new list style.

Create a list automatically Numbers detects when youre typing a list and adds some basic formatting as you type.

Add a text box to the sheet, or place the insertion point in existing text where you want to add a list.

Type a dash, a bullet (Option-8), or a letter or number followed by a period and a space.

Every subsequent item in the list automatically begins with the same character.

To use a special character for the bullet, choose Edit Emoji Symbols (from the Edit menu at the top of your screen), then click a character from a bullet or star menu.

To change the indent level (hierarchy) of an item in the list, click anywhere in the item, then do either of the following: Move the item to the right: Press Tab.

If you dont want Numbers to automatically create lists, choose Numbers Preferences (from the Numbers menu at the top of your screen).

Click Auto-Correction at the top of the preferences window, then deselect the checkbox next to Automatically detect lists.

In the Format sidebar, click the Text tab, then click the Style button.

Click the pop-up menu next to Bullets Lists, then choose a list style.

Click the disclosure triangle next to Bullets Lists, then use the controls shown below to format the list.

When you choose Text Bullets, Image Bullets, or Numbers from the pop-up menu below the disclosure triangle, you see more controls that apply to the type of list you chose.

Reorder list items You can drag items in a list to a different level in the hierarchy or to a different indentation level.

Select the list item you want to move by clicking its bullet, number, or letter.

Change the number or letter sequence You can use numbers or letters in various formats to designate levels of hierarchy in an ordered list.

Select the list items with the numbering or lettering you want to change.

In the Format sidebar, click the Text tab, then click the Style button near the top of the sidebar.

Click the disclosure triangle next to Bullets Lists, then click the pop-up menu below Bullets Lists and choose Numbers.

Click the pop-up menu above Tiered Numbers and choose a number or letter sequence.

Excel For Mac Add Bullet Points In Cell