Print spreadsheets in Zoho Sheet | Zoho Sheet Help Guide

Print spreadsheets in Zoho Sheet (Web)

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

  1. Choose whether to print just the current sheet, the whole spreadsheet or just the selected area. 



Idea
You can also define the print range before opening the print dialog using the Set Print Area option. Learn more on


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.