Click the "Print" checkbox under the Gridlines heading in the Sheet Options group. Click "File" on the main menu, and then click "Print." Click the "Print" button to print your worksheet with ...

Excel doesn't provide a simple way to transfer print settings from an existing worksheet to a worksheet within a new workbook, but you can work around the absence of this feature.

How to automate black and white print in Excel Easy is always the best way to go, but workbooks often have more than one sheet, and those sheets have different printing needs.