cannot select save format on excel for mac

Luigi Oppido is the Owner and Operator of Pleasure Point Computers in Santa Cruz, California.

Luigi has over 25 years of experience in general computer repair, data recovery, virus removal, and upgrades.

In this case, 100 of readers who voted found the article helpful, earning it our reader-approved status.

It can also make for easier printing and distribution of your Excel spreadsheet.

If theres only a certain part of the Excel file that you want to turn into PDF format, select it now.

If you are using Excel 2010 or earlier, select PDF from the Save as type drop-down menu in the Save As window instead.

In the Options window, you can select the range of pages included, whether the PDF includes your selection, the entire workbook, or just the active Excel spreadsheet, and if it will include the original documents properties.

Above the Options.

PDF.

Most people can stick with Standard unless the spreadsheet is very large.

Give your PDF a name and click the Publish button to create the PDF ( Save if youre using 2010 or earlier).

If you arent able to open the PDF file, you may not have a PDF reader installed.

Excel 2011 will only save all of your sheets as one PDF file if the headers and footers for each sheet are identical.

If they arent each sheet will be created as a separate PDF document, but you can also easily merge these afterwards.

Click the tab for the first sheet, hold down Shift, and click the tab for the last sheet to select all of them.

If theres only a certain part of the spreadsheet that you want to turn into a PDF, select it now.

Browse to the location that you want to save the file at, and give it a name.

At the bottom of the window, you can choose between Workbook, Sheet, or Selection.

If the headers dont match, a separate file will be created for each sheet.

Note that this will occasionally happen even if the headers and footers all match exactly.

If the conversion process resulted in multiple PDF files, you can quickly join them together using Adobe Acrobat Pro.

This will open it in Preview, allowing you to review it before you send it off.

Its not really possible to edit the PDF now, so if you need to make changes youll want to make them in Excel document and then create a new PDF.

Cannot Select Save Format On Excel For Mac