By opening a list in a Standard view, then switching to Datasheet view by clicking the Edit in Datasheet button on the view toolbarNote If a Standard view does not support Datasheet view, the Edit in Datasheet button will not be shown on the toolbar. For example, the Explorer view of a document library does not support Datasheet view. - Datasheet View Help

Microsoft Datasheet View

Table of contents