Print spreadsheets in Zoho Sheet | Zoho Sheet Help Guide

Print spreadsheets in Zoho Sheet

To print your spreadsheet or just a selected area, 
  1. Click on the File menu, and click on the Print option. (or)
  2. Click on the printer icon on the tool bar. (or)
  3. Use the Cmd/Ctrl+P shortcut.
Once on the print preview window, here are all the options you can explore.

1. Print Area

Do you want to print just the current sheet, the whole spreadsheet or just the selected area.

2. Paper size

Zoho Sheet allows you to print in 9 default paper sizes. You can also define a custom paper size to print your data out.

3. Paper orientation

You can either print in portrait, the vertical orientation or in landscape, the horizontal orientation.

4. Scaling

You can scale content to fit the page, fit to the height, fit to the width, or choose to scale the contents manually.

5. Set margins

You can adjust the top, bottom, left and right margins.

6. Alignment

You can choose to align the print area to the vertical or horizontal center.

7. Include headers or footers

You can choose to add elements to your print file as headers or footers that'll repeat themselves on every page. 

The different elements you can make part of your header or footer are,
  1. Workbook name,
  2. Sheet name,
  3. Date, 
  4. Time,
  5. Current page number,
  6. the total number of pages.
Besides, you can also have custom elements by typing into the text boxes.

8. Change page order

If your spreadsheet content is spilling over to more than a page, you can choose to print across first and then down, or down first and then across.
​

9. Some other print options

  1. Repeat frozen rows
  2. Repeat frozen columns
  3. Include gridlines on print
  4. Include charts, images or buttons on print.