So I know its possible to merge cells across but I am wondering if it is possible to do the same thing up and down across columns. I am trying to merge and center the cells in the excel doc attached (see yellow highlighted area) without doing it one by one. Is there a way to do this at all?
Any help would be awesome
Thanks!
Move the text in Row 3 up to row 2
Select the merged cells F2:F3
Select the format painter
Select the range G2:V3
All your desired cells will be merged in pairs.
That being said, merging is not usually a good idea. It can cause problems down the road. Why do you want to do this?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks Jeff I followed your advice and ended up with the attached which is unfortunately not what I am looking to do - I am looking for the - I want to merge these cells so that I can wrap the text later on to make the width of the cells smaller and more presentable.
I don't think you followed the directions exactly. Here is what I got.
By the way you can just change the height of the row, without having to merge.
Apologies you were right - this is great thanks. I can't believe I didn't think of changing the height of the cell!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks