Get started with Microsoft Lists

Microsoft Lists helps you organize, collaborate, and share the information you care about. Starting from the Lists app in Microsoft 365, you can quickly create a list from scratch or get inspired by ready-made templates. View your recent and favorite lists no matter where they're stored, and add more favorites to get back to them quickly. 

To get to the Lists app, at the top of any page, select the Microsoft 365 app launcher  App launcher button  , and then select Lists
Screenshot of the Microsoft Lists tile that appears in Microsoft 365 app launcher.  

View your recent and favorite lists

The Lists app gives you easy access to your recently visited and favorite lists. Your Favorites appear at the top, followed by the Recent lists section.

Screenshot of the Microsoft Lists home page

  • To add to or remove a favorite from your Favorites section, select the star icon in the upper corner of any list. 

  • Recent lists shows all the lists you recently visited, regardless of who created them or where they're stored. Recent lists includes lists that you've visited on  SharePoint sites or Microsoft Teams that you're a member of.

  • To see only your recent personal lists that you created in My lists, select the arrow next to the Recent lists heading, and then select the My lists view.

  • To see only the recent lists that you created, including in My lists, SharePoint, or Teams, select the All recent lists filter control to the right of the heading, and then select Recent lists I created.

  • To reset the filters or view selection, just refresh your browser. The page defaults back to the original settings when you leave the page and come back.

Note: There's a 100-item limit for Recent lists and a 30-item limit for Favorites. If you reach either limit, you'll get an error and you can remove items to add more.

Create a new list

Create a list from scratch, from an Excel spreadsheet, from an existing list, or from one of the ready-made templates.

  1. From the Lists app, select New list at the top of the page.

  2. From the Create a list page, select one of the following options:

    1. Blank list: Choose this option to start from scratch. Give your list a Name, Description (optional), and select any other options you want. The list will save to My lists unless you choose one of your SharePoint sites or Teams from the Save to list. When you're finished selecting options, select Create.

    2. From Excel: Choose this option to Create a list based on an Excel spreadsheet.

    3. From existing list: Choose this option to save time and create a new list based on the columns in another list. Your new list will start with all the same columns, but it won't include any of the data from the original list.

    4. Templates: Select a template, such as Issue tracker, to see what columns the template contains and scroll through sample data to see what it looks like. Select other templates to look at other ones. If you find one you like, select Use template. If you don't see any you like, select Back to get back to the Create a list page. Learn more about using Microsoft Lists templates.

  3. When your list opens, to add room for more types of information to the list, select + or + Add column

    For more info about adding columns, see Create a column in a SharePoint list or library.

Search for lists 

Having trouble finding a list? Type the key words in the Search box at the top of the page. Your results will include all the lists matching that query that you have access to in your organization. 

Rename a list, or change the color or icon

  1. From the Lists app, point to a list, select Open actions (...), and then select Customize.

  2. Enter a new Name.

  3. You can also choose a new color or a different icon, if you want.

  4. Select Save.

Share a list 

  1. From the Lists app, point to a list, select Open actions (...), and then select Share.

  2. Enter a name or email address.

  3. To change the access permissions you are granting to people, select Can edit and then select a different option.

  4. If you don't want to let people know you're sharing the list, clear the Notify people check box.

  5. Select Grant access.

Note: You need to have Full Control access to the list to be able to share a list. If you don't have permission to share, you'll see a message stating that fact when you try to share it. 

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×