Page Setup Dialog - Sheet
Select Grid lines to print the cell grid lines with your document. Unselect the button to hide the grid lines from your print output.
Select Black and white to convert the colours in your document to a greyscale range.
Select Do not print with all sheets if you want to avoid printing this sheet whenever you choose to print all sheets. If this item is checked then this sheet will only be printed as the active sheet or as part of a range of sheets. This is useful if you have a non-hidden sheet that contains only auxillary information and should normally not be printed.
Select Row and column headings to print the row and column headings (1,2,3,... and A,B,C,...).
Select Styles with no content to ensure cells with style changes will be printed, even if they are empty. For example, if you have a number of cells with the background color changed but no data in them, you can select this option to ensure they are in the printed output.
The Errors selection box allows you to choose how to print error values:
- Print as displayed
-
Every error value is printed just as shown on the worksheet.
- Print as spaces
-
No error values are printed.
- Print as dashes
-
Every error value is replaced by two m-dashes (separated by a thin space): "— —".
- Print as NA
-
Every error value is printed as an #N/A error.
Finally you can decide about the direction in which the workbook will be printed (Down, then right or Right, then down).