Exporting a Workbook to Excel

Exporting Your Workbook to Excel

To export your workbook data into a Microsoft Excel spreadsheet, first open the workbook. Next, on the File tab, click Save As, and select XLSX.

The XLSX Export Options box appears, where you can choose whether to export the entire document, or sections:

If you choose Include selected Section(s): the box will expand to display the sections of your workbook:

image alt text

You can choose which sections you wish to include in your export, then click OK. If your export includes a section you don't have permission to view, a warning will appear explaining this and the tab for that section in your export will state that it has been excluded.

A progress bar will appear. Depending on how large your document is, this process may take several minutes or more. When it is complete, you will receive a notification.

Click OK. You will be prompted to choose the location for your exported spreadsheet.

Set Print Area for Excel Exports

You can set the print area for a section that will carry over to your XLSX export.

Click and drag in your workbook section to select the cells to set the print area on. Click the Print Area button on the File tab. It will display the cells you've selected. Choose Set if the selection is correct. You can also Hide or Show the selection from here, or Clear it if you're done with it.

image alt text

After you select Set, you'll get a confirmation box. Click OK.

NOTE: Setting the print area does not allow you to actually print the workbook from within the application. It is merely for the XLSX exports.