
Set or clear a print area on a worksheet - Microsoft Support
If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when …
Print a worksheet or workbook - Microsoft Support
In Excel for the web, you can either specify an area you want to print or print an entire worksheet. If you select a print area, but decide to change the specified area, here's how you can preview …
Print a sheet or workbook - Microsoft Support
To print a partial sheet, click the sheet, and then select the range of data that you want to print. To print the entire sheet, click the sheet or the sheet tab.
Print part of a sheet in Excel for Mac - Microsoft Support
Print selected cells Select the cells that you want to print. On the File menu, click Print. In the Print box, click Selection in the drop-down list. Click Print. Set a print area Excel saves the print …
Filter data in a range or table in Excel - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can …
Apply or remove cell shading in Excel - Microsoft Support
On the Page Layout tab, in the Page Setup group, select the Page Setup dialog box launcher. On the Sheet tab, under Print, make sure that the Black and white and Draft quality check boxes …
Use the Name Manager in Excel - Microsoft Support
The Name Manager dialog box is a central place to manage named ranges in your Excel spreadsheet.
Repeat specific rows or columns on every printed page
When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.
Python in Excel DataFrames - Microsoft Support
Output a DataFrame as Excel values to incorporate other Excel-based analytics like charts, Excel formulas, and conditional formatting. Use the Python output menu in the formula bar to control …
Print an Excel worksheet in landscape or portrait orientation
By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape to print it sideways.