Alt Key Shortcuts Symbol Categories. Hatsune Miku Android Widget. Below table shows the complete list of Alt key shortcuts with search function. By default the table is sorted with the first. Excel Keyboard Shortcuts TOC 2 E CELET Productivity How to move around big lists fast win Use the fill handle to enter data with patterns How to use drag and drop. Why use keyboard shortcuts in Excel The good thing about memorising this keyboard shortcut is that you dont need to hunt for each menu item, as these might look. Excel Shortcuts Keys List 2010 Pdf' title='Excel Shortcuts Keys List 2010 Pdf' />The Ultimate Guide to Bullet Points in Excel Launch Excel. Would you like to know how to insert a bullet point in ExcelCreate custom keyboard shortcuts for the paste special commands like paste values using the Paste Buddy Excel Addin. Fast and easy keyboard shortcuts. Are you looking for Excel examples Are you looking for clear explanations that help you master many Excel features quickly and easily Then this section is for you. Excel Shortcuts Keys List 2010 Pdf' title='Excel Shortcuts Keys List 2010 Pdf' />For a long time I thought there was only one way to do this type a lower case letter l in the font Wingdings to insert a round bullet point character. But now I know that Excel is such a versatile bit of software, theres always more than one way to do something with Excel. So I decided to set out and find new ways to create bullet points in Excel. I discovered five different ways to add bullets in Excel and Ill show you them in depth. Plus there are 5 fab videos to watch. Bullet points in Excel. Excel Shortcuts Keys List 2010 Pdf' title='Excel Shortcuts Keys List 2010 Pdf' />Well look at 5 different ways to add bullet points in Excel, starting with the fastest and ending with the most creative. Type a bullet using ALT key combinations. Type a bullet using special fonts like WingdingsAdd a bullet with custom cell number formatting. Insert bullets using a Text box. Create your bullets with Smart. Art. If you know of other ways that I didnt mention, please share in the comments. In cell bullet points in Excel with the ALT key. This is the simplest and fastest way of adding bullet points in Excel. You hold down the ALT key and then type one of the following numbers using the number keypad thats the one on the right hand side of the keyboard. ALT 7 is my personal favorite for adding a round bullet in Excel. If youre using a laptop you will need to turn on the number keypad feature because this tip doesnt work with the row of numbers above your alphabet keys. Heres a one minute video showing this in action tubepress videoq. Phorzo. FY. Do you like free Excel tips If youre interested in receiving updates about future Excel tips from Launch Excel, take this chance to sign up for my RSS feed by clicking on the orange RSS icon to the right. Its free and easy to sign up, and youll be able to read my content hot off the press Bullet in Excel using special fonts. Method number 2 allows you to get quite fancy with your bullets. You must first pick a font with lots of symbols in it e. Wingdings and then type in a character to use as the bullet. As you can see from the picture below, there are a lot of good bullet point symbols in Wingdings which is why I suggest using Wingdings for bullet points So lets say we want to add a bullet using the Wingdings font. Here are three ways to do it Type the character straight in Change the font to Wingdings, and type the matching letter to add a bullet character. For example if you type lowercase letter l you get a round bullet point symbol. This only works if you can type the character using your keyboard. On standard keyboards youve got around 1. Use the CHAR function To access all 2. Wingdings font, you can type in the formula CHARnnn where nnn is the character number you want to insert. Refer to the picture above for some starter ideas. Insert a symbol via the Excel menu or ribbon In Excel 2. Insert Menu, find the Symbols group, click on Symbol to insert a symbol, then select the font and symbol of your choice. Excel shows you a map of all the available characters and you can page up and down to find a suitable character. As I said before, using a special font allows you to create fancy bullets because you can pick from a huge range of characters. But on the downside its slower than just typing ALT 7. You can watch me talk through the three options in my two minute video tubepress videodr. H 7. 38n. XLc. Use custom cell formatting to insert Excel bullet. Excel gives you the option of changing the Number format for each cell. Using this feature its possible to insert a bullet in front of any text you type in a cell. The advantage of this method over the previous two methods is that you only need to type in the bullet one time to define your custom bullet format. After you define your custom bullet format, you can copy it to other cells and hey presto you immediately have bullet points in those cells without having to type anything. Select your cell, right click and select Format Cells. Select Category Custom. Click inside the Type box and enter the following text1 Hold ALT then type 7 on the numeric keypad to insert a bullet point2 Type a space to insert a blank space3 Type in as a placeholder for the text. The result is that you have defined a custom number format for your bullet point lists. Note that if you apply this custom format to a blank cell you dont see a bullet until you write some text. So if you want bullets followed by empty space then you should either insert a space or use the single quote character to tell Excel that the cell contains text. You can also indent your bullet points to add different levels, for example level 1 text is your main text then level 2 text is indented as your supporting text. Watch my two minute video to see this in action. UZIB8. Tc. Ok. Note 1 How to apply custom formats to multiple cells. You can copy and paste a custom cell format using the Format Painter. In Excel 2. 01. 0 you can find this on the Home tab, inside the Clipboard group. Or you could right click on a cell thats got custom formatting, and this brings up the context menu with a button for the format painter. I show how to use the Format Painter in my short video above. Note 2 The Keyboard Shortcut to Format Cells is CTRL 1. A pretty handy keyboard shortcut is CTRL 1. You can use it instead of right clicking on a cell to access the Format Cells option. This brings up the Format Cells dialog box so you can define your own custom number formatting, or play around with cell borders and text alignment. Select the cells you wish to format. Hold the Control key, then press 1 CTRL 1This brings up the Format Cells dialog box. Text box bullets in Excel. If youre adding notes to an Excel worksheet, you can put the text in a textbox instead of using the cells. And in a textbox there are some nice formatting options, including a built in bullets command. To add bullets to your text boxes in Excel 2. Bullets. Then select the bullet style that you want. Or click the Bullets and Numbering command to see more options. Heres a one minute video showing this in action tubepress videon. Jz. Ow. W5. 0. 5 Smart. Art bullets in Excel. Finally we get to the creative part where you can let yourself loose and create your own Smart. Art complete with bullets in Excel. This works for Excel 2. Excel dont have Smart. Art. For this to work you need to find a Smart. Art graphic that includes bullet points in its design. There is no way to add them if they are not in the shape already. This means you need to browse around to find the right graphic. To give you some ideas here are some examples that I created in a couple of minutes using Smart. Art Lets say you are starting from scratch. Here are the steps in Excel 2. Add a new Smart. Art graphic by clicking on the Insert menu, and clicking on Smart. Art. Click the Smart. Art graphic that you want to add. While the Smart. Art is selected, add text to the text pane. Bullets are automatically added as you type text into level 2 text. Craft your Smart. Art by playing around with the options until its just how you want it. Note that if you add text but dont see any bullets, its time to choose another Smart. Art graphic. This is because the layout for the Smart. Art graphic controls whether there are bullets in the shape. Sadly you cant style the bullets that you create with Smart. Art. The styling is determined by the Smart.