Lists - Custom columns to match your needs Tutorial

Unlock the power of customization with 'Custom Columns to Match Your Needs'. This video guides you through creating and managing columns in lists, enhancing your collaboration experience. Discover how to tailor your lists effortlessly and ensure they meet your unique requirements. Don't miss out on maximizing your productivity!

02:09
113 views

Available in Microsoft365

00:00:03

I may need to create new columns.

00:00:05

There are 2 options available.

00:00:08

Let us start by using the add column button located to the right of the last column,

00:00:13

then selecting show or hide columns.

00:00:16

In the pane that appears,

00:00:18

I can manage the display or hiding of existing columns

00:00:22

and also add default columns provided by the system.

00:00:25

For example,

00:00:26

I can select the column showing the name of the user who created the list item.

00:00:31

The column is then successfully added.

00:00:34

The other option is to create a custom column by defining a type.

00:00:38

For instance,

00:00:38

I can create a text column in which I want to enter the book author for my list.

00:00:43

I name the column

00:00:45

and add an optional description which will be visible

00:00:47

when entering data through the new item form.

00:00:50

I can also change the type later

00:00:52

if I decide to use a number or date column instead.

00:00:56

The default value option

00:00:58

allows me to prefill the field

00:01:00

with a predefined value

00:01:02

when a new item is added to the list.

00:01:05

Additional options let me define a maximum number of characters

00:01:09

or specify whether the column must be filled in when adding data.

00:01:14

The unique values option

00:01:16

prevents entering a value in the column if

00:01:19

another list item already contains the same value.

00:01:23

The available options vary depending on the type of column selected initially.

00:01:27

After saving,

00:01:28

I can reposition the column.

00:01:31

Simply drag and drop it to the desired location.

00:01:34

Another way is to return to the show or hide columns menu,

00:01:38

where I can also reorganize columns by dragging and dropping

00:01:42

or by using the arrows on the right side.

00:01:45

To edit the settings or delete a column,

00:01:47

I click on its header,

00:01:48

select column settings,

00:01:50

then edit.

00:01:52

In the right pane,

00:01:53

I will be able to modify the column or delete it permanently.

00:01:57

Please note that columns provided by Microsoft lists,

00:02:00

such as the created by column added earlier in this tutorial,

00:02:04

can only be hidden and cannot be permanently deleted.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

206 Views

Microsoft Lists - Getting started

Discover how Microsoft Lists simplifies data organization with powerful customization and collaboration features far beyond a basic spreadsh...

ALL COURSES