The tutorial shows a few simple ways to insert bullet in Excel. We will also share some tips on how to quickly copy bullets to other cells and make your custom bulleted lists.

This shortcut displays the Insert Function dialog box on Windows and the Formula Builder dialog box on a Mac. Jan 31, 2012  Java Project Tutorial - Make Login and Register Form Step by Step Using NetBeans And MySQL Database - Duration: 3:43:32. 1BestCsharp blog Recommended for you.

Microsoft Excel is primarily about numbers. But it is also used to work with text data such as to-do lists, bulletin boards, workflows, and the like. In this case presenting information in a right way is really important. And the best you can do to make your lists or steps easier to read is to use bullet points.

The bad news is Excel does not provide a built-in feature for bulleted lists like most word processors including Microsoft Word do. But that doesn't mean there is no way to insert bullet points in Excel. In fact, there are at least 8 different ways, and this tutorial covers them all!

How to insert bullet points in Excel using keyboard shortcuts

The quickest way to put a bullet symbol into a cell is this: select the cell and press one of the following combinations using the numeric keypad on your keyboard.

● Alt + 7 or Alt + 0149 to insert a solid bullet.

○ Alt + 9 to insert an empty bullet.

Apart from these standard bullets, you can also do some fancy bullet points in Excel like these ones:

Once a bullet symbol is inserted into a cell, you can drag the fill handle to copy it to adjacent cells:

To repeat bullet points in non-adjacent cells, select a cell with the bullet symbol and press Ctrl + C to copy it, then select another cell(s) where you want to have the bullets and press Ctrl + V to paste the copied symbol.

To add multiple bullet points to the same cell, insert the first bullet, hit Alt + Enter to make a line break, and then press one of the above key combinations again to insert a second bullet. As the result, you will have the entire bullet list in a single cell like shown in the screenshot below:

• If you are using a laptop that does not have a number pad, you can turn on Num Lock to emulate a numeric keypad. On most laptops, this can be done by pressing Shift + Num Lock or Fn + Num Lock.
• To add a bullet symbol to a cell that already contains text, double-click the cell to enter the Edit mode, place the cursor where you want to insert the bullet, and then press Alt + 7 or Alt + 9.
• In case you need to conditionally format your bulleted list or apply some formulas to it, say to count specific list items, it is easier to do if the items are normal text entries. In this case, you can put bullets in a separate column, align them right, and remove the border between the two columns.

How to add bullet points in Excel using Symbol menu

If you don't have a number pad or forget a key combination, here's another quick easy way to insert bullet in Excel:

1. Select a cell where you want to add a bullet point.
2. On the Insert tab, in the Symbols group, click Symbol.
   
3. Optionally, select the font of your choosing in the Font box. Or, go with the default (normal text) option.
4. Select the symbol you'd like to use for your bulleted list and click Insert.
5. Close the Symbol dialog box. Done!

If you have difficulties finding a bullet icon among other symbols, type one of the following codes in the Character code box:

For example, that's how you can quickly find and insert a small filled bullet point:

Copy a bulleted list from Word

In case you have already created a bulleted list in Microsoft Word or another word processer program, you can easily transfer it to Excel from there.

Simply, select your bulleted list in Word and press Ctrl + C to copy it. Then, do one of the following:

• To insert the entire list into one cell, double-click the cell, and press Ctrl + V.
• To put list items into separate cells, click the cell where you want the first item to appear and press Ctrl + V.

How to do bullet points in Excel using formulas

In situations when you want to insert bullets into multiple cells at a time, the CHAR function may prove helpful. It can return a specific character based on the character set used by your computer: Windows-1252 on Windows and Mac OS Roman on Mac.

On Windows, the character code for a filled round bullet is 149, so the formula goes as follows:

=CHAR(149)

WoW Model Viewer is a tool used by Machinima Artists to view and capture model and character animation from World of Warcraft. As an open-source project, we encourage the development of features that may be useful to current or future artists. Wod models for mac os. WoD models for 3.3.5? I found some on dalaran forum but seems buggy. Molten halfassed 'theirs' (apparently stolen), leaving blood elves and draenei with shitty models. So, is there fully working WoD models for every race for 3.3.5? MacBook Pro models are organized by the year they were introduced, starting with the most recent. Click the model name for detailed technical specifications. MacBook Pro models from 2012 and newer can run the latest version of macOS. For models from before 2012, the latest compatible operating system is noted.

To add bullets to multiple cells in one go, perform these steps:

