Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
how can I add bullet point in an Excel cell when preparing text ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
Try this:
Hold down the [alt] key...type 0149....release the [alt] key Is that something you can work with? *********** Regards, Ron XL2002, WinXP "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
Hold down the Alt key and enter 0149 on the number keypad
or =Char(149) "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
but when I hold down the [alt] key, I am not allowed to type any key .
"Ron Coderre" wrote: Try this: Hold down the [alt] key...type 0149....release the [alt] key Is that something you can work with? *********** Regards, Ron XL2002, WinXP "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
I type =Char(149), then press [Enter] but the cell returns blank.
"JMB" wrote: Hold down the Alt key and enter 0149 on the number keypad or =Char(149) "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
Hi Charlene
Having pressed the Alt key, whilst holding it down, as you type 0149 from the numeric pad nothing seems to appear, but when you release the Alt key having completed the key sequence, the bullet sign should then appear. The 0149 must be typed from the numeric pad, not the numbers from the top row of the keyboard. If you are using a Laptop computer, then you would need to use the Function key + NumLk first, to invoke the embedded numeric keypad utilising the letters MJU and 9 from the top row. -- Regards Roger Govier "charlene" wrote in message ... but when I hold down the [alt] key, I am not allowed to type any key . "Ron Coderre" wrote: Try this: Hold down the [alt] key...type 0149....release the [alt] key Is that something you can work with? *********** Regards, Ron XL2002, WinXP "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
When I use that formula in a cell and that cell is using an Arial font, I see a
little square bullet shape. charlene wrote: I type =Char(149), then press [Enter] but the cell returns blank. "JMB" wrote: Hold down the Alt key and enter 0149 on the number keypad or =Char(149) "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add bullet point in an Excel cell ?
Works the same for me using Times New Roman. It looks better if you bold it.
That cells font color isn't white, is it? "Dave Peterson" wrote: When I use that formula in a cell and that cell is using an Arial font, I see a little square bullet shape. charlene wrote: I type =Char(149), then press [Enter] but the cell returns blank. "JMB" wrote: Hold down the Alt key and enter 0149 on the number keypad or =Char(149) "charlene" wrote: how can I add bullet point in an Excel cell when preparing text ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
excel cell to html | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |