/docs/community?hl=en
/docs/community?hl=en
12/14/16
Original Poster
DJN____

Google Sheets page break

I would like to print a large multi page document from a tab in sheets. However I have found no way to modify the layout short of making cells higher in order to extend the page after reviewing it in PDF.  This isn't practical in a 20 page document. Is there not a way to create page breaks in sheets? I have tried to export to Excel to print from there, but I find that many of the cell heights change on me and the text becomes consequentially hidden. This can be manually changed one row at a time but with over 200 rows its easy to miss a row, not to mention how long it takes.  Unfortunately I have not found a way to change those cells to auto-match the text successfully because they are merged cells.  

Thank you

DJN
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Was this answer helpful?
How can we improve it?
All Replies (2)
James/mreighties
12/15/16
James/mreighties
Hello,

Google Sheets does not yet have the "Page setup" feature that you may find in Excel.


You can submit feedback about this feature by doing the following steps:


  • Open a Google Sheets document.

  • Go to Help > Sheets help.

  • Click on Send feedback (in the bottom right).

  • Type in your feedback suggestions.

  • Press the blue Send button.



James :)
Kevin - Community Specialist
11/14/18
Kevin - Community Specialist
Hi everyone,

Just circling back on this thread to let you know that custom page breaks and other printing improvements are available, in case others are searching for this feature today. You can find out more about page break settings in Google Sheets through this Help Center article.

Thanks!
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google Employee — Google product team members and community managers
 
Community Specialist — Google partners who help ensure the quality of community content
 
Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert Alumni — Former Product Experts who are no longer members of the program
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.

false
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false