Change column details

Column types help you control what data is allowed in columns—use specific types to ensure more consistent data entry. You can also add acolumn descriptionto provide more information about your column.Learn more about column types.

If you're the sheet Owner or Admin, you canprevent others from adding free text to column cells or form fields.

---

To change a column type

You can't change the column type of aprimary columnandproject settings columns.

1. Hover over the column header and selectColumn Menu. Or, double-click the column header.
2. SeelctEdit Column Properties.

Include a column description

Explain important information about a column in a custom tooltip. For example, use a column description to document what type of data you expect the column to contain. The description field holds 250 characters, max.

1. Right-click a column header.
2. SelectAdd Column Description.
3. Type your column description in the form.
4. SelectOK.

That's it! Now anyone shared to the sheet can view the column description.

View the column description

You can't view column descriptions in reports and dashboards. Column descriptions appear in sheets, only.

You'll know a column has a description if you see this icon:. To view the column description:

• Hover over. You'll see the tooltip and the column description.
  

编辑列描述信息

1. Right-click the column header.
2. SelectEdit Column Description.
3. In the列Descriptionform, make your desired changes.
4. SelectOK.