Setting the column width

You can allow the Lists tool to set a standard, automatic width, or you can manually set custom column widths, either as a percentage of the total view width, in pixels, or in points.

If all columns are set to Automatic, the width of any column is equal to the full width of the view divided by the number of columns. If one or more columns are set to a specific width, then the width of a column set to Automatic is equal to the remaining measure of the view (after custom-width columns are totaled), divided by the number of remaining columns.

Click the field for which you want to set the column width.

Click the Column width drop-down menu, and then click the setting you want.

If you select Fixed, select the custom measure type you want from the drop-down menu, and then enter a corresponding custom measure.

Totaling values for numeric columns

For any field type that uses numeric values, such as Number or Integer, you can enable a column property to total the values in the column and display the total value in the data view.

Click the field for which you want to total values.

Check Total values in this column (numeric columns only).

The example below shows a column that totals values:

Setting up a column to show subtotals

You can use grouped sorting to set up a view column to show subtotals and a summary total. The example below shows a view that groups all items according to a "Food Group" field, totals the values for each individual group and calculates the summary total of all groups.

Adding or removing field columns

You add or remove field columns in a list by checking or unchecking them in the field list.

To check all fields in the list, click

To uncheck all fields in the list, click

Note: Attachment fields do not appear in this list. However, you can check the Show attachments column option on the Properties tab to add a column to the list view that displays a file attachment icon when an item contains a file attachment.