Microsoft Lists: How to increase the columns available for calendar view formatting

Tetsuya Kawahara
2 minutes to read
13 Oct, 2023
- Community post

Introduction

Microsoft Lists allows you to create a calendar view and color-code each item.

However, the columns you want to use for color coding may not appear in the formatting screen. This is because the column you want to use for color coding is not included in the calendar view.

formatting screen before setting view settings

So, the following is a method to change the view settings and increase the columns available for use in the calendar view formatting.

How to increase the columns available for calendar view formatting

To increase the columns available for a calendar view, you must add columns to the view for use in calendar view formatting. There are two methods for adding columns to the view: one is through the “Edit View Columns Panel” , and the other is through the “Edit View Screen”

Method 1: Adding Columns via the “Edit View Columns Panel”

Open the Calendar view in Microsoft Lists
Select on the name of the view displayed in the command bar > Select Add or remove fields
Select the columns to be used in the formatting and put a check mark
Select Apply button

Method 2: Adding Columns via the “Edit View Screen”

Open the Calendar view in Microsoft Lists
Select the ⚙ icon > Click List settings
Select on the view name of the calendar view in Views
Select the columns you want to use for formatting from the list of columns displayed in the Columns section
Select OK button

This completes the settings. When you open the formatting screen, the columns you selected in the Edit View screen will be displayed as available options for color-coding!

formatting screen after setting view settings

Additional notes

Method 1 is a new method and may not yet be deployed and available to some of your tenants.