How to Insert, Edit, or Remove Page Breaks in Microsoft Excel
If you want one sheet per page, take a look at our how-to for By default, sheets with a lot of data carry over to the other pages. You can do this by following the same basic steps as above for exporting a cell range.īefore you begin, keep in mind that you won’t have an option to select the page breaks ahead of time. Maybe you want to export the entire workbook as a PDF file. Navigate to the location where you saved the PDF to access the file. Click “OK” in the Options window and then “Publish” in the Publish as PDF or XPS window. In the Options window, pick “Selection” in the Publish What section. Optionally adjust the file name and confirm that PDF is selected in the Save as Type drop-down box. When the Publish as PDF or XPS window opens, choose a location to save the file. On the right, pick “Create PDF/XPS Document” and click the Create PDF/XPS button. Go to the File tab and select “Export” on the left side. Keep in mind that if you choose non-adjacent cells, they may display on separate pages in the PDF document. You can do this by dragging your cursor through adjacent cells or holding Ctrl as you select non-adjacent cells. How to Send Word, Excel, or PowerPoint Files as a PDF If you have a particular cell range you want to The result is a super handy document you can share any way you want.Įxport an Excel Cell Range as a PDF on WindowsĮxport an Excel Workbook as a PDF on Windows
If you want to share data from Excel without sharing the Excel file, you can export a selection of cells or the
0 kommentar(er)
