Excel does not offer a specific tool for inserting bullets, but you can add them to cells with a few simple tricks. Users have the option of using keyboard shortcuts, copying bulleted lists from Word, or taking advantage of the program's symbol collection, for example. The tip helps you make lists in Excel and make them more organized and easier to read. See the following tutorial for inserting markers in Excel.
READ: Excel: See ready-made spreadsheets that make your life easier
Tutorial shows how to insert markers in Excel Photo: Carolina Ochsendorf / TechTudo
Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo
Bookmarks with keyboard shortcuts
Step 1. Open Excel and select the cell where you want to insert the marker. Then press the Alt + 7 keys;
Press shortcut Alt + 7 to insert markers in Excel Photo: Reproduction / Ana Letcia Loubak
Step 2. Rest the cursor over the lower right edge of the cell until a "+" sign appears. Hold down the mouse button and drag the marker to the other cells;
Drag marker to other Excel cells Photo: Reproduction / Ana Letcia Loubak
Step 3. Write the items you flip after the markers;
Enter list items Photo: Reproduction / Ana Letcia Loubak
Step 4. Try different markers from the shortcuts listed below.
Try other keyboard shortcuts to insert different bookmarks in Excel Photo: Playback / Ana Letcia Loubak
Labels with the "Symbol" option
Step 1. With the spreadsheet open, navigate to the "Insert" tab and then select "Symbols";
Insert symbols in Excel spreadsheet Photo: Reproduction / Ana Letcia Loubak
Step 2. In the "Subset" option, select "Overall Score" and choose the bullet type marker. Press the "Insert" button to add it to the cell. You can also add other symbols by scrolling down or up in the displayed list.
Choose a symbol from the list provided by Excel Photo: Reproduction / Ana Letcia Loubak
Copy bookmarks from Word
Step 1. If you have already created a bulleted list in Microsoft Word, you can easily transfer it to Excel. To do so, open the text editor, select the desired items and press the shortcut Ctrl + C;
Copy lists from Microsoft Word Photo: Reproduction / Ana Letcia Loubak
Step 2. If you want to insert the entire list into a cell, double-click the cell and press Ctrl + V;
Paste the list into a single Excel cell Photo: Reproduction / Ana Letcia Loubak
Step 3. To place the list items in separate cells, click the cell where you want the first item to appear and press Ctrl + V.
Paste list items into separate Excel cells Photo: Reproduction / Ana Letcia Loubak
How to copy formula in Excel by changing worksheet number? Ask questions on the TechTudo forum.
How to watermark Microsoft Excel spreadsheets