contador web Saltar al contenido

How to add markers in Excel spreadsheets | Productivity

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 / TechTudoTutorial shows how to insert markers in Excel Photo: Carolina Ochsendorf / TechTudo

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 LoubakPress shortcut Alt + 7 to insert markers in Excel Photo: Reproduction / Ana Letcia Loubak

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 LoubakDrag marker to other Excel cells Photo: Reproduction / Ana Letcia Loubak

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 LoubakEnter list items Photo: Reproduction / Ana Letcia Loubak

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 LoubakTry other keyboard shortcuts to insert different bookmarks in Excel Photo: Playback / Ana Letcia Loubak

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 LoubakInsert symbols in Excel spreadsheet Photo: Reproduction / Ana Letcia Loubak

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 LoubakChoose a symbol from the list provided by Excel Photo: Reproduction / Ana Letcia Loubak

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 LoubakCopy lists from Microsoft Word Photo: Reproduction / Ana Letcia Loubak

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 LoubakPaste the list into a single Excel cell Photo: Reproduction / Ana Letcia Loubak

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 LoubakPaste list items into separate Excel cells Photo: Reproduction / Ana Letcia Loubak

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

How to watermark Microsoft Excel spreadsheets

4.8 (96%) 50 votes