Skip to Content

How to Make a Numbered List in Google Sheets

Sometimes when working in Google Sheets, you may want to create a numbered list inside your spreadsheet.

To do this, you have a few options. You can create a numbered list inside a single cell, or you can create a numbered list using multiple cells. I will show you both ways.

In this tutorial, I will show you how to make a numbered list in Google Sheets.

Numbered List Across Multiple Cells

Numbering a list across multiple cells is pretty easy to do. There is not an option to automatically number a list like there is in Google docs. Instead, you have to manually number your list.

You can either number your list manually line by line:

Manually number list

Or another option is to use a formula to concatenate a number to the beginning of your list. This will be the faster method if you have a large data set

Here is an example of how a formula could be used:

Numbered List Formula

To do this, you need to have a column with the numbers, and then a column with the list and you can use the CONCATENATE function to combine them together.

The exact formula I have used in this example is:

=CONCATENATE(A2,“.”,” “,B2)

This will take the number in cell A2, add a period to it, and then a space, and then the value in B2.

After your list is returned you can then copy and paste it as values to remove the formula so you just have the list left.

Numbered List Inside a Cell

The easiest way to get a numbered list inside of a cell is to create your list across multiple cells with one of the previous methods that I covered, and then paste it inside a single cell.

Here are the steps to do this:

1. Copy the cells that contain the numbered list that you want put into a single cell

Numbered list inside cell

2. Double click into the cell where you want your list to appear

Numbered list inside cell-2

3. Paste your list by right-clicking and selecting Paste (or press Ctrl + V on your keyboard)

Numbered list inside cell-3

Closing Thoughts

There is a little bit of manual work involved with creating numbered lists in Google Sheets since there is not a quick tool for it like in Google Docs.

However, it is still a relatively easy thing to do. Hopefully, you found this tutorial helpful!

More Google Sheets Tutorials:
How to Add Bullet Points