Merging multiple groups of cells simultaneously?

In my spreadsheet, I want to merge cells A1 and A2, B1 and B2, C1 and C2, etc. so that the whole top row of cells will be two rows tall, but still one column wide. Is there any way to do this without having to merge each two-cell group one at a time? Like, can I tell excel to merge the two rows for every column of the spreadsheet?

Or, if that can't be done, is there any shortcut to merge the cells or do I have to use the "Merge & Center" button?

Edit: To explain better, I want the top cell in each column to be two rows tall. The reason for this is that some columns require a single value, while others require two values, and to keep it looking neat I would like to merge the cells for single-value columns. And since there are far more single-value columns, it makes sense to merge the top two cells of every column then unmerge as needed.
Answer
Answer

There might be a better way but I would do the following;

 

1. Merge A1 & A2

2. Click on the FORMAT PAINTER icon (Home tab, Clipboard group)

3. Drag it across row 1 and row 2 cells for all columns (or the range you want to merge) 

This will merge B1 & B2, C1 & C2 and so on.

If this response answers your question then please mark as Answer. It helps others who browse.

252 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 8, 2025 Views 70,722 Applies to: