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
Create a new column that we’ll use to generate our sequence of numbers.
We’ll start the sequence by placing the number ‘1’ in the first cell.
Next, we’ll add the number ‘2’ in the second cell in the new column. Select both numbers using your cursor.
Use the Fill Handle to create the rest of the sequence.
Next, create a new column where we’ll use the CONCATENATE function to create the numbered list.
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’.
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.
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.
More ways to use text in Google Sheets:
- Add Bullet Points
- Insert Text Box
- Insert Special Characters
- Insert Symbols
- Insert Page Break
- Center Text
- How To Make Text Fit In Cell
- Make Text Vertical
- Change Case
- View Page Breaks
- Line Break In Google Sheets
- How To Capitalize
- How To Wrap Text
- How To Indent
- Count Cells with Text
- Fit Text to Cell
- Checking if a Cell Contains a Substring
- TEXT Function
- Combine Text From Two Cells
- SUMIF Cells If Contains Text
- Add Text To Formula
- Indent Text
- Change Text To All Caps
- Spell Check in Google Sheets
- How to Use Spell Check
- Insert a Bullet List
- Insert Bullet Points
- Add a New Line In Cell
- Add Multiple Lines In One Cell
- Wrap Text In Cell
- Superscript In Google Sheets
- Make A Degree Symbol
- SUBSTITUTE Function
- How To Alphabetize