how can I insert rows in part of worksheet

V

vin

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

Sheila D

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
 
V

vin

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
 
G

Gord Dibben

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
 
Top