In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to create a bulleted list in your workbook (Microsoft Excel).
Tame your computer - build a bullet list
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.
- 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!
Unless stated otherwise, these tips were written for Microsoft Office 2010.
23 October 2017