Export
From an applicable view, follow the procedure below to save any the view in spreadsheet format.
To export view's contents
- From the view, do any of the following:
- Click
.
- From the View menu, select Export.
The Export dialog box appears.
- Click
- From the Export range box, select either Selection or All to indicate what is to be exported.
- In the Other options box, do the following:
- Select the Include column headings check box to include the column headings in the spreadsheet.
- Select Open file on exit to cause the spreadsheet to be opened after the user completes the Export dialog box and clicks OK.
- In the Delimiter box, select the type of delimiter to be used for the spreadsheet. When selecting Specify your own, enter in the field a single character to be used as the delimiter.
- In the Export to field, enter or browse to the location in which to save the spreadsheet file.
- Click OK. The selected view's contents are saved as a spreadsheet file in the specified location.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*