Did You Know :: Bullet Points & Line Breaks in Excel Cells

Posted: June 10, 2013 by MaxFraudy in Excel
Tags: , , ,

UntitledAlthough Excel is a primarily a spreadsheet program, which means that it has been designed to store numbers, we often need to use some cells to store text. Also, at times we need to use ‘Word’-like features like line breaks or bullet points. Did you know that you could achieve it in Excel this way:

For bullet points – use [Alt] + 7 or [Alt] + 9 key from the numeric keypad on your keypad. The former combination will give you a filled-in bullet and latter will give you an empty bullet. In laptops where there is no dedicated keypad, use the [Fn] + [Num Lock] or [Shift] + [Num Lock] key to enable the numeric keypad and then use the shortcut for bullets.

Bullets Points in Excel Cells

Bullets Points in Excel Cells

For line breaks, use [Alt] + [Enter] key

Line Breaks in Excel Cells

Line Breaks in Excel Cells

 

Addendum:

Using [Alt] + any number from the numeric keypad inserts the character associated with that ASCII code. In the above case, it’s the two circles.

 

 

Advertisements
Comments
  1. snb says:

    I thought you meant to draw our attention to using a custom numberformat

    “• @”
    or
    “◘ @”

    in which the first characters are alt-7 and alt- 9 respectively

  2. Transformer says:

    [ALT] +[Number entered from numeric keyboard] = CHAR(Number)

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s