How To Add Bullet Points To Google Sheets

Google Sheets, a powerful online spreadsheet tool, allows users to handle and analyze a large amount of data. But did you know that you can also add bullet points to improve the readability of your data? In this blog post, we’ll guide you through how to add bullet points in Google Sheets.

Method 1: Using a formula

One way to add bullet points is by using the CHAR function in Google Sheets. This function returns a character specified by a number code. The bullet point corresponds to number 8226.

Here is how to use it:

    =CHAR(8226)&" "&"Your Text Here"

Method 2: Using keyboard shortcut

Besides using a formula, you can also add a bullet point using a keyboard shortcut, which is faster and easier. The keyboard shortcut to add a bullet point in Google Sheets is Alt + 7 on a PC and Option + 8 on a Mac.

Method 3: Copying from Google Docs or Word

If you already have a list with bullet points in Google Docs or Word, you can simply copy and paste the list from these applications to Google Sheets. The bullet points format will be preserved.

Method 4: Using a script

Last but not least, you can use a custom script to add bullet points. This method is especially useful when you want to add bullet points to multiple cells at once.

Here’s a simple script you can use:

    function addBullets() {
      var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
      var range = sheet.getRange("A1:A10");
      var values = range.getValues();
      for (var i = 0; i < values.length; i++) {
        values[i][0] = '• ' + values[i][0];

Replace “A1:A10” with the range of cells where you want to add bullet points.


Adding bullet points can make your data in Google Sheets easier to read and understand. We hope that our guide on how to add bullet points in Google Sheets has been helpful to you. Remember, there’s always more than one way to achieve your desired outcome in Google Sheets!