Last week, Bob Ryan sent me a Student Budget workbook, and he had the instructions in formatted textboxes, including bullet points. In a textbox, there are a few more formatting options, including a Bullets command.
![how to display hidden text in word 2011 how to display hidden text in word 2011](https://i.ytimg.com/vi/evJn_uEoYPk/maxresdefault.jpg)
If you’re adding notes for the people who will use the file, you can put the text in a textbox that will float over the worksheet, instead of entering your notes in the cells. There is another way to add bullets to an Excel worksheet. In the list shown below, there is no bullet in cell A5, because cell B5 is empty. Type something in cell B4, and the bullet appears. When you press Enter, no bullet will appear in the cell, because cell B4 is empty. For example, type this formula in cell A4: Using a formula gives you more flexibility - you can make a rule for when the bullet should appear. When you press Enter, a bullet will appear in the cell, just like the one from the keyboard shortcut. You can add bullets with a formula too - just use the CHAR function, and refer to either of the numbers that we used in the shortcut keys above.įor example, in cell A4, type this formula: =CHAR(7) If you’re using a laptop that doesn’t have a separate keypad for numbers, you can use the special keys to activate the “number keypad” section of the keyboard.Īfter you type the bullet shortcut, you can format the cell to Align Right, so the bullet is close to the text in the adjacent column. NOTE - This shortcut only works if you type the numbers on the Number keypad – it doesn’t work if you use the numbers at the top of the keyboard (above the letters).
#How to display hidden text in word 2011 how to
Even though they’re not built in, keep reading, to see how to add bullets in Excel.įortunately, you can add a bullet to a cell with either of the following keyboard shortcuts:
![how to display hidden text in word 2011 how to display hidden text in word 2011](https://support.content.office.net/en-us/media/b69e56d7-f841-4eca-9f42-ddd75ec0c1e3.png)
Bullets are a handy feature when you’re making a list, so it would be nice to use them occasionally, in our Excel files.
![how to display hidden text in word 2011 how to display hidden text in word 2011](https://cdn.extendoffice.com/images/stories/doc-word/show-hide-hidden-text/doc-show-hidden-text-02.png)
There’s no built-in feature for bullets in Excel, like there is in a Word document.