How to Add Bullet Points in Google Sheets – Quick Formatting Guide

This document provides a step-by-step process on how to insert bullet points within a spreadsheet cell. Follow these instructions to effectively use keyboard shortcuts for seamless integration of bullet points.

Google Sheets doesn't have a built-in bullet list feature like Google Docs, but you can still add bullet points manually or with a formula. Here are two easy methods:

1. Manual Insertion Using Keyboard Shortcuts

This method adds a bullet directly within a cell.

• Step 1: Double-click the cell (or press Fn + F2) to enter edit mode.

• Step 2: Use the shortcut:

  • Windows: Press Alt + 7 (using the numeric keypad)

  • Mac: Press Option + Shift + 8

• Step 3: Type your text after the bullet.

• Step 4: Press Enter to save the cell content.

2. Using the CHAR Function

This method uses a formula to insert a bullet symbol.

• Step 1: In a cell, type the following formula:

• Step 2: Press Enter. It will display a bullet followed by your text.

3. Creating a Bulleted List

You can apply either method above to each item in a list by entering one per row:

• Insert the bullet and text in the first cell.

• Press Enter to move to the next row.

• Repeat as needed.

Step-by-Step Guide: How To Add Bullet Points In Google Sheets

Step 1

Double-click on the cell you want to add bullet point.

Step 2

If you are a Windows user, Press 'Alt + 7' and if you are a Macbook user, press ˘Options + 8˘ and then press 'Enter'.

Step 3

Simply drag and drop the cells where you want to add bullet points. That's it

Pro-tips for adding bullet points in Google Sheets

• Use the built-in Insert menu and select Bullet points to easily add them to a cell.

• You can customize the bullet style by using symbols like asterisks (*) or dashes (-) if the default bullet points don’t meet your needs.

• To add bullet points in multiple cells at once, select the range and press Ctrl + Shift + 8 (Windows) or Cmd + Shift + 8 (Mac).

Common pitfalls & how to avoid them while adding bullet points in Google Sheets

• Forgetting to use the correct cell formatting ensure the cell is in text format for proper bullet point display.

• Overcomplicating the process use the built-in shortcut or bullet point option for simplicity instead of manually typing special characters.

• Adding bullets to cells with merged rows merging cells may cause issues with aligning bullet points, so avoid merging if possible.

Common FAQs for adding bullet points in Google Sheets

1. How can I add bullet points without using the menu? You can add bullet points by using the keyboard shortcut Ctrl + Shift + 8 (Windows) or Cmd + Shift + 8 (Mac) to quickly add bullet points to the selected cell.

2. Can I customize the bullet points in Google Sheets? Yes, you can use symbols like asterisks (*) or dashes (-) as bullet points if you want a different style from the default options.

3. Why aren’t my bullet points displaying properly in Google Sheets? This may happen if the cell is not set to the correct format. Ensure the cell is in text format for the bullets to display correctly.

4. Can I add numbered lists instead of bullet points in Google Sheets? While Google Sheets doesn’t have a built-in numbering feature, you can manually number items or use a formula to create a numbered list.

5. How to screen record on mac? 
   To screen record on a Mac, you can use Trupeer AI. It allows you to capture the entire screen and provides AI capabilities such as adding AI avatars, add voiceover, add zoom in and out in the video. With trupeer’s AI video translation feature, you can translate the video into 30+ languages. 

6. How to add an AI avatar to screen recording?
   To add an AI avatar to a screen recording, you'll need to use an AI screen recording tool. Trupeer AI is an AI screen recording tool, which helps you create videos with multiple avatars, also helps you in creating your own avatar for the video.

7. How to screen record on windows?
   To screen record on Windows, you can use the built-in Game Bar (Windows + G) or advanced AI tool like Trupeer AI for more advanced features such as AI avatars, voiceover, translation etc.

8. How to add voiceover to video?
   To add voiceover to videos, download trupeer ai chrome extension. Once signed up, upload your video with voice, choose the desired voiceover from trupeer and export your edited video. 

9. How do I Zoom in on a screen recording?
   To zoom in during a screen recording, use the zoom effects in Trupeer AI which allows you to zoom in and out at specific moments, enhancing the visual impact of your video content.