How to Copy and Paste Bullet Points in Excel Cells

How-to basics · Updated November 20, 2026

To copy bullet points in Excel, select the cell or cells that contain them, press Ctrl+C, select the destination, and press Ctrl+V. Excel copies the bullet character along with the cell contents; it does not have a built-in bulleted-list button like Word. If you need a bullet that is not already in a cell, insert or type the bullet character first, then copy it with its text.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or Excel for Mac or the web if that is where you work.
  • A source cell with the bullet points you want to copy, or a way to insert a bullet character.
  • A destination cell or range. If you need to keep existing content or formatting there, decide whether to paste the whole cell or only its text.

Bullets in Excel are usually ordinary characters, such as •, at the start of cell text. They are not separate list items with the same structure as a Word list. That distinction matters: copying a cell carries its contents and may carry formatting, while copying text alone avoids replacing the destination cell’s other properties.

Step-by-Step

  1. Find the bullet point you want to copy. Click the cell once and look at the formula bar to confirm that the bullet is part of the cell’s contents. A cell might contain one item, such as • Check the totals, or several lines separated by line breaks. If the bullet appears only because of a custom number format or another display setting, copying the cell may not copy a literal bullet character. Check the formula bar before proceeding.
  2. Select the right amount of content. To copy everything in one cell, click that cell. To copy a group, drag across the cells or click the first cell, hold Shift, and click the last cell in the range. For nonadjacent cells, hold Ctrl while selecting on Windows; on Mac, hold Command. Copying whole cells is the simplest method when you want to preserve multiple bullets or a whole column of bullet entries.
  3. Copy the selection. Press Ctrl+C on Windows. On Mac, press Command+C. A moving dashed border around the source usually indicates that Excel has copied it. You can also choose Home > Copy on the ribbon, or right-click the selection and choose Copy. Leave the selection in copy mode until you have chosen where the material should go.
  4. Choose the destination cell or range. Click a blank cell if you want to place a duplicate elsewhere. If you are copying a range, click the top-left cell of the destination area; Excel fills the corresponding rows and columns. Make sure the destination range is large enough and does not contain information you need to keep. Pasting over occupied cells replaces their contents.
  5. Paste the bullet points. Press Ctrl+V on Windows or Command+V on Mac. The copied cell contents, including literal bullet characters and line breaks, should appear in the destination. If you copied several cells, they will paste as a matching block. Check the result rather than assuming the source and destination have the same row heights, column widths, or formatting.
  6. Choose how much to preserve, if needed. Pasting normally can bring over the source’s formatting as well as its contents. To paste only the text and bullet characters, use Home > Paste > Values when that option is available in your Excel version. You can also right-click the destination and inspect the Paste Options icons; hover over an icon to see its label. If you want the source’s appearance too, use the regular paste option. The exact set of icons can vary by Excel version and by what you copied.
  7. Copy only a bullet within a longer cell when appropriate. Double-click the cell or select it and press F2 on Windows to edit its contents. Select the text you need, including the bullet, and press Ctrl+C; then press Esc to leave edit mode without changing the source. Click the destination and paste. You can also select text in the formula bar. On Mac, edit the cell by double-clicking or using the formula bar, then use Command+C and Command+V. If selecting part of the text is awkward, copy the full cell to a temporary blank cell and remove unwanted text there.
  8. Verify the pasted result. Click the destination and inspect the formula bar to check that the bullet is really there. If the text is clipped, widen the column, turn on Home > Wrap Text, or increase the row height. If you copied multiple bullet lines into a single cell, click in the formula bar or edit the cell to confirm that each line remains on its own line.

Adding a bullet before copying

If there is no source bullet, enter one as a character. In Excel for Microsoft 365 on Windows, click the cell, press F2 or click the formula bar, place the cursor where the bullet should go, and hold Alt while typing 0149 on the numeric keypad. Release Alt, type a space, and enter the item text. The numeric keypad matters; the number row above the letters may not produce the character. Another dependable route is Insert > Symbol: choose a font and bullet character, select Insert, and close the dialog. You can then copy that cell using the steps above.

On a Mac, Option+8 commonly types a bullet character. If that keystroke does not work with your keyboard layout, use Insert > Symbol if available in your Excel version, or copy a bullet character from an existing cell. In Excel for the web, keyboard character entry can depend on the browser and operating system; inserting or copying an existing bullet is often the more predictable approach. After entering a bullet, type a space so the text is easy to read.

Putting several bullets in one cell

To keep a short list together in one cell, type the first bullet and its text, then insert a line break inside the cell. On Windows, press Alt+Enter while editing the cell. On Mac, use Control+Option+Return to insert a line break in Excel for Mac. Type the next bullet and its text, and repeat as needed. Turn on Home > Wrap Text so the lines display, then copy the whole cell. If you want each item in a separate worksheet row instead, put each bullet in its own cell and copy the range; that is easier to sort, filter, and work with later.

