how to center the worksheet horizontally on the page in excel This is a topic that many people are looking for. newyorkcityvoices.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, newyorkcityvoices.org would like to introduce to you Excel 2016 – Center a Worksheet Horizontally and Vertically on the Page. Following along are instructions in the video below:
“And welcome students in this microsoft excel 2016. Tutorial. I m gonna show you how how to center a worksheet horizontally and vertically on the page let s get started. You ll see that i have some content here on my page and let s say that i want to print.
It out and i want it to be at the center of the page well you ll see if you go to the file tab. So the print button that by default excel pins everything to the top left of the margin. I m going to show you in this tutorial. How to not only move it to the center horizontally.
But also move it to the center vertically and then by the end of this it ll be right in the center of our page well first. I m going to click back and then i m gonna go to the page layout tab on the page layout tab. You ll see. The page setup.
Group. And there s a button right. Here for the margins. And this is where you could set the margins for your entire workbook i m gonna click on that and then i ll go down here to custom margins after you click custom margins the dialog box for the page setup will pop up and then you ll see your top right bottom.
And left margins as well as the space. That s dedicated for the header and footer it ll also show you a preview of how your document looks these this little grid here shows. You where. The document is currently pinned to which is the top left.
If i want to center. It on the page. There s two check boxes here horizontally which you ll see on the diagram when i click. It that ll move it towards the middle of the page at any time.
I could also preview it to see it has now been centered in the top of the page. So that s how you center you at the top of the page you have to center. It horizontally a quick way to get back to the preview that i was just at the page setup dialog box is to click page setup right here in the print menu and that ll actually bring it back up and click margins. And that s where we were before and now i could click vertically and you ll see that that ll move my diagram down or my preview down just a little bit to the center and if i click ok here it ll move it to the center.
So once again i went to page layout. Margins custom margins. I click both of these checkboxes and then you could click print preview to view it on the file tab and there we go we see it s now in the middle of the page on both the center or a horizontal and vertical plane. So that s how you center your page horizontally and vertically within microsoft excel.
So when you get ready to print. It it ll print out right in the middle of the page. I hope this video has been helpful for you if it has please give it a thumbs up and consider subscribing to the channel. If you have any questions please put it in the comment section below.
And i ll do my best to get back to you thank you for ” ..
Thank you for watching all the articles on the topic Excel 2016 – Center a Worksheet Horizontally and Vertically on the Page. All shares of newyorkcityvoices.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.