How to Insert a Bulleted List in Cell Excel 2007

Next Video:
How to Set Up a Trend/Run Chart in Excel....5

Inserting a bulleted list in a cell in Excel 2007 is something that you can do right from the main ribbon toolbar. Insert a bulleted list in a cell in Excel 2007 with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Ted. Today, I'm going to show you how to insert a bulleted list in Excel. This is a kind of thing where you let's say you have a bulleted list in maybe Powerpoint or Excel and you want to copy it over to Excel to do something with that list to organize or do calculations. So I have a made up a bulleted list here. It's a fun looking to do list in Word and I have an Excel spreadsheet which I'll show you here already. So we're going to take those ten tasks and put them on this list and then eventually this is going to be just for something fun to do, a lit of who's going to do each of the tasks. So going back to the Word list, what you do is just select all the text, make sure you get the complete bullet on each one, and then just say copy, and then go over to Excel and this is where it gets a little tricky. If you know the number of lines you can select the same number of lines. Now I found out that it's actually going to make a separate column for the bullets so I made an extra column over here and I select two columns and ten rows, I know that there are ten rows and then I'm always safer when I do this kind of cutting and pasting is doing a paste special as text. So you know it's going to just the text is going to be pasted over. And there we go. The bullets turn in to O's in column A, the tasks ended up right where I wanted them to and then of course you can do whatever you want from this point on. So I hope this has been helpful. I'm Ted. Today I showed you how to insert a bulleted list in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!