ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I do text bullets within an excel cell? (https://www.excelbanter.com/excel-discussion-misc-queries/76568-can-i-do-text-bullets-within-excel-cell.html)

Ed

Can I do text bullets within an excel cell?
 
I would like to create in one excel cell a paragraph with an opening sentence
followed by bulleted items just like in Word. Is that possible other than
using a workaround the would use one cell for the sentence then indented by
using a separate column and cell?

Ron Coderre

Can I do text bullets within an excel cell?
 
Try something like this:

Select a cell
Enter some text
Hold down the [alt] key and press [enter]
While holding down the [alt] key type 0149...release the [alt] key
Type the bullet point text
Hold down the [alt] key and press [enter]
repeat

Note: The [alt][enter] combination inserts a "hard carriage return" in the
cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ed" wrote:

I would like to create in one excel cell a paragraph with an opening sentence
followed by bulleted items just like in Word. Is that possible other than
using a workaround the would use one cell for the sentence then indented by
using a separate column and cell?


Ed

Can I do text bullets within an excel cell?
 
Ron,

Thanks. that took care of it.

Ed

"Ron Coderre" wrote:

Try something like this:

Select a cell
Enter some text
Hold down the [alt] key and press [enter]
While holding down the [alt] key type 0149...release the [alt] key
Type the bullet point text
Hold down the [alt] key and press [enter]
repeat

Note: The [alt][enter] combination inserts a "hard carriage return" in the
cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ed" wrote:

I would like to create in one excel cell a paragraph with an opening sentence
followed by bulleted items just like in Word. Is that possible other than
using a workaround the would use one cell for the sentence then indented by
using a separate column and cell?



All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com