View Single Post
 
Old 10-24-2020, 10:33 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Sorry missed the merge question.

if you highlight 2 cells, right click > format cells then in the horizontal alignment drop down you will see 'Center Across Selection'

It looks the same as merge but doesn’t cause any of the downstream problems.

As an example on the attached if you click on column F, you high select column F. if you click on column D you select columns D & E

In my experience Merged Cells is the work of the Devil and i would avoid in all cases!
Attached Files
File Type: xlsx Merged vs Center accross selection.xlsx (9.7 KB, 5 views)
Reply With Quote