Discussion
I'm trying to merge some cells - 3 cells in a row, data in left hand cell, middle and right cells empty, want to make one big cell. I can do it individually, but I have about 100 rows to do and if I select it all and use the merge cells tool it only keeps the top left hand cell!
Help!
Help!
Merge three cells somewhere out of the way - ie. blank cells e.g. AA2 to AC2
Stick a formula in the merged cells e.g. =A2 to copy the contents of A2
Drag the bottom right corner of AC2 (i.e. the bottom right cornet of the three merged cells) down 100 times
Copy the merged cells to where you want them - you will probably need to Right click/Paste Special/Paste Values when you move them
Hope that helps
Stick a formula in the merged cells e.g. =A2 to copy the contents of A2
Drag the bottom right corner of AC2 (i.e. the bottom right cornet of the three merged cells) down 100 times
Copy the merged cells to where you want them - you will probably need to Right click/Paste Special/Paste Values when you move them
Hope that helps
)Once you have the column of merged cells with your 100 values in, aa2 - ac2 down to aa102 to ac102, hightlight and right click them and click copy, then right click them while they are still highlighted and Paste Special/Values. You can then drag them around
Edited by TurricanII on Wednesday 23 January 00:51
TurricanII said:
Once you have the column of merged Cells with your 100 values in, aa2 - ac2 down to aa102 to ac102, hightlight and right click THEM and then right click them while they are still highlighted and Paste Special/Values. You can then drag them around
Yes, that worked, but it's only one cell wide again now 
NiceCupOfTea said:
TurricanII said:
Once you have the column of merged Cells with your 100 values in, aa2 - ac2 down to aa102 to ac102, hightlight and right click THEM and then right click them while they are still highlighted and Paste Special/Values. You can then drag them around
Yes, that worked, but it's only one cell wide again now Pressing CTRL while selecting multiple groups of cells. then click format cells, merge
GasMonkey said:
NiceCupOfTea said:
TurricanII said:
Once you have the column of merged Cells with your 100 values in, aa2 - ac2 down to aa102 to ac102, hightlight and right click THEM and then right click them while they are still highlighted and Paste Special/Values. You can then drag them around
Yes, that worked, but it's only one cell wide again now Pressing CTRL while selecting multiple groups of cells. then click format cells, merge
It's just a grid of 3x100 cells with the left hand one filled with text (no formulae).
I've actually done it all by hand now, but it's annoying me that something that seems quite simple is so difficult...
Mattt said:
Merging cells is the only improvement in Excel 2007 i've found so far - very easy!
Haha, yeah, totally agree! 
When I had to do stuff like this manually (in Office 2003), after merging one set of cells then I used to select the next set of cells with the mouse and use the F4 key (repeat previous command) to then merge the cells again. Minimises mouse movement if nothing else and speeds up the process.
Office XP and above can merge by row over a large selection.
The command is quite hidden though.
As far as I know I can only find it by creating a button for it.
Go to view, toolbars, customise;
under commands tab look under format and as you scroll down there is a command call "merge accross".....drag and drop the button onto your toolbar and away you go.
There are a number of very useful merge button under the commands tab.
Hope that helps.
The command is quite hidden though.
As far as I know I can only find it by creating a button for it.
Go to view, toolbars, customise;
under commands tab look under format and as you scroll down there is a command call "merge accross".....drag and drop the button onto your toolbar and away you go.
There are a number of very useful merge button under the commands tab.
Hope that helps.
I went to kip! I got the same error as you if I dragged the block of merged cells and drop them partially over where they used to be. I guess you were dragging them one cell to the left, so you were dragging merged cells and dropping them overlapping the original location..
If it is of use in the future, Drag the block of merged cells right accross the sheet - well out of the way..
If it is of use in the future, Drag the block of merged cells right accross the sheet - well out of the way..
Flawed said:
NiceCupOfTea said:
I've actually done it all by hand now, but it's annoying me that something that seems quite simple is so difficult...
Damn it I thought I was going to be able to use one of my new favourite words: "concatenate"Oh well always a next time.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff