The June 2020 IIL blog features several techniques for advanced margin & page break controls for Microsoft Excel spreadsheets.

 

Using Page Layout Features with Efficiency

It seems not much has been written about this feature. In this blog, I’ll cover the items shown here (which do not include all the commands in the Page Layout tab). If you click the dropdown arrow below Margins (in the Page Setup group) — You can select any of the built-in margins if it fits your needs, or you can modify them using the bottom item, “Custom Margins…” It looks like the first 2 choices have identical settings, but the “Last Custom Setting” changes to reflect the last setting you used. Suppose you select Custom Margins. If you change some of these settings, say the top, left, bottom and right are all set to .5 (inches), then when you click the dropdown next time, you’ll see this at the top …