Print spreadsheets in Zoho Sheet
To print your spreadsheet or just a selected area,
- Click on the File menu, and click on the Print option. (or)
- Click on the printer icon on the tool bar. (or)
- 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,
- Workbook name,
- Sheet name,
- Date,
- Time,
- Current page number,
- 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
- Repeat frozen rows
- Repeat frozen columns
- Include gridlines on print
- Include charts, images or buttons on print.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Link data across spreadsheets quickly
What is IMPORTRANGE, and when to use it? One of the impressive things about spreadsheets, as opposed to other applications for computation or data storage, is being able to refer to the value of one cell in whichever cell you want, even as part of a ...Export a spreadsheet from Zoho Sheet
To export spreadsheets: Click File > Download As. Choose the format in which you want the spreadsheet to be exported. The formats in which a sheet can be exported are as follows: ● MS Excel Workbook (.xlsx) ● MS Excel 97 - 2003 Workbook (.xls) ● ...Importing spreadsheets to Zoho Sheet
Import a new spreadsheet From the listing page, click on the Upload button. From the drop down, select the option to Upload Spreadsheet. You can drag and drop files from your computer into the dialog box that pops up, or click on the dialogue box and ...About Zoho Sheet
Zoho Sheet is a cloud-based spreadsheet application. It allows you to create, share, and work together on spreadsheets online, in real time. You can analyze, visualize and publish data using Zoho Sheet across multiple devices and browsers. Using Merge Templates in spreadsheets
Merge Templates in Zoho Sheet allows you to create spreadsheets with dynamic data fields with data fetched from external sources, and save the data records as files in Zoho Sheet or share them via email to respective stakeholders. Convert to Merge ...
New to Zoho LandingPage?
Zoho LandingPage Resources