Thread: How can I copy big ranges of cells without drag or copy/paste?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
  
Posts: 703
Default How can I copy big ranges of cells without drag or copy/paste?
Use 'Go To' on the Edit menu (CTRL + G). In reference field enter the
range you want to copy like A1:F25, and click ok. Now the range is
selected and ready to be copied.

Hopes this helps.
....
Per

On 22 Mar., 22:20, Ricardo Julio <Ricardo
wrote:
I need to copy formulas in a big range of cells and I'm sure there should be
a way different than dragging until the last cell I want to copy it. I'm
talking of hundreds of cells where I want to copy the formulas.
Thanks,

Reply With QuoteReply With Quote