For example if you want to center a worksheet horizontally and vertically in excel 2010 when the document is printed it is possible to configure your sheet so that your desired print layout occurs. If the worksheet data is small enough the placement of the data on the printed sheet can detract from what you are trying to convey.
Lori kaufman at howtogeek november 6 2015 1024am edt.
Center worksheet in excel. By default it will print in the upper left corner of the page. If you have created a small worksheet in excel you may want to center it on the page when you print it. For a very small set of data this can detract from the effectiveness of your presentation.
If you have a label or heading on a spreadsheet in excel that you want to center across a certain number of cells there are couple of ways you can do this with or without merging cells. You can center the data horizontally vertically or both. Page margins are the blank spaces between the worksheet data and the edges of the printed page.
To help offset this problem excel provides a way you can easily center your printed information. You can change this however by adjusting a few page settings for your document. If you only wish to center it in one of these ways then only select that option in step 5 below below.
How to center text across multiple cells in excel. Center your spreadsheet on the page in excel 2013. How to center an excel worksheet.
You can center your spreadsheet horizontally and vertically using the custom margin options on a. To better align a microsoft excel worksheet on a printed page you can change margins specify custom margins or center the worksheeteither horizontally or vertically on the page. This wikihow teaches you how to center an excel spreadsheet in the middle of the page using a computer.
Choose page setup from the file menu. There is an easy way to center the data on the printed page. These steps will center the spreadsheet both vertically and horizontally.
Page margins are the blank spaces between the worksheet data and the edges of the printed page. Well show you both ways. Quick summary how to center worksheet in excel 2010.
Microsoft excel allows you to align worksheet on a page you can change margins specify custom margins or center the worksheet horizontally or vertically on the page. This article will show you how to configure your spreadsheet in excel 2013 so that it prints on the center of the page.
0 comments