No one truly knows the origin of the phrase ‘bullet point’ but some say they came about because it was too much trouble to renumber a list once edited on a typewriter. Important: You can override the browsers Alt-based ribbon shortcuts by changing a setting in the Keyboard Shortcuts dialog. For example, to go to the Review tab, press Alt+Windows logo key+R. The Alt-8 shortcut back then would have blown their minds! The symbol for a bullet list can vary from a dash to a little black heart to a tiny cross. In Excel for the web, access keys all start with Alt+Windows logo key, then add a letter for the ribbon tab. To add a Text Box go to the Insert ribbon, Text group, Text Box. ADDING BULLETS TO A TEXT BOX IN EXCEL There are a couple of options when adding bullets to a text box in Excel. Repeat this sequence to add as many bullets as needed to the cell. 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. Press Alt-0-1-4-9 then, upon lifting the Alt key you’ll see a delicious bullet point. Use the Alt keyboard sequence, ensuring that the num lock is open. To create the bullet point shortcut on a PC you’ll need to be a bit more dexterous. Use re-sized cells and Icon Fonts (ie Wingdings, Webdings, etc. Think of it as the alternative to the asterisk (which lives on the 8 key on most keyboards). Copy and paste the below bullet point into your spreadsheet: 4. In the day of the typewriter people would type a lowercase ‘o’ and then fill it in with ink. next line, enter the bullet keystrokes to get a second bullet on the next line. How to insert bullet points in Excel using keyboard shortcuts. Keyboard Shortcut: Alt + 7 (number must be from your number pad) 2. Now you have a bullet point shortcut for Word or Office on PC.īullets have been around for a while. Click the press new shortcut key box and type in your shortcut. Now choose formatting from the categories list then in the commands list choose format bullet default. To find this choose tools/customise/keyboard (pre Word 2007) and Office/ Word options/customise. If you feel it will pay off you can build your own shortcut.

Ok, but what if you want an actual formatted list? On Mac you’re in luck for MS Office, for Windows you may have consistency issues going between versions.

Keyboard shortcut bullet point excel