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.
Table of Contents
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:
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:
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
2. Double click into the cell where you want your list to appear
3. Paste your list by right-clicking and selecting Paste (or press Ctrl + V on your keyboard)
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