docs / articles / How to Create a Simple List in Excel

How to Create a Simple List in Excel

Sara Jul 09, 2026 2026-07-09 04:40:45

Creating a simple list in Excel is a fundamental task that can help you organize data, track tasks, or plan projects. This guide will walk you through the process, ensuring you master this essential skill.

How to Create a Checklist in Microsoft Excel
How to Create a Checklist in Microsoft Excel

Whether you're new to Excel or looking to refresh your knowledge, this step-by-step guide will help you create and manage lists efficiently.

Pieter (haasbroekpieter) - Profile | Pinterest
Pieter (haasbroekpieter) - Profile | Pinterest

Creating a Simple List

Before you start, ensure you have Microsoft Excel open and a new or existing workbook selected.

How To Make A Daily To Do List In Excel
How To Make A Daily To Do List In Excel

To create a list, you'll need to enter data into cells. For this example, let's create a simple to-do list with tasks, due dates, and priorities.

Entering Data

[FREE] Master Working with Excel Lists!
[FREE] Master Working with Excel Lists!

In the first row, enter the header titles: 'Task', 'Due Date', and 'Priority'.

Starting from the second row, enter your task details in the respective columns. For example:

  • Task: Complete project report
  • Due Date: 2023-03-15
  • Priority: High
How to Make a Drop Down List in Excel - Tutorial
How to Make a Drop Down List in Excel - Tutorial

Formatting the List

To make your list more readable, you can apply some basic formatting:

1. Bold the header row by selecting it and pressing Ctrl + B.

a computer screen with the text creating a master excel shopping list
a computer screen with the text creating a master excel shopping list

2. Freeze the header row to keep it visible while scrolling. Go to the View tab, click Freeze Panes, then select Freeze Top Row.

Sorting and Filtering the List

Simple To-Do List Setup in Google Sheets for Beginners
Simple To-Do List Setup in Google Sheets for Beginners
Best Excel tutorial on the internet
Best Excel tutorial on the internet
Add Cool Features to Your To Do Lists in Excel
Add Cool Features to Your To Do Lists in Excel
How to Create a Drop-Down List in Excel (7 Easy Steps + Advanced Tricks)
How to Create a Drop-Down List in Excel (7 Easy Steps + Advanced Tricks)
Task List in Excel
Task List in Excel
How to Create Drop Down Lists in Excel - Complete Guide + Video Tutorial
How to Create Drop Down Lists in Excel - Complete Guide + Video Tutorial
"Effortless Excel Excellence: Top Tips & Tricks to Become a Spreadsheet Pro!"
"Effortless Excel Excellence: Top Tips & Tricks to Become a Spreadsheet Pro!"
[FREE] Top 3 Ways to Create Excel Custom LIsts
[FREE] Top 3 Ways to Create Excel Custom LIsts
How To Create a To Do List in Excel (With Templates) | The ClickUp Blog
How To Create a To Do List in Excel (With Templates) | The ClickUp Blog
Excel shortcut ...✅
Excel shortcut ...✅
Excel CTRL Shortcuts
Excel CTRL Shortcuts
ms excel formula
ms excel formula
the top 10 excel functions for beginners to use in your workbook or notebook
the top 10 excel functions for beginners to use in your workbook or notebook
To do list in excel
To do list in excel
Excel How-To: Starting a Basic Spreadsheet
Excel How-To: Starting a Basic Spreadsheet
How To Make A Daily To Do List In Excel
How To Make A Daily To Do List In Excel
Excel Hacks for Smarty Pants
Excel Hacks for Smarty Pants
Excel Trick: Custom Sort How To do it!
Excel Trick: Custom Sort How To do it!
Master Your Tasks with Excel Templates
Master Your Tasks with Excel Templates
the microsoft excel spreadsheet sheet is shown in green and orange colors, with an additional
the microsoft excel spreadsheet sheet is shown in green and orange colors, with an additional

Once you've entered your data, you can sort and filter the list to view specific information.

For instance, you might want to see only the high-priority tasks or sort tasks by their due dates.

Sorting the List

Select any cell in your list, then go to the Data tab. Click Sort A to Z (or Sort Z to A) to sort tasks alphabetically. To sort by another column, click the Sort button, choose the column you want to sort by, and select the sorting order.

Filtering the List

To filter your list, select any cell in your list, then go to the Data tab. Click Filter (the funnel icon). Click the dropdown arrow in the header of the column you want to filter. Uncheck the 'Select All' box, then select the items you want to filter by. Click OK.

Now that you've learned how to create, format, sort, and filter a simple list in Excel, you're ready to tackle more complex tasks. Happy listing!