crazzy88ss Posted December 4, 2010 Share Posted December 4, 2010 I'm trying to make bulleted lists in excel. For some reason Word can figure it out. Right from the start I'm finding it impossible to figure out how to create lists inside of a single cell in Excel. So I went to Word and was able to make it there. However, when I paste the table into Excel I get this: I go to merge the cells and it deletes the info in all but the top cell and I'm back to square one. How do I create bulleted lists in single cells? Hitting the enter or return key just finishes the cell and moves down to the next cell. ---- Why must MS make the mac version SO much different than the windows version? I feel like I'm using two different pieces of software, with the OSX version being from 1999. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/ Share on other sites More sharing options...
Pam14160 Posted December 4, 2010 Share Posted December 4, 2010 See if you can get your hands on the 2011 for mac. If you can see if that does what you are looking for. The 2008 was not a favorite of mind. If you have iWork's numbers give that try. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593456366 Share on other sites More sharing options...
+virtorio MVC Posted December 4, 2010 MVC Share Posted December 4, 2010 The Windows version of Excel can't do bullet points either. I would insert a bullet point character in the cell manually. You should be using a Word processor. edit: seems that's what Microsoft says you should do as well http://support.microsoft.com/kb/323567 Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593456372 Share on other sites More sharing options...
crazzy88ss Posted December 4, 2010 Author Share Posted December 4, 2010 See if you can get your hands on the 2011 for mac. If you can see if that does what you are looking for. The 2008 was not a favorite of mind. If you have iWork's numbers give that try. I'm debating getting it when I get a new iMac in ~6 months. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593456376 Share on other sites More sharing options...
crazzy88ss Posted December 4, 2010 Author Share Posted December 4, 2010 The Windows version of Excel can't do bullet points either. I would insert a bullet point character in the cell manually. edit: seems that's what Microsoft says you should do as well http://support.microsoft.com/kb/323567 That was useless because when I hold my ALT key and type numbers on a mac I get this: ???? :( I'll poke around on MS's website. Dunno why I didn't think of htat.... so thanks for pointing me there :) You should be using a Word processor. Well not to be rude, but you don't know what I'm doing, so how can you be sure exactly what tool I should be using? Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593456386 Share on other sites More sharing options...
+virtorio MVC Posted December 4, 2010 MVC Share Posted December 4, 2010 Well not to be rude, but you don't know what I'm doing, so how can you be sure exactly what tool I should be using? Because this is not what a spreadsheet application is used for, which is why the functionality isn't built in. OSX has plenty of ways to insert symbol characters (if Office follows the usual standard it will be Edit -> Special Characters. If it doesn't, insert it in another app (TextEdit, for example) and copy and paste it). edit: sorry if I come off as a little, "direct". My apologies, it's the wine talking. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593456454 Share on other sites More sharing options...
Pam14160 Posted December 4, 2010 Share Posted December 4, 2010 You might give one of the different Mac/Apple forums a peak. Some of those sites have some really smart people when it comes to problems with the Mac and the software for it. Good Luck :) Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593456496 Share on other sites More sharing options...
crazzy88ss Posted December 4, 2010 Author Share Posted December 4, 2010 You might give one of the different Mac/Apple forums a peak. Some of those sites have some really smart people when it comes to problems with the Mac and the software for it. Good Luck :) I thought about it, but the awesome thing about Neowin is that you guys are really fast at responding. :) Turns out there's an option in iWork's Numbers that lets you turn on/off the Enter key going from cell to cell and allows me make paragraph breaks inside each cell. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593458232 Share on other sites More sharing options...
mastermate Posted December 5, 2010 Share Posted December 5, 2010 Pressing ALT-Enter in the cell keeps the linebreak in the cell. Would this work for you? Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593459506 Share on other sites More sharing options...
crazzy88ss Posted December 5, 2010 Author Share Posted December 5, 2010 Pressing ALT-Enter in the cell keeps the linebreak in the cell. Would this work for you? I tried Alt, cmd, shift, and probably all combinations of those three + Enter with no luck. *edit* ok.... So my MacBook (which is identical in terms of software versions) won't do cmd + alt + enter, but my iMac WILL do a line break using that key combo.... Oh well. At least I figured this out. Thanks for making me retry it on my iMac! lol... Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593460216 Share on other sites More sharing options...
Bengal34 Posted December 5, 2010 Share Posted December 5, 2010 If you want to put a list like that into excel, wouldn't it make more sence to put it into a text block instead of into cells? Alternatively, if you really need the content in cells then you should look at the custom formatting feature to insert a bullet point and a space before the text. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593460228 Share on other sites More sharing options...
XerXis Posted December 5, 2010 Share Posted December 5, 2010 why would you want bullet points in excel? Excel is a spreadsheet application, not an application that is meant for document formatting, that's what word is for. I'm sorry, but it seems like you have mixed up what excel and word are meant to be doing. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593460322 Share on other sites More sharing options...
crazzy88ss Posted December 5, 2010 Author Share Posted December 5, 2010 why would you want bullet points in excel? Excel is a spreadsheet application, not an application that is meant for document formatting, that's what word is for. I'm sorry, but it seems like you have mixed up what excel and word are meant to be doing. yea blahblah if you read the other posts you'd see we covered this already. Go waste your time elsewhere. Link to comment https://www.neowin.net/forum/topic/958256-making-bullet-lists-in-excel-mac-08/#findComment-593461064 Share on other sites More sharing options...
Recommended Posts