Forum Discussion
Something wrong with print area settings
I have received your workbook - thanks. The problem is that the column width of column B is too large to fit on one page with column A.
One solution is to reduce the width of column B to 91 or a bit less.
Another is to specify in the Scale to Fit group of the Page Layout tab of the ribbon that the width should be scaled to 1 Page:
Activate the Ron sheet.
Activate the Page Layout tab of the ribbon.
Select Breaks > Reset All Breaks.
Does that help?
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
- The first column has a dotted horizontal line instead of a solid line next to it. It is as though the first line has a page break inserted. I have cleared l;age breaks several time. AArgh
Could you attach a copy of the workbook to a PM, instead of a screenshot?
- I sent you a PM.