CelticWhisper Posted June 9, 2008 Share Posted June 9, 2008 I'm having some difficulty forcing a spreadsheet to cooperate with how one of our users needs it to print. There's an extraneous column containing pricing info for a retailer she doesn't work with and she wants to exclude it from the print, scaling the remaining portion of the document up to fill the space left by the final column's removal.However, when I set a print area that excludes this unnecessary rightmost column, the remainder of the spreadsheet is not scaled up (using "Fit To" 1 wide, 5 tall). Instead, there's white space on the right side of the page that's exactly as wide as the unwanted column in prints that do contain it.Can anyone tell me how to get rid of the column and also scale up the remainder of the document to fill the page? It appears that deleting it won't work as there are merged cells in some rows that run across it. Can these be unmerged? Also, there's a dark outline that I presume is a table or group or some such meta-structure that is present in part of the column. Is there a way to get rid of that?Thanks very much. Link to comment Share on other sites More sharing options...
NukedWhale Posted June 10, 2008 Share Posted June 10, 2008 What version of Office are you using?You should be able to change the page breaks in "Page Break Preview" under view. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now