View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default Pivot Table Range Extension.

Wicked - Thanks very much - all working fine now - thats is just great....

Thanks
Matt




Bernie Deitrick wrote:
Holding down the shift key when you drag a selection does an insert and not a replacement. Give it
a try with a small area so you can see how it works. It is the same as selecting the range, pressing
Ctrl-X (or Cutting the range), and then using Insert / Cut Cells after selecting where to insert
them. Sorry for being so cryptic.

HTH,
Bernie
MS Excel MVP

Hi Bernie
Sorry - but i am a bit confused on how i can drag that many rows ibnto a

[quoted text clipped - 18 lines]
Many Thanks
Matt


--
Matt Lynn

Message posted via http://www.officekb.com