Microsoft Office Tutorials and References
In Depth Information
All the field headings have a down arrow next to them. This is a standard spreadsheet table feature
that allows you to filter and sort a field from that drop-down. You can also use it to perform custom
filtering. Just click the down arrow of the column you’d like to filter, and select Custom Filter. That
will open the Custom Filter dialog box in which you can do three levels of complex filtering of that
field’s data in the list.
When a list is in Datasheet view, it acts like any spreadsheet. You can add and delete rows
and columns, ill columns, cut and paste, and so on. In addition, fields that contain
multiplechoice data simply drop down for you to choose from the list just as you did in the New Item
window. As a matter of fact, because the Choice field has a default value, Informational, it will
autoill with that value if you skip over it to go to the next row.
1. To add a new item record, simply go to the last row of the datasheet and start typing in the
fields. You’ll find that you can type in the Title field but not in the Created By field. Why not?
Well, Created By is a field that gets filled based on your login information. It wasn’t meant to
be editable. System fields populated by data SharePoint generates (Created By, Modified By,
and Creation Date, to name a few) will show up as read-only in the datasheet when you try
to enter data into them (see the bottom-right corner of Figure 6.20).