Page Setup Dialog - Sheet
You can select rows or columns to be printed on every page of the output. This is commonly used for printing column or row names. To enable this, enter the range of cells to be repeated in Rows to repeat... or Columns to repeat... field. Instead of entering them manually, you can also select columns or rows to be repeated using the mouse.
Note that the rows and columns must be entered as ranges. That is, if you want to have first row repeated, you must enter 1:1, not just 1. Similarly, to have column A repeated, you must enter A:A.
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
TO BE FILLED
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.
Finally you can decide about the direction in which the workbook will be printed (Down, then right or Right, then down).