Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-19-2015, 10:29 AM
jood jood is offline Print output on a long report is too small Windows 7 32bit Print output on a long report is too small Office 2007
Novice
Print output on a long report is too small
 
Join Date: Oct 2015
Posts: 3
jood is on a distinguished road
Default Print output on a long report is too small


I have a long report. I want all the columns on one page, but the rows can split across pages. Excel prints too small by default. I've tried the following:

- Scaling a percentage, but then the columns split.

- Fitting to 1 page wide by 4 pages tall, but it squashes the output onto 2 pages.

- Increasing the size of the data in the cells, with no effect.
Reply With Quote
  #2  
Old 10-19-2015, 03:47 PM
macropod's Avatar
macropod macropod is offline Print output on a long report is too small Windows 7 64bit Print output on a long report is too small Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Have you tried narrowing the columns, whilst allowing them to use text-wrapping? This is only useful for columns containing text.

Have you considered changing the page orientation from portrait to landscape?

Have you tried reducing the page margins?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-19-2015, 06:26 PM
jood jood is offline Print output on a long report is too small Windows 7 32bit Print output on a long report is too small Office 2007
Novice
Print output on a long report is too small
 
Join Date: Oct 2015
Posts: 3
jood is on a distinguished road
Default

This is a fiscal report so the first option wouldn't work, but the landscape and the smaller margins both worked. Thank you!!!
Reply With Quote
  #4  
Old 10-19-2015, 06:31 PM
macropod's Avatar
macropod macropod is offline Print output on a long report is too small Windows 7 64bit Print output on a long report is too small Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could also use a narrower font (e.g. Arial Narrow), which would then allow you to increase the point size for greater legibility.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-19-2015, 06:45 PM
jood jood is offline Print output on a long report is too small Windows 7 32bit Print output on a long report is too small Office 2007
Novice
Print output on a long report is too small
 
Join Date: Oct 2015
Posts: 3
jood is on a distinguished road
Default

Thanks again.

Now, how do I show this question as 'Solved' ???
Reply With Quote
  #6  
Old 10-19-2015, 07:27 PM
macropod's Avatar
macropod macropod is offline Print output on a long report is too small Windows 7 64bit Print output on a long report is too small Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

From the 'Thread Tools' dropdown. Done.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print settings - Short Edge Changes to Long robhag111 Word 0 04-22-2015 05:01 PM
Print output on a long report is too small Copy matching data from one report cell to another cell report mbesspiata Excel 9 01-15-2015 01:49 PM
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
mail merge output to .pdf eNGiNe Mail Merge 3 09-29-2013 11:45 PM
Output Presentation Settings yeapurvz10 PowerPoint 0 09-17-2010 10:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:34 PM.


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