1
reader  helped!

This helped me

How to Center an Excel Worksheet

This wikiHow teaches you how to center an Excel spreadsheet in the middle of the page, using a computer. You can center your spreadsheet horizontally and vertically, using the custom margin options on a desktop computer. You can't change the margin options or center a worksheet in Excel mobile on a phone or tablet. [1]

Steps

  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f0\/Center-an-Excel-Worksheet-Step-1.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-1.jpg","bigUrl":"\/images\/thumb\/f\/f0\/Center-an-Excel-Worksheet-Step-1.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-1.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Find and double click the spreadsheet you want to edit on your computer, and open it in Microsoft Excel.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Center-an-Excel-Worksheet-Step-2.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-2.jpg","bigUrl":"\/images\/thumb\/4\/47\/Center-an-Excel-Worksheet-Step-2.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can find it on the menu bar above the toolbar ribbon at the top. It will open your layout tools on the toolbar ribbon.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5a\/Center-an-Excel-Worksheet-Step-3.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-3.jpg","bigUrl":"\/images\/thumb\/5\/5a\/Center-an-Excel-Worksheet-Step-3.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can find it in the "Page Setup" section of the Page Layout toolbar. It will open your margin options on a drop-down menu.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cb\/Center-an-Excel-Worksheet-Step-4.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-4.jpg","bigUrl":"\/images\/thumb\/c\/cb\/Center-an-Excel-Worksheet-Step-4.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-4.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This option is at the bottom of the Margins menu. It will open your advanced margin options in a new pop-up window.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Center-an-Excel-Worksheet-Step-5.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-5.jpg","bigUrl":"\/images\/thumb\/7\/70\/Center-an-Excel-Worksheet-Step-5.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-5.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can find it at the bottom of the Margins window.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Center-an-Excel-Worksheet-Step-6.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-6.jpg","bigUrl":"\/images\/thumb\/f\/fb\/Center-an-Excel-Worksheet-Step-6.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-6.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    When this option is checked, your spreadsheet will be horizontally centered on the page.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8e\/Center-an-Excel-Worksheet-Step-7.jpg\/v4-460px-Center-an-Excel-Worksheet-Step-7.jpg","bigUrl":"\/images\/thumb\/8\/8e\/Center-an-Excel-Worksheet-Step-7.jpg\/aid10972436-v4-728px-Center-an-Excel-Worksheet-Step-7.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    When this option is checked, your spreadsheet will be vertically centered in the middle of the page.
    • You can check both boxes, and center your spreadsheet in the middle.
    Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

      Advertisement

      Tips

      • On Mac, you can also click the File menu on the menu bar, and select Page Setup here to open the same window.
        Thanks
        Helpful 0 Not Helpful 0
      Advertisement

      You Might Also Like

      How to
      Store and Read Documents on an iPhone
      How to
      Copy a QR Code on Android
      How to
      Lock the Gallery on Samsung Galaxy
      How to
      Call Someone on a Computer
      How to
      Download Images from Google on PC or Mac
      How to
      Remove Website Data from Safari in iOS
      How to
      Turn on Lights Out Mode on Twitter
      Can You Delete Screen Time History? FAQ for Apple Screen Time
      How to
      Change The Font Size on an iPhone
      How to
      Make Desktop Icons Bigger
      How to
      Turn Off Notifications on PC or Mac
      How to
      Block Text Messages on an iPhone
      How to
      Tell if Your Snapchat Message Was Read
      How to
      Update Telegram on Android
      Advertisement

      References

      1. ↑ https://support.office.com/en-ie/article/change-margins-in-office-apps-on-your-mobile-device-7d9d65be-1066-45bb-9c67-ce2958acb476

      About this article

      Article Summary X

      1. Open your spreadsheet in Excel.
      2. Click the Page Layout tab at the top.
      3. Click Margins on the toolbar.
      4. Click Custom Margins .
      5. Find "Center on page" at the bottom.
      6. Click and check Horizontally .
      7. Click and check Vertically .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 22,812 times.

      Is this article up to date?

      Advertisement