Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2017, 08:52 AM
ShankedS ShankedS is offline Layout issue with Excel, creating blank pages Windows 7 64bit Layout issue with Excel, creating blank pages Office 2010 64bit
Advanced Beginner
Layout issue with Excel, creating blank pages
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default Layout issue with Excel, creating blank pages

Everything can be seen here in the two images from my imgur link.



The fundamental problem is that, if I try and set the last column to the max width that can fit in the page, it automatically makes all of the pages to the right of a filled page active. I can reduce the column size until another column can fit in, but then I have a blank column on my page.

I just want my last column to be max width without having to worry about creating extra pages =/



Reply With Quote
  #2  
Old 03-08-2017, 08:57 PM
trevorc trevorc is offline Layout issue with Excel, creating blank pages Windows 7 32bit Layout issue with Excel, creating blank pages Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Try using...Set print area and/or Scale to fit. See how you get on....
Reply With Quote
  #3  
Old 04-10-2017, 08:35 AM
ShankedS ShankedS is offline Layout issue with Excel, creating blank pages Windows 7 64bit Layout issue with Excel, creating blank pages Office 2010 64bit
Advanced Beginner
Layout issue with Excel, creating blank pages
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

Will do, thanks. So I'll have to manually set it every time I do get to a new page?
Reply With Quote
  #4  
Old 04-10-2017, 12:35 PM
trevorc trevorc is offline Layout issue with Excel, creating blank pages Windows 7 32bit Layout issue with Excel, creating blank pages Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Yep, but you could also try playing around with the table properties and other page properties. Try and create a template to use that is saved/formatted how you want it.
Reply With Quote
  #5  
Old 04-10-2017, 04:37 PM
Logit Logit is offline Layout issue with Excel, creating blank pages Windows 10 Layout issue with Excel, creating blank pages Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Or ..

You can experiment with this approach:

https://msdn.microsoft.com/en-us/lib.../ff839804.aspx
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Layout issue with Excel, creating blank pages Struggling with a layout issue. Need Help, Please! Moondoggy Word 2 08-08-2016 07:38 PM
Layout issue with Excel, creating blank pages Deleting blank pages Microsoftenquirer1000 Word 14 08-27-2012 01:24 PM
Creating a Folding "Book style" Layout for Print? -Excel 2007 Foppa Excel 2 09-13-2011 01:25 AM
pages show in preview but not in print layout skipper64 Word 0 05-18-2010 04:46 PM
Book layout in Word or Adobe - 2 pages automatically on the screen msbytes Word 4 04-05-2010 08:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 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