Un dépliant pratique, 12 pages tout en couleurs, pour retrouver rapidement les fonctions essentielles de Excel 2010 : l’interface, les fonctions essentielles, les principales nouveautés de la version 2010, les raccourcis-clavier.
It can also make for easier printing and distribution of your Excel spreadsheet. Excel allows you to create PDF versions from directly inside the program, but you can also use online conversion services if you need to convert a file but don’t have Excel installed. If there’s only a certain part of the spreadsheet that you want to turn into a PDF, select it now. Otherwise, move on to the next step. Note that a PDF cannot be easily converted back into an Excel sheet, but this method will preserve your original copy. If you’re using an older version of Excel, click the « File » menu. If you are using Excel 2010 or earlier, select « Save As » instead.
If you are using Excel 2010 or earlier, select « PDF » from the « Save as type » drop-down menu in the « Save As » window instead. This will allow you to adjust the settings for the PDF file you are about to create. Select what gets included in the PDF. 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 sheet, and if it will include the original document’s properties. Most people can stick with « Standard » unless the spreadsheet is very large. By default, the PDF file will open after it is created so that you can review it. If you aren’t 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 aren’t each sheet will be created as a separate PDF document, but you can also easily merge these afterwards. Click the File menu and select « Save As ». Browse to the location that you want to save the file at, and give it a name. Click the Format pull-down menu and select « PDF ».
This will save a copy of the spreadsheet as a PDF file. At the bottom of the window, you can choose between « Workbook », « Sheet », or « Selection ». If the headers don’t 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.
Open the folder that contains the PDF files and select all of the files that you want to merge. Open the PDF file by double-clicking it. This will open it in Preview, allowing you to review it before you send it off. It’s not really possible to edit the PDF now, so if you need to make changes you’ll want to make them in Excel and then create a new PDF. How can I get full xlsx worksheets to convert to PDF?