SharePoint: Lists

Lists are configurable tables that can be used to present data in an easy-to-read format. Lists can be used to store contact information, inventory items, or anything for which you may normally use a spreadsheet. 

How do I Create a List?

  1. From the Settings Menu (Gear icon) in the top right hand corner of your screen, and select Site contents.

    Screenshot of the Office 365 Online settings menu with a red box around the Site Contents button, and a red arrow pointing towards the site contents button.
     
  2. From the + New menu on the left hand side of the screen, select List. 

    Screenshot of the New menu in Office 365 online with a red box around the list option and a red arrow pointing towards the list option.
     
  3. The Create List menu will appear. Fill in the following information: 

    Create List window in Office 365 online with a red box around the Create button and a red arrow pointing towards the Create button.


    Name: Name the list
    Description: Enter in a synopsis of the information in the list.

    Once you have filled in all the required fields, click on Create.
  4. Click on the Settings Menu (Gear icon) in the top right hand corner of your screen, and select List Settings. 

    Screenshot of the Settings menu in Office 365 with a red box around the List Settings option and a red arrow pointing towards the List Settings option.
     
  5. Under the Columns heading, click on Create column. 

    Screenshot of the Columns option in Office 365 online with a red box around the Create column button and a red arrow pointing towards the red arrow button.
     
  6. A new window will appear. Fill out the following information: 

    Screenshot of the Create Column menu in Office 365 with a red box around the OK button and a red arrow pointing towards the OK button.


    Column name: Whatever you would like the column to be named. 
    Type of Column: Choose from the list of available options .
    Description: What kind of data will be contained in the column. 
    Require that this column contains information: Select Yes or No. 
    Enforce unique values: Select Yes or No.
    Default Value: Select either text or Calculated Value.
  7. When all of the information has been filled in, click on OK. 
  8. If you navigate to your list, you will now see the column that you created. 

    Screenshot of a List in SharePoint with a red box around the example column and a red arrow pointing towards the Example Column.
     
  9. Repeat the Column creation process until you have the number of desired columns. 
  10. To change the order of the columns, click on All Items and select Edit Current View. 

    Screenshot of the All items menu in Office 365 with a red box around the All Items button, a red box around the Edit current view button, and a red arrow pointing towards the Edit current view option.
     
  11. Select the order that you would like to view the columns. Once completed, click on OK at the top of the page. 

    Screenshot of the Edit current view menu with a red box around the OK button and a red arrow pointing toward the OK button.
     

How do I Add an Item to a List?

  1. To add an item to the list, open up the list and click on + New. 

    Screenshot of a list in Office 365 online with a red box around the New button and a red arrow pointing towards the new button.
     
  2. A window will open, fill in the needed information for the list. Once all the fields have been completed click on Save.

    Screenshot of the New Item menu in Office 365 with a red box around the Save button and a red arrow pointing towards the Save button.
     
  3. Your new item will now be added to the list. 

 

Need additional assistance?

Get Help

Print Article