How to Center Horizontally & Vertically in Excel. When crafting an Excel 2010 spreadsheet for your business, getting the look just right is important, making data easier to browse and understand.