To indent a bullet point in Excel, put a bullet character at the start of a cell’s text, select the cell, and choose Home > Increase Indent. This moves the cell’s contents inward; it does not create a separate, adjustable indent for each line in the cell. For best results, put each bullet item in its own cell or row, then set the indent level you want.
What You’ll Need
- Excel for Microsoft 365 on Windows, or Excel for Mac or the web if you are using a different platform.
- A worksheet with the cells where you want the list to appear. A column with one item per row is easiest to format and maintain.
- A bullet character (•). You can copy the character shown here and paste it into a cell, or insert it from Excel’s Symbol dialog.
Step-by-Step
- Choose a layout for your list. For a straightforward list, place one bullet item in each cell down a column. For example, use A2 for the first task, A3 for the next, and A4 for the third. Keeping each item in a separate cell makes it possible to indent selected items independently, sort the list, and adjust row heights without affecting the rest of the list. If you need a bullet list inside one cell, you can do that too, but every line in that cell shares the same cell-level indent.
- Enter the bullet and the item text. Click the first cell and type or paste a bullet character, add a space, then type the item. For example, enter “• Prepare agenda” in A2. To add a bullet to a cell that already contains text, press F2 or double-click the cell, move the insertion point to the beginning, type or paste the bullet and a space, and press Enter. Avoid entering the bullet in a separate cell unless you want the bullet and text to occupy separate columns.
- Insert a bullet from Excel if you prefer not to paste one. Select the target cell and open Insert > Symbol > Symbol. In the Symbol dialog, choose a font that includes the bullet, such as Segoe UI Symbol, select the bullet character, and choose Insert. Close the dialog, then type a space and the item text. If the dialog is not available in your Excel version or the symbol is hard to find, copying and pasting • into the cell is a simple alternative. The dialog inserts a character; it does not turn the cell into a Word-style bulleted paragraph.
- Set the cell to left alignment. Select the cell or range, then choose Home > Alignment > Align Left. This gives the bullet and its text a consistent starting edge, which makes the indent easier to judge. If the cell is set to right alignment or centered alignment, the contents may appear to move in an unexpected direction or look uneven. You can also use Home > Alignment > Top Align if you are formatting tall cells with wrapped text.
- Apply the indent. Keep the cell or range selected and choose Home > Alignment > Increase Indent. Each click adds another indent level. Click once, check the result, and click again only if the list needs to sit farther from the cell’s left edge. The button changes the cell’s alignment indent; it does not add spaces to the text, alter the bullet character, or indent only the line where the cursor happens to be.
- Format several items at once when they need the same indent. Select the cells containing the items, then click Increase Indent once. To select a continuous range, click the first cell, hold Shift, and click the last cell. To select separate cells, hold Ctrl while clicking them on Windows; on Mac, use Command-click. Applying the same level to the selected cells keeps a list visually consistent. Check that your selection includes only the items you want to move.
- Make a second level for sub-items. Put each sub-item in its own cell or row, then select those cells and click Increase Indent one more time than you did for the main items. For example, indent the main items once and their sub-items twice. Use the same bullet symbol for a simple hierarchy, or choose another symbol for sub-items if that distinction helps readers. Excel’s Increase Indent control applies to the whole cell, so separate rows are the practical way to set different levels within one list.
- Wrap long items and check the row height. If text runs beyond the visible cell, select the cells and choose Home > Alignment > Wrap Text. Adjust the column width or use Home > Format > AutoFit Row Height if some lines are hidden. With wrapped text, Excel displays later lines inside the cell, but the cell’s indent is still shared by all of its contents. Review the worksheet in Normal view and, if it will be printed, use Print Preview to check that bullets and wrapped lines are visible.
- Repeat the format without rebuilding the list. For another group with the same layout, select a correctly formatted cell and use the Format Painter on the Home tab, then apply it to the destination cells. You can also copy and paste a formatted cell before replacing its text. After using either method, confirm that the destination cells have the intended alignment, indent level, and wrap setting; copied formats can bring those settings along even when you only meant to copy the text.
Common Mistakes
Expecting Increase Indent to affect just one line. In Excel, the indent setting belongs to the cell. If a cell has several lines separated by manual line breaks, clicking Increase Indent moves the contents of that cell together. Put items on separate rows when you need different indent levels, or use a word-processing app if you need paragraph-by-paragraph list controls.
Adding spaces to imitate an indent. Leading spaces can look acceptable at first, but the result depends on the font and may shift when you change the font, column width, or alignment. Spaces can also make sorting and editing awkward. Use the Increase Indent button for a real cell indent, and keep the bullet and text together in the same cell.
Forgetting that the bullet is ordinary text. Excel does not automatically add a bullet when you press Enter in a cell or move to the next row. You need to type or paste the symbol for each item, or copy a cell that already contains it and replace the item text. When pasting a list from another program, check that the bullet characters came across and are not just decorative formatting that Excel dropped.
Selecting the wrong cells or too many indent levels. Increase Indent changes every selected cell. If a heading or neighboring data is included in the selection, it will move too. Likewise, clicking the button repeatedly can push text too far into a narrow column. Select carefully, apply one level at a time, and use Decrease Indent if you go too far.
Assuming the indent also solves wrapping. Indenting reduces the space available for text inside the cell, so an item may wrap sooner. It does not automatically make the row tall enough to show every line in every layout. Turn on Wrap Text and check row height, especially before printing or sharing the workbook.
Tips
- Use a dedicated list column. A separate column keeps the bullets away from dates, amounts, or notes and makes it easier to adjust the column width without disturbing unrelated data.
- Choose a consistent visual hierarchy. For instance, use one indent level for main points and two for supporting points. If you also vary bullet symbols, do so consistently so that the symbol and indent both communicate the same level.
- Keep the bullet character and text in one cell. This helps the item move as a unit when you sort or copy rows. If the bullet is in one column and the wording is in another, sorting only one of those columns can separate them.
- Use line breaks only when a single cell is necessary. To start a new line while editing a cell on Windows, press Alt+Enter. In Excel for Mac, press Control+Option+Return. Turn on Wrap Text so the lines display. Remember that the cell’s indent applies to all those lines, not only the line after the break.
- Use the control rather than the ruler or the space bar. Excel cells do not provide Word’s paragraph ruler and list-indent markers. The Increase Indent and Decrease Indent buttons in Home > Alignment are the reliable built-in controls for shifting cell contents.
- Check your layout at the final column width. A bullet list that looks neat in a wide editing view may wrap awkwardly when the column is narrowed. Set the width first, then refine the indent, wrap setting, and row height.
Troubleshooting
The text does not move when I click Increase Indent. First confirm that the intended cell is selected and that you are clicking Home > Alignment > Increase Indent, not Decrease Indent. Set the cell to Align Left, then try again. If the cell is merged, protected, or part of a layout with unusual alignment settings, test the same action in an ordinary, unmerged cell to isolate the issue. If the sheet is protected, you may need permission to change its formatting.
The text moves, but the bullet seems too far from the words. The indent moves the cell contents, while any space after the bullet remains part of the typed text. Edit the cell and remove extra spaces after the bullet, leaving one. If the gap still looks large, check whether the cell uses a proportional font or whether you accidentally added a tab or several spaces.
Only part of my list is indented. That is usually because the selection covered only some of the item cells. Select the full range and click Increase Indent once. If the cells already have different levels, use Decrease Indent or Increase Indent carefully to bring them to the same level; the buttons change the selected cells’ existing settings rather than setting a named level for the entire range.
The bullet displays as a box or question mark. The selected font may not contain that character, or the symbol may have been converted during a paste. Change the cell font to one that supports the bullet, such as Segoe UI Symbol, and insert or paste the symbol again. If you received the workbook from another person, try copying the bullet from a cell where it displays correctly.
Wrapped text or lower lines are hidden. Select the affected cells and choose Home > Alignment > Wrap Text, then use Home > Format > AutoFit Row Height. If the row height was set manually, drag the row boundary to make it taller. Also check whether a neighboring merged cell is preventing the row from resizing as expected.
I cannot find the same button on my device. In Excel for Mac, look on the Home tab in the Alignment controls; the ribbon may arrange or label the controls differently depending on window size. In Excel for the web, use the Home tab’s alignment controls, and expand the ribbon if it is collapsed. On a small screen, buttons may be hidden in a menu. The basic result is the same: select the cell, then increase its indent.
Frequently Asked Questions
Does Excel have a keyboard shortcut for Increase Indent?
There is no standard, dependable Excel keyboard shortcut for the Increase Indent ribbon button. Use Home > Alignment > Increase Indent. You can use the ribbon’s keyboard access keys on Windows, but the key sequence can depend on the ribbon and language configuration, so the visible button is the clearest method.
Can I indent only one bullet in a cell?
No. Excel’s indent setting applies to the entire cell, including all lines created with Alt+Enter. Put each bullet in a separate cell or row if items need different indent levels. For detailed paragraph-level bullet formatting, create the list in Word or another word processor.
Can I make a nested bullet list in Excel?
Yes, by placing each main item and sub-item in a separate cell or row and applying different indent levels. For example, give main items one click of Increase Indent and sub-items two clicks. Add the bullet symbols as text; Excel will not automatically create or number nested list levels.
Will the indent change how the worksheet prints?
Yes. The cell’s text is positioned farther from its edge, which can leave less room for the words and cause extra wrapping. Check Print Preview, page orientation, column width, and row height before printing. The indent setting stays with the cell when the workbook is saved.
Can I remove an indent after applying it?
Yes. Select the affected cell or cells and choose Home > Alignment > Decrease Indent until the text returns to the desired position. If the cells have different indent levels, check them after each click because one decrease may not make every cell match.
Is this the same in Excel for Mac and Excel for the web?
The basic approach is the same: add the bullet character, select the cell, and use the Home tab’s indent control. Ribbon placement can vary with the available window width. To insert a line break inside a cell, use Control+Option+Return on Mac rather than Windows Alt+Enter.
Related
- Insert a Personal Signature in Word 365
- Insert a Line in Word or Google Docs: Quick Steps
- Insert a Functional Checkbox in Word: Clickable Options
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Page Break in an Excel Cell: What Excel Really AllowsExcel cannot place a print page break inside a cell: a page break separates printed worksheet pages at…
- Conditional Formatting Excel: Color an Entire RowYes. To color an entire row in Excel based on one cell, select the rows you want formatted,…
- Google Sheets Data Validation for Duplicate EntriesYes. Google Sheets can reject duplicate entries with a custom-formula data validation rule: for a list in A2:A,…
- How to Get Rid of All Track Changes in Microsoft WordTo get rid of tracked changes in Word, choose whether to keep or discard the proposed edits, then…
- How to Sort A to Z in Google Sheets Without ErrorsTo sort a list A to Z in Google Sheets, select the full range of related cells, open…
- How to Block a Sender in Microsoft Outlook on Any DeviceTo block someone in Outlook, select one of their messages, open the message options, and choose Block or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.