I'm building a workbook presentation on a 1920x1080 screen. I'm going to be giving this presentation on a 1024x768 projector, and I want to format my entire workbook to perfectly fit this resolution and fully utilize the entire screen. Most of the searches I've done on this topic have to do with running a VBA to assess different setups' screen resolution and adjust the zoom; I don't want this. I know what the target resolution is, I just want to know if any of you have any tricks to use as 'border guides' from worksheet to worksheet. I've tried manipulating page breaks, print areas, etc, but these are always beholden to edge of the last 'printable' column/row, which is itself dependent on the width/height of all the other cells in the printable space... and each worksheet is different.
What do you all do to make sure the dimensions of each worksheet look perfectly flush, within the confines of a target screen resolution, when switching from sheet to sheet?
Bookmarks