How to Center a Worksheet Horizontally in Excel 2007


Although Excel 2007 is not a word processor, you may need to center your worksheet's contents from time to time. When you add content to a worksheet in Excel 2007, the information is left-justified by default. Choose to center your worksheet horizontally from page to page instead. The centering is applied to the selected worksheet alone. So, if you want to center each worksheet in your workbook, you'll need to select and format those worksheets as well.

  • Select the Office Button and click "Open." Double-click the file you want to modify in the "Open" dialog box. It loads on your page.

  • Select the worksheet you want to align in the workbook. To center each worksheet in your file, right-click on any worksheet tab (at the bottom of your page) and choose "Select All Sheets" from the pop-up list.

  • Select the "Page Layout" tab. Click the arrow on the right of the "Page Setup" group.

  • Select the "Margins" tab in the "Page Setup" dialog box.

  • Go to the "Center on page" section and check "Horizontally." Click "OK."

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!