{"id":262343,"date":"2024-03-13T20:07:15","date_gmt":"2024-03-13T19:07:15","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=262343"},"modified":"2026-10-06T16:22:47","modified_gmt":"2026-10-06T14:22:47","slug":"ajouter-des-puces-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/how-to-add-bullet-points-in-google-sheets\/","title":{"rendered":"Comment ajouter des puces dans Google Sheets (4 m\u00e9thodes)"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

While Google Docs and Google Slides have built-in tools to insert special characters, Google Sheets works a little differently. You may have tried searching through the menus to find that option, but it simply isn\u2019t there. Fortunately, this doesn\u2019t mean you can\u2019t do it, as there are at least four ways to add bullet points to your Google Sheets. First, you can copy and paste the bullet points, use a shortcut, or use the CHAR function. Additionally, you can use custom number formats<\/a>, which affect how the cell\u2019s contents are displayed without affecting the contents themselves.<\/p>\n

In this guide, you will learn four different ways of adding bullet points in Google Sheets. Depending on your needs, some methods are more appropriate than others. For example, if you\u2019re typing the list and want to add the bullet points as you type, the shortcut and the copy & paste method are probably the most useful.<\/p>\n

However, if you already have a long list of items in Google Sheets, the CHAR function and the ampersand (&) can help you quickly rewrite the list with bullet points. Finally, if you only want to display the bullet points without adding them to the cells, you can use a custom number format. You have step-by-step instructions on all four methods, so you can decide how you want to add your bullet points in Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-insert-bullet-points-in-google-sh” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to insert bullet points in Google Sheets: copy & paste<\/h2>\n

You can copy bullet points – or any other character – from a different program and paste them into Google Sheets. For example, the tool that allows you to insert special characters in Google Docs features a wide selection of possible bullet points. You can then copy the one you want and start creating your list in Google Sheets.<\/p>\n

1.<\/strong> Find a bullet point you like and copy it. For example, if you use Google Docs, go to Insert > Special characters and insert the bullet point you want to use.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/bullet-points-google-sheets-docs-special-characters.webp” alt=”How to add bullet points in Google Sheets \u2014 Special characters dialog in Google Docs filtered to geometric shapes” title_text=”Special characters dialog in Google Docs filtered to geometric shapes” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> Select and copy the bullet point.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/bullet-points-google-sheets-copy-bullet.webp” alt=”Bullet points for Google Sheets \u2014 bullet symbols inserted in a Google Docs document, ready to copy” title_text=”Bullet symbols inserted in a Google Docs document, ready to copy” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3.<\/strong> In Google Sheets, double-click on the cell you want to use and paste the bullet point. You can then type a space, followed by your list item.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/bullet-points-google-sheets-paste-bullet.webp” alt=”Bullet points in Google Sheets \u2014 pasted bullet point followed by the first list item in a cell” title_text=”Pasted bullet point followed by the first list item in a cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4.<\/strong> If you want your entire list within a single cell, use the new line shortcut<\/a> after each item – Alt + Enter (Windows) and Cmd + Enter (Mac) and then paste another bullet point.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/bullet-points-google-sheets-new-line-in-cell.webp” alt=”Bullet points in Google Sheets \u2014 two bulleted items on separate lines in one cell” title_text=”Two bulleted items on separate lines in one cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-insert-bullet-points-in-a-cell-wi” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to insert bullet points in a cell with a keyboard shortcut?<\/h2>\n

You can insert bullet points in your cells with a keyboard shortcut: Alt + 7 (Windows) and Option + 8 (Mac). Select the cell where you want to add the bullet point and double-click to edit. Use the corresponding shortcut to insert a bullet point.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-insert-bullet-points-in-google-sh” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to insert bullet points in Google Sheets with the CHAR function?<\/h2>\n

The CHAR function is versatile and easy to use. Simply type the function and use the decimal Unicode character as the function\u2019s only parameter. If you already have the list in Google Sheets, you can use the CHAR function together with the ampersand (&) or TEXTJOIN to add the bullet points quickly. You can then copy the results and replace the original using the \u2018Paste values only\u2019 option.<\/p>\n

In this case, I want to add a bullet point, and there are quite a few options, including the more traditional symbols used as bullet points:<\/p>\n