Common Mistakes

  • Copying the wrong thing: Clicking a cell and copying it copies the cell, not just the visible characters. That may also bring formatting, formulas, or other cell properties. Use a values-only paste or copy selected text when you only need the bullet and words.
  • Overwriting destination content: A regular paste replaces what is in the selected destination cells. If the target is not empty, copy to a blank area first or make a backup. Pasting does not automatically insert the copied text into the middle of another cell.
  • Expecting Excel to create a list: A bullet character is plain text. Excel will not automatically add a new bullet when you press Enter as Word may do. For a new line in the same cell, use the line-break shortcut and type another bullet yourself.
  • Using the wrong Alt-key method: Alt codes generally need the numeric keypad on Windows and may be affected by keyboard settings. If Alt+0149 does not work, use Insert > Symbol or copy a bullet from another cell instead.
  • Confusing clipping with missing text: A narrow column or short row can hide part of a cell’s contents without deleting it. Check the formula bar before retyping anything, then adjust the column, row, or Wrap Text setting.

Tips

  • Keep a reusable source cell. Store a bullet character or a commonly used bullet phrase in a spare cell. Copy it when needed instead of re-entering the character, especially if you use a keyboard layout where Alt codes are inconvenient.
  • Use the fill handle for repeated entries. If you want the same bullet text repeated down a column, copy the cell and paste into the selected range, or drag the small square at the lower-right corner of the selected cell. Check the filled cells afterward: relative formulas may adjust, while ordinary text is repeated.
  • Match the paste method to the task. Use a normal paste to duplicate a finished cell. Use values-only paste to retain the destination’s formatting while bringing over content. Use the Format Painter only when you want to copy appearance, not the bullet text.
  • Make long lists readable. Select the cells and choose Home > Wrap Text. Adjust column width and row height so the bullet and all of its text can be seen. A line break in the cell does not automatically make the row tall enough in every layout.
  • Keep data manageable. Put each bullet item in a separate row if you will sort, filter, count, or edit items individually. Keep multiple bullet lines in one cell when they are simply notes that belong together.
  • Use the matching Mac shortcuts. Windows uses Ctrl+C and Ctrl+V; Mac uses Command+C and Command+V. The ribbon and context-menu options are also available if a shortcut is intercepted by another app or remote desktop.

Troubleshooting

The bullet disappears after pasting. Check the formula bar. If the bullet is not present there, it may not have been part of the copied content, or the copy selection may have been wrong. Return to the source, edit the cell, and confirm that the bullet is a character at the start of the text. Copy the cell again. If it is present in the formula bar but not easy to see, check the font, font color, and cell formatting.

The paste changes the destination’s appearance. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if you have not made other changes you want to keep. Copy the source again, select the destination, and choose a values-only option from Home > Paste or the right-click Paste Options. This usually retains the target’s formatting while transferring the cell value. If you need to preserve formulas or formats, select the appropriate paste option rather than assuming all paste choices behave alike.

The bullet and text run together. Edit the cell and add a space after the bullet. If you meant to create separate lines, insert a line break inside the cell with Alt+Enter on Windows or Control+Option+Return on Mac, type the next bullet, and enable Wrap Text. If the pasted text came from another program, check whether it used paragraph marks or tabs that Excel interpreted differently.

Several copied items land in unexpected cells. Clipboard content with tabs or line breaks can be interpreted as a grid when pasted into Excel. If you want all the content in one cell, first enter edit mode in the destination by pressing F2 or clicking the formula bar, then paste the text there. If you intended a grid, confirm that the copied range and destination start at the correct cells. In Excel for the web, browser clipboard permissions or formatting from the source application can also affect paste behavior; try copying directly within the workbook or use the ribbon’s Paste command.

The bullet key combination produces a different character. Keyboard layouts and numeric-keypad availability vary. Do not keep repeating an uncertain code over valuable content. Use Insert > Symbol, copy a known bullet from another cell, or use the Mac Option+8 shortcut where it is supported. Save or undo as appropriate if an unwanted character was inserted.

Frequently Asked Questions

Can I copy and paste a bullet point from Word into Excel?
Yes. Copy the bullet text in Word, select a cell in Excel, and paste. Check the result because formatting may differ, and multiline text may spread across rows or columns depending on the copied content. If it lands in separate cells but should be in one, edit the destination cell and paste into the formula bar or while editing.

How do I copy only the bullet character, not the whole cell?
Edit the cell or use the formula bar, select the bullet character itself, and copy it. Then edit the destination text and paste where you want the character. If selection is difficult, copy the whole cell to a temporary blank cell and delete the text you do not need.

Can I paste multiple bullet points into one Excel cell?
Yes. Put each item on a separate line within the cell using Alt+Enter on Windows or Control+Option+Return on Mac, with a bullet character at the start of each line. Turn on Wrap Text so the lines display. Separate cells are usually better if you need to sort or filter the items.

Why does Excel paste the bullet into a different cell?
The copied material may contain tabs or line breaks, which Excel reads as columns or rows. Edit the target cell before pasting if you want the material kept as one cell’s text. If the source is a range, check its shape and select the correct top-left destination cell.

Does Excel have a bullet-list button?
Excel does not provide the same automatic bulleted-list control as Word. You can insert bullet characters as text, use a line break for multiple items in one cell, or keep each item in its own cell. Copying an existing bullet cell is often the quickest way to reuse the same character and formatting.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.