Tick “ Entire Workbook” or hit the “ E” button on your keyboard.Įxcel automatically selects the most suitable orientation to ensure your sheets remain readable.Set the file format to “ PDF,” then click on “ Options…”.With your workbook open, go to “ File” > “ Save As.” Choose where you want to store your PDF file.Notice that the only part of the sheet saved is the table: 4. You can also hit the “ B” button on your keyboard. Next to “ Save as Type,” select “ PDF” and “ Options…”.Head to “ File” > “ Save As.” Select a save location for your PDF file.You can do this by clicking anywhere on the table. On your spreadsheet, select the table that you want to save as PDF.Here’s a quick guide on how to save tables as PDFs in Microsoft Excel. Select “ Save” to store your PDF file in your chosen location.Īs you can see, only the selected area of the sheet was included in the PDF file: 3.To save a specific section in PDF format, click on “ Selection” (or hit the “ S” key on your keyboard). A dialog box will open where you can choose to convert a selection, the active sheet, a table, or the whole workbook.Next to “ Save As Type,” choose “ PDF.”.Choose a save location for your converted file.Select the area that you want to convert into a PDF.Review and verify that it looks the way you want it to. Hit “ Save.” If you tick “ Open File After,” your PDF file will automatically open.Under the section “ Publish What,” select “ Active Sheet(s).” Alternatively, you can hit the “ V” key on your keyboard.Expand the drop-down next to “ Save as Type.” Select “ PDF” from the options.Alternatively, you can click on “ Export” > ” Create PDF/XPS” to get to the same dialog box. Select the “ Browse” icon to choose where you want your converted sheet to be saved.To select more than one sheet, press the “ Ctrl” key on your Windows keyboard (or “ Command” on Mac) while clicking the desired sheet tabs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |