How to Center a Worksheet Horizontally in Excel 2007

Written by foye robinson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Center a Worksheet Horizontally in Excel 2007
(Stockbyte/Stockbyte/Getty Images)

Although Excel 2007 is not a word processor, you may need to centre 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 centre your worksheet horizontally from page to page instead. The centring is applied to the selected worksheet alone. So, if you want to centre each worksheet in your workbook, you'll need to select and format those worksheets as well.

Skill level:


  1. 1

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

  2. 2

    Select the worksheet you want to align in the workbook. To centre 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.

  3. 3

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

  4. 4

    Select the "Margins" tab in the "Page Setup" dialogue box.

  5. 5

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.