Skip to main content
Skip table of contents

The Data Viewer

Sorting, filtering, formatting and grouping all your Microsoft365 data in one place.

Actions in the Data Viewer

Apart from the bottom section that displays the applied filters and the options to add or hide properties in the grid, here’s what you can do with each property in the Data Viewer.

Copy a value or Column ID - Shortcuts

  1. Ctrl + Click to copy a property value

  2. Alt + Click to copy a Column ID

both-copied.jpg
dataviewer-options.jpg

Button

Action

1

filter-icon.jpg Filters

Filters...
Value Filters...
Filter by regular expression...
Filter out empty cells
Keep empty cells only
Clear all filters

2

sort-group-icon.jpg Sorting & grouping

Sort ascending
Sort descending
Remove sorting
Group this column
Ungroup this column

3

other-icon.jpg Other

Cell format...
Group format...
Conditional format...
Edit column settings...
Freeze up to

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.