How to Make a Numbered List in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

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

How to Make a Numbered List in Google Sheets

When working with data in Google Sheets, you may find yourself in need of a numbered list. This can be helpful if you want to keep track of items in a list, for example. While it may be easy to create a numbered list in Google Docs, you may encounter some difficulty creating numbered lists automatically.

Google Sheets does not have a built-in function to create a numbered list. However, we can use the concatenate function to append a number before every value in a range. This is a much quicker solution than typing the numbers manually.

In this guide, we will show you how to make a numbered list in Google Sheets using the CONCATENATE formula.

How to Create a Sequential List in Google Sheets

Here’s how to create a numbered list in Google Sheets

Step 1

Create a new column that we’ll use to generate our sequence of numbers.

Step 2

We’ll start the sequence by placing the number ‘1’ in the first cell.

Step 3

Next, we’ll add the number ‘2’ in the second cell in the new column. Select both numbers using your cursor.

Step 4

Use the Fill Handle to create the rest of the sequence.

Step 5

Next, create a new column where we’ll use the CONCATENATE function to create the numbered list.

Step 6

We’ll use the formula =CONCATENATE(B3,”. “,A2) to create the first item in our numbered list.

Users can customize the format of the numbered list. For example, they may choose to output the first item as ‘1. Red’ or as ‘1) Red’, or even as ‘(1) Red’.

Step 7

Hit the Enter key to evaluate the CONCATENATE function. Use the Fill Handle tool once more to generate the rest of the numbered list in Google Sheets.

Summary

This guide should be everything you need to make a numbered list in Google Shets.

You may make a copy of this example spreadsheet to test it out on your own.