Bulleting and Numbering in a Cell

  • Thread starter Thread starter dblimbu2008
  • Start date Start date
D

dblimbu2008

Hi all,

Please tell me, how can I put bullet and number in a Cell of MS Excel.


Regards
DB Limbu
 
Use hard returns within the cells (ALT-ENTER), and at the beginning of each
internal line, start with a period.

The increase the font size of each period.

Finally format the cell with wrap
 
Generally you don't put a number and a bullet together but choose what you need
from below.

Alt + 0149 space 1 space "text" Alt + Enter

Alt + 0149 space 2 space "text" Alt + Enter

Keep this up until you're tired or have enough lines in a cell.

The Alt + 0149 is a bullet

Don't forget to set the cell to Wrap Text


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Bulleted or numbered list inside cell? 1
How to create a bulleted list within a cell in excel (as in Word) 1
Shooting a Bullet character in Excel cell. 4
Shouldn't have to ask but.. 4
Bullets Changing to Numbers and Visaversa 3
Inserting a character into a cell that has text. 5
Remove Default Picture Bullets 1

Back
Top