Sunday, 7 September 2014

How to turn off showing the margins (aka whitespace) in Excel 2010 Page Layout mode

It was driving me nuts at work, this particular spreadsheet we have. On two tabs it was showing the margins, and on two other tabs, it wasn't. I didn't need to see the margins, and for the life of me I couldn't figure out how to make things consistent.. Then I figured it out when I hovered my mouse over the area!
Show or hide white space in print layout view is the answer. It had been driving me nuts for months - doing Google searches on showing and hiding margins and results continually referring me to getting out of Page Layout view.

Simply hover your mouse over the offending margin/whitespace area and the cursor will change, with the tooltip showing "Show White Space" or "Hide White Space" depending on the current state.

No comments:

Post a Comment