Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2018, 04:28 AM
christ christ is offline How can I print rows that go outside of the page without shrinking the text? Windows 10 How can I print rows that go outside of the page without shrinking the text? Office 2016
Novice
How can I print rows that go outside of the page without shrinking the text?
 
Join Date: Feb 2018
Posts: 2
christ is on a distinguished road
Default How can I print rows that go outside of the page without shrinking the text?

I have a sheet like this below:



https://docs.google.com/spreadsheets...it?usp=sharing

I would like to print this, without shrinking, so the long rows get included - each long row should fit by spreading on 2 or more lines while preserving the row structure.

I could manually hit enter and make 2nd column rows fit but this takes time I'm pretty sure it has to be something better than this.
Reply With Quote
  #2  
Old 02-06-2018, 06:21 AM
Alsadius Alsadius is offline How can I print rows that go outside of the page without shrinking the text? Windows 7 64bit How can I print rows that go outside of the page without shrinking the text? Office 2010 32bit
Novice
 
Join Date: Nov 2017
Posts: 25
Alsadius is on a distinguished road
Default

I can't see the google doc, but I suspect what you want is to turn on Wrap Text, at which will prevent cells from going beyond their width limit, and will make them taller instead. Depending on exactly how your formatting is set up you may get a sheet that will automatically expand rows vertically as needed, but if it doesn't then just highlight all relevant rows and auto-fit them(double-clicking a row boundary is usually the easiest way to do that).
Reply With Quote
  #3  
Old 02-06-2018, 09:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How can I print rows that go outside of the page without shrinking the text? Windows 7 64bit How can I print rows that go outside of the page without shrinking the text? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

FYI this is an Excel forum, not Google doc
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 07-29-2018, 05:20 AM
christ christ is offline How can I print rows that go outside of the page without shrinking the text? Windows 10 How can I print rows that go outside of the page without shrinking the text? Office 2016
Novice
How can I print rows that go outside of the page without shrinking the text?
 
Join Date: Feb 2018
Posts: 2
christ is on a distinguished road
Default

Quote:
Originally Posted by Alsadius View Post
I can't see the google doc, but I suspect what you want is to turn on Wrap Text, at which will prevent cells from going beyond their width limit, and will make them taller instead. Depending on exactly how your formatting is set up you may get a sheet that will automatically expand rows vertically as needed, but if it doesn't then just highlight all relevant rows and auto-fit them(double-clicking a row boundary is usually the easiest way to do that).
Wrap Text This is exactly what I was looking for. Thank you!
Reply With Quote
Reply

Tags
print

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
The best practice to print 20,000 rows of 6-columns each in pdf landscape A3 page size while to repe Majdoleen Excel 0 04-25-2017 01:02 PM
How can I print rows that go outside of the page without shrinking the text? MS Word 2010 Table Selector Selects Header On One Page and Rows On Next Page scptech Word Tables 4 01-11-2016 02:55 PM
How can I print rows that go outside of the page without shrinking the text? Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
How can I print rows that go outside of the page without shrinking the text? Table of Contents Shrinking Font to Fit Text on One Line - How to stop this? Jgreer0315 Word 3 02-13-2014 03:18 AM
How can I print rows that go outside of the page without shrinking the text? Inability to print text less than 1.5cm from the bottom of the page Horatio Word 1 10-07-2011 01:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft