Forum Discussion
rbdaves
Aug 22, 2022Copper Contributor
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 ...
- Aug 24, 2022
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:
rbdaves
Aug 24, 2022Copper Contributor
Overran my allowable PMs, apparently. Could you please provide an email address?
HansVogelaar
Aug 24, 2022MVP
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:
- rbdavesAug 24, 2022Copper ContributorGood job. Thanks.