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
Highly respected training company, specialising in Excel, Word, PowerPoint and Outlook. Since 2001 we have successfully developed and delivered training courses for public and private clients, large and small, across 23 countries around the world. We feel passionate about sharing the best of what we know with others and strive to help as many people as we can.