Shawn McClain has spent over 15 years as a journalist covering technology, business, culture and the arts. Just select all the cells, ensuring that the information you want to use is in the top-left cell in the range, then click 'Merge' in the 'Alignment' area of the ribbon.

Sometimes you may need to center a single cell's text over several cells.

Then drag the mouse to the bottom-right cell in the range and release the mouse button.Ĭlick 'Home,' then click the small arrow in the bottom corner of the 'Alignment' area of the ribbon.Ĭlick the drop-down box next to 'Horizontal' and choose 'Center.' Do the same thing in the box next to 'Vertical.' If you want to select multiple cells, click the top-left cell in the range and hold the mouse button. If you are dealing with large cells, the information inside of the cell may sit at the bottom and to one side by default, but Excel includes a feature to bring that information into the exact center of the cell, both horizontally and vertically.Ĭlick the cell where you want to center the contents. When crafting an Excel 2010 spreadsheet for your business, getting the look just right is important, making data easier to browse and understand. … How to center align elements horizontally in CSS?Ĭenter Align Elements To horizontally center a block element (like ), use margin: auto Setting the width of the element will prevent it from stretching out to the edges of its container.How to Center Horizontally & Vertically in Excel 3 Centering Tables with Table Properties.

Once you have selected the entire table, press “Ctrl” and “E” on the keyboard to center the table between the left and right margins. When a table is the same width as the page where it’s displayed, its alignment won’t be obvious. How to center a table horizontally in word?ġ Select a Table to Center. 5 Is it possible to center a table in CSS?.4 What’s the best way to center a table?.3 How do you Center an element in JavaScript?.2 How to center align elements horizontally in CSS?.

1 How to center a table horizontally in word?.

How to horizontally center in word 2013