how can I insert rows in part of worksheet

's Computer Specifications

I want to insert a row (say a10:g10) in part of a worksheet (say a1:g50)
without disturbing the contents of cells in rest of row 10 (j10:n10). How I
can do this?

's Computer Specifications

It sounds like you want to insert cells not a row. highlight the cells you
want to replace and choose Insert, Cells. You will have to indicate whether
to to move dependant data down or to the right.
HTH - Sheila
www.c-i-m-s.com
MS Office training - London

"vin" wrote:

> I want to insert a row (say a10:g10) in part of a worksheet (say a1:g50)
> without disturbing the contents of cells in rest of row 10 (j10:n10). How I
> can do this?

's Computer Specifications

No I want to insert a blank row but extending up tp column g from a but
leaving the contents of the data in j10:n10 intact

"Sheila D" wrote:

> It sounds like you want to insert cells not a row. highlight the cells you
> want to replace and choose Insert, Cells. You will have to indicate whether
> to to move dependant data down or to the right.
> HTH - Sheila
> www.c-i-m-s.com
> MS Office training - London
>
> "vin" wrote:
>
> > I want to insert a row (say a10:g10) in part of a worksheet (say a1:g50)
> > without disturbing the contents of cells in rest of row 10 (j10:n10). How I
> > can do this?

's Computer Specifications

You cannot insert just part of a row.

All or nothing.

But you can insert cells as Sheila points out.

Or just copy 10 empty cells and paste onto A10:G10

Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 08:38:02 -0700, vin <(E-Mail Removed)> wrote:

>No I want to insert a blank row but extending up tp column g from a but
>leaving the contents of the data in j10:n10 intact
>
>"Sheila D" wrote:
>
>> It sounds like you want to insert cells not a row. highlight the cells you
>> want to replace and choose Insert, Cells. You will have to indicate whether
>> to to move dependant data down or to the right.
>> HTH - Sheila
>> www.c-i-m-s.com
>> MS Office training - London
>>
>> "vin" wrote:
>>
>> > I want to insert a row (say a10:g10) in part of a worksheet (say a1:g50)
>> > without disturbing the contents of cells in rest of row 10 (j10:n10). How I
>> > can do this?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
allow insert rows = false for only some of the worksheet	bill311	Microsoft Excel Worksheet Functions	1	5th Sep 2008 11:21 AM
insert rows in Multiple worksheet	will	Microsoft Excel Programming	5	28th May 2008 10:09 PM
insert rows in a worksheet that do not change adjoining rows	craigandmel	Microsoft Excel Misc	1	29th Apr 2008 10:26 PM
How do I insert blank rows between rows in completed worksheet?	=?Utf-8?B?YmJsdWUxOTc4?=	Microsoft Excel Misc	1	26th Oct 2006 07:02 PM
How do I insert rows in more than one worksheet at a time?	=?Utf-8?B?T2hpbyBhY2NvdW50YW50?=	Microsoft Excel Worksheet Functions	1	13th Oct 2006 10:14 PM