Forum Discussion
Solved
Something wrong with print area settings
I have a Microsoft Excel workbook with two sheets containing medical info. One sheet is “Sandra” and one is “Ron”. There are two columns: “date” & “info” Sandra can bring up her sheet, set print ...
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:
Nothing changed. still get only first column on print preiview
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?
- Overran my allowable PMs, apparently. Could you please provide an email address?
- I sent you a PM.