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.

Q. I have an amortization schedule arranged vertically in Excel on Sheet 1 that I want to reference horizontally in my income statement on Sheet 2. Is there a way to write and copy/paste a single ...