Before printing, specify how you want the printed page to look using the Page Setup dialog box. Then print to a printer or PDF. Show
Set up the pageYou can apply different page setup options for each worksheet in a workbook, For example, worksheets can print with titles showing or hidden, with unique page orientation, and more. To begin, select File > Page Setup. General settings (available for individual sheets, not dashboards)
Layout settings
Print Scaling settingsThese settings affect only printed documents, not exported images or PDFs. However, the page orientation settings are used as the default when you publish the workbook to Tableau Online or Tableau Server.
Print a viewAfter you have configured the Page Setup settings, select File > Print. The following options in the Print dialog box are unique to Tableau. Show SelectionsWhen this option is selected any selections you’ve made in the views will be maintained while printing. Change the Print RangeWhen you print from a workbook with multiple worksheets, each worksheet represents one or more printed pages, depending on the page setup. Select from the following print ranges:
You can select multiple worksheets in a workbook by holding down the CTRL or Shift keys (or the z key on a Mac) while clicking the worksheet tabs that you want to select. Print to PDFNote: If you're using Tableau Online or Tableau Server, instead see Download Views and Workbooks and Link to a PNG, PDF, or CSV of a View. In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer. When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. Print to PDF using a Windows computer
Print to PDF using a Mac computer
Which of the following options can you set to make sure a worksheet will print on one page?Shrink a worksheet to fit on one page. Click Page Layout. ... . Select the Page tab in the Page Setup dialog box.. Select Fit to under Scaling.. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes. ... . Press OK at the bottom of the Page Setup dialog box.. How do I print a worksheet on a specific page?To print a worksheet on a specific number of pages, in Page Setup, click the small window launcher button. Then, under Scaling, in both of the Fit to boxes, enter the number of pages (wide and tall) on which you want to print the worksheet data.
How do I print only one page in Excel?On the worksheet, click and drag to select the cells you want to print. Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.
|