How to Center Align Columns in Excel

Each cell in a Microsoft Excel spreadsheet has three text alignment options: left-aligned, center and right-aligned. You can set alignment on a per-row, per-column or individual cell basis. By default, most cells are left-aligned, though certain types of information, such as currency, right-aligns by default. You can toggle text alignment of a column at any time from the Microsoft Excel ribbon.

Instructions

1. Launch Microsoft Excel.

2. Click the "Office" button and choose "Open." Double-click on the Excel spreadsheet you want to modify.

3. Highlight the cell or cells you want to center-align. Select an entire column by clicking that column's letter at the top. Hold "Shift" to select multiple columns.

4. Click the center-align button in the "Alignment" section of the Home ribbon. The text in the selected columns now center-aligns.