Thread: how can I insert rows in part of worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheila D Sheila D is offline
external usenet poster
  
Posts: 65
Default how can I insert rows in part of worksheet
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?
Reply With QuoteReply With Quote