Mac: Press Option + 8. Windows: If you have a numeric keypad on the side of your keyboard, hold down the Alt key while pressing 7 on the keypad. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source If not, click the Insert menu, select Symbol, type 2022 into the “Character code” box at the bottom, and then click Insert. If 2022 didn’t bring up a bullet point, select the Wingdings font instead, and then enter 159 as the character code. You can then click Insert to add the bullet point.
If you have a numeric keypad on the side of your keyboard, hold down the Alt key while pressing 7 on the keypad. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source If not, click the Insert menu, select Symbol, type 2022 into the “Character code” box at the bottom, and then click Insert. If 2022 didn’t bring up a bullet point, select the Wingdings font instead, and then enter 159 as the character code. You can then click Insert to add the bullet point.
If you want your list to be numbered, preface the first list item with 1. or 1).
If you want your list to be numbered, preface the first list item with 1. or 1).
If you want your list to be numbered, preface the first list item with 1. or 1).
If you create a bulleted list in Word, the bullets will copy over to your cell when pasted into Excel. Bullets may not copy from other apps.
After you create the list on a separate sheet and add it to a table, you’ll be able to create a drop-down list containing the list data in any cell you want.
After you create the list on a separate sheet and add it to a table, you’ll be able to create a drop-down list containing the list data in any cell you want.
If you plan to make a lot of drop-down menus and want to use this same sheet to create all of them, add a header to the top of the list. For example, if you’re making a list of cities, you could type City into the first cell. This header won’t actually appear on the drop-down list you create—it’s just for organization on this sheet that contains list data.
Now that your list is in a table, you can make changes to it after creating your drop-down list, and your drop-down list will update automatically.
Now that your list is in a table, you can make changes to it after creating your drop-down list, and your drop-down list will update automatically.
