Tip of the week # 523
26 September 2017

Create a bulleted list in your workbook (Microsoft Excel) ^*

Microsoft Excel does not have a built-in function to create a bulleted list like in Word, PowerPoint and Outlook. But during a course yesterday I found out you can create one using a nifty keyboard shortcut.

Here's how:

1. Select the cell where the list is to appear.
2. Press ALT + 7 on the numeric keypad.
3. Type your text.
4. Press ALT + ENTER if you want to insert another bullet in the same cell.
5. Repeat steps 2 - 4.

With thanks to Alex for the tip inspiration!

Related tips:
Tip # 506: Fast way to start a bulleted or numbered list (Microsoft Word and Outlook) tip_506.php
Tip # 458: How to add, find and remove line breaks (Microsoft Excel) tip_458.php

.

^* Unless stated otherwise, these tips were written for Microsoft Office 2010.