What exporting a multi-tab workbook means

Exporting an Excel workbook with multiple tabs means saving your entire spreadsheet — all the sheets together — in a format that another person or program can open. When you export, you're creating a copy of your file in a specific format, usually .xlsx (the standard Excel format) or .pdf (a locked, read-only format). The tabs stay intact, so whoever opens the file sees all your sheets in the same order you created them.

Most of the time, you don't need to do anything special. If you save your file normally in Excel, all tabs come along automatically. But if you want to send your workbook to someone who uses an older version of Excel, or you want to create a version nobody can edit, that's when you export to a different format.

Key Takeaways

  • Saving normally in Excel (.xlsx) keeps all tabs together and is the format most people need.
  • Exporting to .pdf locks your data so no one can change it, but they can still see all tabs as separate pages.
  • Exporting to .xls (older Excel format) works if someone uses Excel 2003 or earlier, though formatting may shift.
  • You can export individual tabs as separate files if you only want to share one sheet with someone.

Saving your multi-tab workbook in standard Excel format

The simplest export is the one you probably do already. Open your workbook in Excel, click File in the top left, then click Save As. Choose where you want to save the file (your computer, OneDrive, or another location), give it a name, and make sure the file type shows .xlsx — that's the modern Excel format. Click Save. All your tabs come with it.

If you're working in Excel Online (the web version), the process is similar but slightly different. Click File, then read, then read as Excel Workbook. The file lands in your Downloads folder as an .xlsx file with every tab you created.

Exporting to PDF so the file cannot be edited

If you want to send your workbook to someone and make sure they can't change anything, export it as a PDF. Click File, then Export As (or Save As depending on your Excel version), then choose PDF from the file type dropdown. Name your file and click Export or Save.

When someone opens a PDF version of your workbook, each tab becomes a separate page in the PDF. They can read all the data and print it, but they cannot edit cells or change formulas. The downside: if your workbook has many columns or rows, some data might not fit neatly on a PDF page, and the formatting can look different than it does in Excel.

Exporting to older Excel formats for compatibility

If you need to send your file to someone using Excel 2003 or earlier, you can export to the .xls format (older Excel). Click File, then Save As, and in the file type dropdown, scroll down and select Excel 97-2003 Workbook (.xls). Name your file and click Save. All tabs export together.

Be aware that some features from newer Excel versions don't exist in the older format. Conditional formatting, certain formulas, and some colors may not transfer correctly. Test the file after exporting to make sure everything looks right. Most people today use .xlsx, so you'll rarely need this format — but it's useful when you know someone is stuck on an old version.

Exporting individual tabs as separate files

Sometimes you only want to share one tab with someone, not the entire workbook. Right-click on the tab name at the bottom of your spreadsheet and select Move or Copy. In the dialog that opens, select Create a copy, then choose new book from the location dropdown. Click OK. Excel creates a new workbook with just that one tab.

Now save this new file separately. Click File, then Save As, give it a name, and choose your format (.xlsx, .pdf, or another option). You now have a file with only the tab you wanted to share, while your original workbook stays unchanged with all its tabs intact.

Exporting from Google Sheets if you're using that instead

If your spreadsheet lives in Google Sheets instead of Excel, the export process is slightly different. Click File, then read, then choose your format: Microsoft Excel (.xlsx) is the most common choice. Google Sheets downloads your entire spreadsheet with all tabs as an Excel file you can open on your computer.

You can also export individual sheets from Google Sheets. Right-click the sheet tab at the bottom, select read, and choose your format. That sheet downloads as its own file. This is useful if you're collaborating with someone and want to send them just one sheet to review.

What to check before you send your exported file

After you export, open the file in the format you chose and scroll through each tab. Look for broken formulas (they'll show as #REF! or #VALUE!), missing colors, or text that got cut off. If you exported to PDF, check that all columns fit on the page and numbers aren't hidden. If you exported to an older Excel format, verify that conditional formatting and special features still work the way you intended.

If something looks wrong, go back to your original file, fix the problem, and export again. It's faster to catch issues before you send the file to someone else than to have them report problems later.

Frequently Asked Questions

Do all the tabs export automatically when I save my Excel file?

Yes. When you save an Excel workbook normally, every tab you created comes with it. You don't have to do anything special to include multiple tabs — they're part of the file by default.

Can I export just one tab without exporting the whole workbook?

Yes. Right-click the tab you want, select Move or Copy, choose Create a copy and new book, then save that new file separately. Your original workbook stays unchanged.

What format should I use if I'm not sure what the other person needs?

.xlsx is the safest choice. It's the standard Excel format, works on Windows and Mac, and opens in Excel, Google Sheets, and most other spreadsheet programs. Use .pdf only if you want to prevent editing, and .xls only if you know someone is using very old Excel.

If I export to PDF, can the person still see all my tabs?

Yes, but as pages instead of tabs. Each sheet becomes a separate page in the PDF file. They can flip through pages to see all your data, but they cannot edit anything.

Why does my exported file look different than the original?

Different formats handle colors, fonts, and column widths differently. PDF especially may reflow text to fit pages. Always open your exported file and check it before sending. If it doesn't look right, you may need to adjust your original file or choose a different export format.