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 area and print.
Ron can bring up his sheet and set print area consisting of two columns and several lines, but when he selects “print”, he gets the print preview and it shows two pages. First page = first column, 2nd page = second column. Resetting the print area doesn’t work.
This file is used on a Windows 11 computer. It is was started about 20-years ago
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?
- 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.