1. Select all the cells where you want to put bullet points.
2. Type this formula in the formula bar: =CHAR(149)
3. Press Ctrl + Enter to insert the formula into all the selected cells.

This method comes in especially handy when you already have some items in another column and you want to quickly create a bulleted list with those items. To have it done, concatenate a bullet symbol, space character, and cell value.

With the first item in A2, the formula for B2 takes the following shape:

=CHAR(149)&' '&A2

Now, drag the formula up to the last cell with data, and your bulleted list is ready:

Cx Fu02 Cx-fu02 usb modem Modem driver installation manager modeem reported as very satisfying by a large percentage of our reporters, so it is recommended to download and install. Teardown I was secretly hoping that I would get cx-vu02 that had an Agere chipset in it, but sadly, that was not to be. USB Modem Driver is a DriverCore Component. Support for multiple USB modems on separate physical USB devices. Support composite USB devices with multiple modem functions. Usb modem cx-fu02. More SAMSUNG USB Driver for Mobile Phones 1.7.17.0. Samsung Electronics Co., Ltd. 38.9MB - Freeware - Samsung USB Driver for. Teardown: Generic CX-FU02+ USB SoftV92 Data Fax HSF Modem. My tech shopping in Hong Kong continues with more goodies. One of the things I was on the lookout for was the last of the dial-up modem. Rather unsurprisingly, for such an advanced country, it’s almost impossible to find any new modems at all. Rd02 d400 windows 10. Usb Fax Modem Cx Fu02 now has a special edition for these Windows versions: Windows 7, Windows 7 64 bit, Windows 7 32 bit, Windows 10, Windows 10 64 bit, Windows 10 32 bit, Windows 8, Windows Vista Home Basic 64bit, Windows 8 Pro 32bit, Windows 10 Enterprise 32bit, Windows RT 64bit, Windows 7 Professional 64bit, Windows Vista Home Premium 32bit. HiRO V92 56K External USB Data Fax Dial Up Internet Modem Dual Port Built in Buzzer Truly Plug n Play Driverless Installation Built in Driver Windows 10, 8.1, 8, 7, 32-bit 64-bit (H50228) $0.40 coupon applied.

How to put bullet points in Excel using special fonts

In Microsoft Excel, there are a couple of fonts with nice bullet symbols, e.g. Wingdings and Webdings. But the real beauty of this method is that it lets you type a bullet character straight into a cell. Here's what you do:

1. Select the cell where you want to put a bullet point.
2. On the Home tab, in the Font group, change font to Wingdings.
3. Type a small 'l' letter to insert a filled circle bullet (●) or 'n' to add a square bullet point (■) or some other letter shown in the screenshot below:
   

You can insert even more bullet symbols by using the CHAR function. The point is that standard keyboards have only around 100 keys while every font set has 256 characters, meaning more than half of those characters cannot be entered directly from a keyboard.

Please remember, to make the bullet points shown in the image below, the font of the formula cells should be set to Wingdings:

Create a custom format for bullet points

If you want to spare the trouble of inserting bullet symbols into every cell over and over again, make a custom number format that will insert bullet points in Excel automatically.

Select a cell or a range of cells where you want to add bullets, and do the following:

1. Press Ctrl + 1 or right-click the selected cells and choose Format Cells… from the context menu.
2. On the Number tab, under Category, select Custom.
3. In the Type box, enter one of the following codes without quotation marks:
   • '● @' (solid bullets) - press Alt + 7 on the numeric keypad, type a space, and then type @ as a text placeholder.
   • '○ @' (unfilled bullets) - press Alt + 9 on the numeric keypad, enter a space, and type the @ character.
4. Click OK.

And now, whenever you want to add bullet points in Excel, select the target cells, open the Format Cells dialog, select the custom number format we've just created, and click OK to apply it to the selected cells. You can also copy this format in the usual way using Excel's Format Painter.

Insert bullet points in a text box

If you don't mind using text boxes in your worksheets, then you'll have a more straightforward way to inset bullets in Excel. Here's how:

1. Go to the Insert tab, Text group, and click the Text Box button:
   
2. In the worksheet, click where you want to have the text box and drag it to the desired size.
   Tip. For the text box to look tidier, hold the Alt key when dragging to align the edges of the text box with the cell borders.
3. Type the list items in the text box.
4. Select the lines you want to turn into bullet points, right-click on them, and then click the little arrow next to Bullets:
   
5. Now, you can take your pick of any of the redefined bullet points. As you scroll over different bullet types, Excel will show a preview in the text box. You can also create your own bullet type by clicking Bullets and Numbering… > Customize.

