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 describes how to create a bulleted list in your Excel workbook.

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

3 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

Roem Limited

Independent, innovative software training company based in Cambridge. Registered supplier to the University of Cambridge, Illumina and NHS England.

Roem Limited directory information

Back to Search

Newsletter signup

Jobsletter signup