Home Screenshots 10 Languages Why use it?

Tip of the Day | Wednesday January 21st, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Center Horizontally Across Selection Without Merging

This tool centers the value from the leftmost cell horizontally across the selected empty cells to its right, without merging any cells.

It applies Excel's built-in Center Across Selection alignment setting. This looks similar to merged cells but avoids the typical problems that merged cells cause, such as issues with sorting, filtering, or selecting data.

This is useful when:

You want a clean, centered layout without merging cells

You need to avoid problems caused by merged cells in tables or exports

You're labeling headers or section titles that span multiple columns

Compared to Excel's Merge & Center, this method is safer and better suited for structured data.

You can also apply this manually in Excel via:
Format > Format Cells > Alignment tab > Horizontal: Center Across Selection

The benefit of having this tool in ASAP Utilities is that you can assign a shortcut to it via 'My Tools & Shortcut Keys' for accessibility and quick, repeated use.

Starting this tool

Click ASAP Utilities › Format & Layout › 15. Center Horizontally Across Selection Without Merging
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Format & Layout › Center Horizontally Across Selection Without Merging

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.