For this example, I have selected Filled Square Bullets, and there we have it - our own bulleted list in Excel:

How to make bullet points in Excel using SmartArt

The best part is saved for the last :) If you are looking for something more creative and elaborate, use the SmartArt feature available in Excel 2007, 2010, 2013 and 2016.

1. Go to the Insert tab > Illustrations group and click on SmartArt.
   
2. Under Categories, select List, click the graphic you'd like to add, and click OK. For this example, we are going to use Vertical Bullet List.
   
3. With the SmartArt graphic selected, type your list items on the text pane, and Excel will add bullets automatically as you type:
   
4. When finished, switch to the SmartArt Tools tabs and craft your bullet list by playing around with colors, layouts, shape and text effects, etc.

To give you some ideas, here are the options I used to embellish my Excel bulleted list a bit further:

These are the methods I know to insert bullet points in Excel. If someone knows a better technique, please do share in comments. I thank you for reading and hope to see you on our blog next week!

You may also be interested in:

These days we all live and work in a multi-device, multi-platform world, and so when building Office 2016 for Mac, one of our key objectives was to make it as easy as possible to transition from using Office for Windows to using Office for Mac and back again. That’s why you’ll notice an interface that’s consistent with what you’d expect when using Office 2016 for Windows, and why we added support for virtually all of the Windows Excel Ctrl keyboard shortcuts. So when it came to working with external data, we applied that same logic: how can we make the experience great and working cross platform easier than ever?

External data in Excel 2016 for Mac

We examined how we could improve external data for Excel 2016 for Mac and made the following changes:

• Excel 2016 for Mac comes with a pre-installed and integrated SQL Server ODBC driver, which we worked hand-in-hand with Simba Technologies to provide.
• Excel 2016 for Mac has a brand new Microsoft Query (MSQuery) and Connection Manager to make creating and managing all of your data connections easier and more consistent with Windows.

Let’s take a deep dive into how each of these improvements can help you.

Native support for ODBC data connections

Excel 2016 for Mac supports ODBC data connections with SQL Server and Azure SQL Database right out of the box. This means several great things for anyone who works with external data:

• When creating or refreshing data connections to SQL Server, there are no third-party drivers required—everything you need is included right in the app.
• Connections made to SQL Server in Excel 2016 for Mac will work in Excel for Windows and vice versa. Have a workbook with ODBC data connections you’ve been using on Windows and never been able to use on your Mac? Well, now you can with cross-platform compatibility.
• If you want to connect to something other than SQL Server, we still have several great partners offering third-party drivers to connect to any data source you can imagine.

In addition, all of the ways in which you interact with external data are now consistent between the platforms. Looking for that Refresh button? It’s on the Data tab just as you’d expect.

The Data tab in Excel 2016 for Mac.

A better way to work with external data connections

One of the biggest improvements to working with external data connections in Excel for Windows in recent releases has been the Connection Manager. It provides a central place to see all of the data connections in a workbook, see where they are used, and modify, remove or refresh each one individually. With Excel 2016 for Mac, you now have that same Connection Manager you are familiar with from Windows. All of your connections are displayed, and you can click any of them to see where they are used in your workbook and to perform any action.

The all-new Connection Manager in Excel 2016 for Mac.

The Connection Properties dialog has been streamlined as well to match Excel for Windows, so that you now only see the properties that apply to your particular data connection.

All of your connection properties are in one place and just like Excel for Windows.

However, what good is easier management of your data connections if it’s too hard to create them to begin with? With Excel 2016 for Mac, creating a connection to SQL Server is easier than ever. On the Data tab, simply select New Database Query > SQL Server ODBC, and you are presented with a simple connection dialog. Once it’s filled out, the newly redesigned MSQuery launches.

The all-new MSQuery in Excel 2016 for Mac.

The new MSQuery experience is very similar to the SQL Query Analyzer that many of you have worked with. On the left is a listing of the databases and tables in your database that you can explore. At the top right is a color-coded SQL editor, and at the bottom right are the results of any query you run. Simply enter a SQL statement, click Run Query to make sure it works. Once it does, click Return Data to drop your data right back into your worksheet. And that’s it; your data is now in your Excel workbook, live and ready to use in Excel 2016 for Mac or Excel for Windows!

Working with a third-party data provider works the exact same way. The only difference is that after installing the data provider, you select New Database Query > From Database and then select your data provider from the Apple iODBC manager.

Now it’s your turn!

We think we’ve made huge strides in making external data easier than ever in Excel 2016 for Mac and we hope you do too. Give it a try and let us know of any questions or feedback you have in the comments!