Tame your computer - build a bullet list


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).

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:

  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:

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


Karen Roem
Microsoft Office-ionado

Roem Ltd – software training and support