This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Can anyone suggest doing center across the selection VERTICALLY (without doing merge and center)
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you for your input but I need to do as below capture - without doing "Merge & Center"
Do you mean after unmerging, it will like this one? If yes, it only could be done with macro.
Yes exactly, this is how I need.
the screenshot is a simple example but my actual sheet is a complex one,
So, I don't want to use the "merge"
If you can help with macro, it's something invaluable
Format cell>Alignment>Center.
In my screenshot example cell C2:C6 is merged,
I need the same effect without doing merging.
What was the previous status?