Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bullets & tabbing
Couple questions related to text in cells: How can I insert a tab position
and is there any way to have the text get bullets or numbering |
#2
|
|||
|
|||
Tabs don't work the same way in excel as they do as in a Word table.
You can add a tab like: ="asdf"&char(9)&"qwer" But you'll see a little box where the tab (char(9)) would be. About the only option you have is to use the spacebar (as many times as you want). And if you want things to line up, you'll probably want to use a fixed width font--I like Courier New. You can insert bullets or numbering manually--excel doesn't have anything built into it like MSWord. Insert|Symbol (for xl2002+) or Chip Pearson has an addin that may help (if you're using xl2k or lower). http://www.cpearson.com/excel/download.htm (look for Symbolizer and make sure you get the correct version) Or you could use: Using Windows CharMap Windows start button|run charmap and hit enter Then you can find a bullet and paste. Remember, you'll have to change the font for that character, too. DaveL wrote: Couple questions related to text in cells: How can I insert a tab position and is there any way to have the text get bullets or numbering -- Dave Peterson |
#3
|
|||
|
|||
In fact, if this is really important to you, you may want to use a table within
MSWord. You'll be able to use all MSWord's formatting capabilities. DaveL wrote: Couple questions related to text in cells: How can I insert a tab position and is there any way to have the text get bullets or numbering -- Dave Peterson |
#4
|
|||
|
|||
Hi Dave
Rather than using tabs, you could try using Excel's "indent" tool. To use bullet points with text in cells, format the cells as ". @" To use bullet points with numbers in cells, format the cells as ". #,##0" The first digit of the formatting (which looks like a full stop above) should be entered using "Alt0149" - the bullet point does not come out in plain text posts. -- XL2003 Regards William "DaveL" wrote in message ... Couple questions related to text in cells: How can I insert a tab position and is there any way to have the text get bullets or numbering |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you make bullets | Excel Discussion (Misc queries) | |||
How do I use numbered bullets in Excel? | Excel Discussion (Misc queries) | |||
How can I insert numerical bullets in a cell ex: 1a) ? | Excel Discussion (Misc queries) | |||
Bullets | Excel Discussion (Misc queries) | |||
How do I skip columns when tabbing in Exce? | Excel Discussion (Misc queries) |