Wharton & Wall Street Prep Private Equity Certificate: Now Accepting Enrollment for May 1-June 25 →
Wall Street Prep

Center Across Selection in Excel

Guide to Understanding "Center Across Selection" in Excel

Learn Online Now

Center Across Selection in Excel

How to Center Across Selection in Excel (Step-by-Step)

In Excel, “Center Across Selection” is a built-in feature that allows the centering of text in a cell across multiple columns.

The presentability of a financial model can be improved by centering text across multiple columns.

However, it is important to ensure that the formatting does not reduce a model’s structural integrity or make the navigation of the spreadsheet more cumbersome, which is a primary reason to avoid merging cells.

Therefore, it is a best practice to use the “Center Across Selection” feature in Excel, rather than merging cells.

In addition to maintaining a model’s flexibility—unlike merging cells—the center across selection feature can also remove the need to manually adjust the width of a column to fit the text.

The steps to use the center across selection feature in Excel are as follows:

  • Step 1 → Select the Cell Range to Center the Text Across
  • Step 2 → Press “Ctrl + 1” to Open the Format Cells Box
  • Step 3 → Open the “Horizontal:” Drop-Down Menu in the “Alignment” Tab
  • Step 4 → Click the “Center Across Selection” Option and Press the “Enter” Key

In order for the correct text to be centered, it is necessary for the intended text (or number) to be entered in the first cell of the selected range.

Excel Tutorial: How to Center Text Across Multiple Columns

Suppose you’re forecasting the income statement of a company and want to center the “Projected” text across the five-year forecast period, as in the two-year “Historical” period.

Unformatted Columns

Start by selecting the range of cells that correspond to the forecast (F3 to J3) and pressing “Ctrl + 1” to open the formatting box.

From the “Alignment” tab, open the “Horizontal:” drop-down menu in the text alignment section.

How to Center Across Selection in Excel

Choose the “Center Across Selection” option, and upon doing so, the formatting should apply, wherein the first cell in the range—the “Projected” text—is centered across the five columns.

Excel Center Across Selection

Center Across Selection vs. Merging Cells

Why Avoid Merging Cells in Excel?

The Center Across Selection feature is a far more practical alternative to merging cells, where text can be centered across cells without diminishing the quality of model’s structure.

Merging cells in a financial model should be avoided as a general best practice.

A well-built financial model should be easy to navigate and edit. However, merging cells causes a spreadsheet to lose the structural integrity of its columns and rows.

For instance, attempting to select a column with a cell that is part of a merged cell automatically results in all of the columns containing one of the merged cells to be selected, which may or may not be the intention.

The merged cells would need to be unmerged and reformatted, which is inefficient given how easily it could have been avoided in the first place.

The “Center Across Selection” feature in Excel is therefore the preferable alternative to merging cells to maintain the flexibility of the model structure.

Turbo-charge your time in Excel Used at top investment banks, Wall Street Prep's Excel Crash Course will turn you into an advanced Power User and set you apart from your peers.
Learn More
Inline Feedbacks
View all comments

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.