EXCEL: How do I format a cell to have mulitple bullets?

R

richards93

Within a cell I'm attempting to create a number of bullets e.g.
1) get tickets, 2) get money, 3) take out dog

Visually can I create a list which would look like:
1) get tickets,
2) get money,
3) take out dog

The way I've done it for years was to force a wrap by adding spaces. There
must be another way. HELP didn't provide any clues.
 
A

AndreasN

Press ALT+ENTER after each bullet and resize column width, if necessary.

Original message:
 
D

David McRitchie

and if you want to do the same in a concatenation formula
=A1 & Char(10) & B1
The use Alt+Enter turns on format, cells, alignment, wrap text
otherwise, you will have to turn on cell wrap yourself like when
you use concatenation.
 

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

New computer, how do i move outlook 365 ENTIRELY? 0
Add a new bullet point to the previous level 1
Expand/Collapse sub-Bullet Animations 1
Creating Labels Over 3-Up Image 2
Date and Number cell formats 4
how do i split a cell into 2 under a heading 2
Word 2007 - How to replace hardcoded numbers with list numbers? 1
How to format (justify) bullets and numberings 2

Top