LinkBack URL
About LinkBacks
Hello to all
I want to create about 20 cells in a column that will be merged in pairs. It means to select 40 cells in one column and use the merge command to merge these cells into 20 cells. Can anyone help?
Selecting a column of cells and creating double merged cells
Hello to all
I want to create about 20 cells in a column that will be merged in pairs. It means to select 40 cells in one column and use the merge command to merge these cells into 20 cells. Can anyone help?
Welcome to the forum.
Not possible without VBA, but nor is it advisable: merged cells are rarely necessary and should be avoided at all costs. Just make your column a bit wider And use Centre Across Selection for any text that needs to spread across two or more columns.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Don't do it. Merged cells are always a pain. Your next question will probably be something along the lines of how do I analyse this data when I have merged cells?
And the answer will, most likely be, get rid of the merged cells.
Just trying to save you some time and heartache.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks