Is it possible to merge 2 adjacent columns in one or two steps without
having to do each one individually

Easy, but you have to use a menu choice not shown on the menus by default.
Do a View, Toolbars, Customize and click the Commands tab. Select the
Format category and in the right list box find "Merge Across". Drag this up
to say your Format menu, which will open automatically and you can drop it
wherever you want in it. Then close Customize.

Now you can select a range like G1:H10 and click this command to get 10
merged cells.


--
Jim Rech
Excel MVP
<Martin ©¿©¬ @mandeREMOVETHIS.plus.com wrote in message
...
| Hi
| I have a worksheet with 300 rows
| Is it possible to merge 2 adjacent columns in one or two steps without
| having to do each one individually
| I've just learnt how to merge 2 adjacent cells to include all data in
| the range in the merged cell
|
| column C has the word 'dist' in ever row
| column D has numbers from 1 to 14 in random order
|
| using Excel 2000
|
| Martin
| ©¿©¬
|
|