Microsoft Excel does not have a built-in function to create a bulleted list like it has in Word, PowerPoint and Outlook. But during a course recently I found out you can create one using a nifty keyboard shortcut.
Here’s how:
- Select the cell where the list is to appear.
- Press ALT + 7 on the numeric keypad.
- Type your text.
- Press ALT + ENTER if you want to insert another bullet in the same cell.
- Repeat steps 2 – 4.
With thanks to Alex for the tip inspiration!
Related tips:
Fast way to start a bulleted or numbered list (Microsoft Word and Outlook)
How to add, find and remove line breaks (Microsoft Excel)
Unless stated otherwise, these tips were written for Microsoft Office 2010.
23 October 2017
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk