# Using Grid View

The Library's grid view functions like a spreadsheet, allowing you to sort, resize columns, modify which columns appear, and more. When you hover over a document name in grid view, Vault displays a preview and information about the document on a <a href="/en/gr/55692/">document hovercard</a>. Learn more about the <a href="/en/gr/1740/">different library views</a>.

## Sorting {#sort}

You can sort by any column, in ascending or descending order. To sort, click on the column heading. The first click sorts the column in ascending order, the second in descending order. Vault remembers your sort preferences when you leave and return to Grid layout.

## Resizing Columns {#resize}

Resize the width of each by dragging the edges of the column heading. Vault remembers your column width preferences when you leave and return to Grid layout.

## Rearranging Columns {#rearrange}

Change the order of columns by clicking and dragging the column header to a new location. You cannot move the _Name_ column. An orange line appears to highlight the new location while you're dragging a column. Vault remembers your column order preferences when you leave and return to Grid layout.

## Adding or Removing Columns {#add}

To add or remove columns, select **Edit Columns** from the **Actions** menu. From the dialog box, you can move fields between the **Available Columns** box and the **Selected Columns** box. In the **Selected Columns** box, rearrange the column order using the up and down arrow buttons. To reset all settings to default, click **Restore**.

You can add up to 100 coumns to the grid view.

## Filtering Column Headers

Grid layouts offer filtering options in columns where the field type in that column is a picklist, object reference, yes/no, date, or number. Clicking the filter icon in the column header will display the same filter options which are available in the side bar. Applying filters in the column headers will also be reflected in the side bar. Field types that support filtering offer a _Select All_ and _Clear Selected_ option when looking up filter values by name. Learn more about <a href="/en/gr/1616/">Filtering on Fields & Roles</a>. 

## Customizing Column Text Appearance

Sometimes text can be too long to properly fit inside its column. In the **Actions** menu, the **Truncate Cell Text**/**Wrap Cell Text** options let you toggle between truncating (showing only the first part of the value) and wrapping (showing any characters that don't fit on a second line) text that is too big to fit in its column.

## Using Horizontal Scrolling {#scroll}

If you select more columns that can fit in the page width, a scroll bar appears at the bottom of the page to allow horizontal scrolling.

## Freezing Columns {#freeze}

To freeze a column, select **Freeze Column** from the **Actions** menu. You can change which columns are frozen by dragging the blue line. This is especially useful for horizontal scrolling. To unfreeze the column, select **Unfreeze Column** from the **Actions** menu.

## Exporting {#export}

You can export all of the fields in your current layout from the **Actions** menu. Exports can include up to 10,000 records.

  * **Export to CSV** downloads the fields in CSV (comma separated value) format. This option is not available if localization is enabled for the Vault.
  * **Export to Text** downloads the fields in TXT format. This option is only available if <a href="/en/gr/13309/">localization</a> is enabled for the Vault.
  * **Export to Excel** downloads the fields in XLSX format and maintains column headers and filters. For Excel 2007 or earlier, choose **Export as CSV** and import into Excel.

<div class="note-border alert-info">
  <div class="alert alert-info" role="alert">
    <div><i class="far fa-info-circle"></i></div>
    <div class="alert-text">
      <p><strong>Note</strong>: Vault will not include the following characters in the file name of an export: <strong>&lt;</strong>,<strong>&gt;</strong>,<strong>:</strong>,<strong>”“</strong>,<strong>/</strong>,<strong>\</strong>,<strong>|</strong>,<strong>?</strong>,<strong>*</strong></p>
    </div>
  </div>
</div>


