Blog


← Back to BLOG

17
Dec
2014
How to Center an Excel Table

How to Center an Excel Table

Have you ever wanted to print a table that has the full power of Excel but still looks nice when you print it? Don't limit yourself with a table in Word. Instead, follow the steps below. 

Step 1: Highlight the data you wish to use in your table. Make sure the data starts in cells on the left edge of the spreadsheet. 

Click the Insert tab > Table. When a window pops up confirming your data selection, click OK.

Step 2: Click the Page Layout tab. In the Page Setup section, click the little arrow on the bottom right-hand corner to open the Page Setup dialog box.



In the Margins tab, chose Center on page > Horizontally. Click OK. 



Step 3: Press Ctrl+P to see the Print Preview. The table will be centered on the page when you print it.



Bonus Tip: Center the table's title by selecting all the cells across which it should be centered and clicking Merge and Center. 



Please note:
>This centering trick will not work well for a spreadsheet filled with data, or for a sheet with multiple tables.
>However, it is optimal for printing a table whose data you may need to manipulate again later. 
>The centered formatting works best if you enter your data in a cell on the left edge of the spreadsheet. 
 


If you have an unanswered technical question that you would like to see addressed in an upcoming issue, feel free to email it to social@navitend.com

Testimonials

  • "Thanks so much again for taking care of everything in such an expedient manner. It's a pleasure to work with navitend and its staff as always!"

    Lawrence Wolfin / Textol Systems, Inc.
  • “Navitend’s expertise helped our firm over the past year to effectively elevate our I.T. game, powering our website into a highly interactive tool. Well done to Frank and his team!”  

    Chuck Steege, CFP®, CEP, President, SFG Wealth Planning Services, Inc.
  • "Thanks so much!  You are a class act!  
    You and your team have really done an excellent job on this!"

    Steve Van Ooteghem, The C12 Group in Houston, Texas
  • "I look forward to working with you again in the future. Once again, thanks to your organization for your prompt response."

    Luke Wolters / Luke Wolters Tax Consultants
  • "navitend has been a great IT partner for our company.  Their helpdesk response time is the best I have experienced in my 30 year career.  navitend has helped me to have great IT services without the need to have a full time, in house, technician at significant savings to our company."

    Bob Bradley, President, Bradley Graphics
  • "I appreciate that they didn’t just build the application. They made it better by bringing ideas to the table that not only made for a better user experience, but also kept the development costs down."

    Andy Lynch / North Star Marketing
  • "We've dedicated our lives to growing our retail and ecommerce business and it's a relief to have found a company like navitend who treats our business likes it's their own. navitend's personal approach to project management and problem solving are top-notch."

    Stamatis, Co-owner Twisted Lily, Fragrance Boutique and Apothecary
  • "Our company is more efficient and has grown as a result of navitend’s work. navitend helped us get to the next level."

    Greg Niccolai / Madison Insurance