Thread
:
Split a cell
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Split a cell
You're very welcome, glade that you got it sorted out.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"rexmann" wrote in message
...
Hi Sandy
Thanks just what I needed
Cheers Rexmann
"Sandy Mann" wrote:
If I follow you correctly, try adding cells and shifting down instead of
inserting rows.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"rexmann" wrote in message
...
Hi All
I have a spreadsheet with a number of columns (6) one of the columns is
composed of 6 rows. The other 5 have the 6 rows merge into one cell. I
have
tried to show below
Merge 1 merge
Merge 2 merge
Merge 3 Merge
Merge 4 Merge
I want to be able to add 5 (or more) new rows to the non merge column
but
automatically merge the others.
I tried to use a macro but when you run it add a row for all.
Does anyone know a trick for this?
Any help greatly appreciated
Rexmann (using 2003)
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann