Adding and Editing List Columns
You can add any number of columns of different types (text, multiple choice, a list of persons at Tufts, etc) to your list. Microsoft has an explanation of each column type here. Note: Choosing the Person column type will provide a dropdown of all Tufts persons.
You can rename, delete, edit the configuration of, and change the type of existing columns.
Your list always starts with a Title column. This is a friendly identifier for the list item; there’s a separate uniqueID column which is hidden by default.
- To the right of your existing columns, next to the column names, click +Add column.
- Choose a Column Type.
- Click Next.
- In the right panel, give the column a short name and a description.
- Choose your column options. These options will be different depending on the column type you chose.
- Expand the More Options dropdown to view more column options, such as requiring that the column contains information (it cannot be left blank for any list item).
- At the bottom of the panel, click Save.
- Click the column name to open a dropdown menu.
- Click Column settings to open the column settings menu.
- Click Edit at the top of the column settings menu.
- In the right panel, make your edits.
- At the bottom of the panel, click Save.
- Click the column name to open a dropdown menu.
- Click Column settings to open the column settings menu.
- Click Edit at the top of the column settings menu.
- In the right panel, at the bottom, click Delete.
MS Lists has automatically records information about each item in your list in metadata columns. These columns can be shown, hidden, and rearranged like any other column in your list.
Some of these columns are:
- ID: A unique ID assigned to this list entry.
- Modified: The date this list entry was last modified.
- Created: The date this list entry was created.
- Created By: The user who created this list entry.
- Modified By: The user who last modified this list entry.
- In the top right of your list, click the name of your list.
- In the dropdown, click Add or remove fields.
- Check columns you want to show and uncheck columns you want to hide. This does not delete the column from your list.
- Click Apply.
You can rearrange multiple columns at once or move a single column left or right.
To rearrange multiple columns at once:
- In the top right of your list, click the name of your list.
- In the dropdown, click Add or remove fields.
- Hover over any column and use the arrows on the right side to move the column up and down to a different position in the list.
- Alternatively, click and hold a column to drag and drop the column to a different position in the list.
- Click Apply.
To move a single column left or right:
- Click the column name to open a dropdown menu.
- Click Column settings to open the column settings menu.
- Click Move Left or Move Right to move the column.