Forum Discussion
Excel: "show margins" always active
Hi Zuin_-_Amministrazione, I'm assuming you want Excel to default to the "Page Layout" view, that shows the page margins how the page will print while you're working.
Fortunately, this is a simple setting:
- Click on File > Options
- On the general tab, locate the "When creating new workbooks" section - this should be the second section down
- Locate "Default view for new sheets" and select "Page Layout View"
- Click OK
Now whenever you open a new workbook, it will display with the margins showing on all sides. You can change this at any time by following those same instructions and selecting "Normal View."
Here's a link with images showing how to do this: https://www.live2tech.com/set-page-layout-default-view-excel-2013
If you just want quick access to the Page Layout button, it should be available on the bottom right of your workbook next to the zoom icon on the green strip. There should be 3 icons down there: normal, page layout, page break. If it's not there, right click on the green strip to customize the status bar and make sure "View Shortcuts" is checked.
I hope this helps you accomplish what you're wanting to do!
- Zuin_-_AmministrazioneFeb 20, 2019Copper Contributor
Hi sally365, thank you.
You said: "I'm assuming you want Excel to default to the "Page Layout" view, that shows the page margins how the page will print while you're working", but this is not my intention.
I would like the "show margins" button in the Excel preview to always be active as a default choice, so to have a quickly change of margins.
- sally365Feb 20, 2019Brass Contributor
Thank you for the clarification. That is not a feature I use, but I searched for a solution and was unable to find a way to set that view as the default. There may be a way to do that, but not one I know of. Sorry I was unable to solve your request. Hopefully someone else will be able to.