Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 21st 10, 05:21 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 4
Default Can Autofill be Defaulted to copy cells instead of fill series

i know im just being lazy but i use the drag box to copy lots of data and it
always wants to copy as an incremental series and i want it to default to
just copy cells without having to open the autofill menu and select it..

Thanks
Barry

  #2   Report Post  
Old January 24th 10, 10:16 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 414
Default Can Autofill be Defaulted to copy cells instead of fill series

Hi Barry,

I had the same problem. All you have to do is press "Ctrl" while you are
dragging the data.

Andy

"Barry A&P" wrote:

i know im just being lazy but i use the drag box to copy lots of data and it
always wants to copy as an incremental series and i want it to default to
just copy cells without having to open the autofill menu and select it..

Thanks
Barry

  #3   Report Post  
Old January 24th 10, 05:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Can Autofill be Defaulted to copy cells instead of fill series

In addition you can right-click and drag......release and "Copy Cells"


Gord Dibben MS Excel MVP

On Sun, 24 Jan 2010 02:16:01 -0800, Andy
wrote:

Hi Barry,

I had the same problem. All you have to do is press "Ctrl" while you are
dragging the data.

Andy

"Barry A&P" wrote:

i know im just being lazy but i use the drag box to copy lots of data and it
always wants to copy as an incremental series and i want it to default to
just copy cells without having to open the autofill menu and select it..

Thanks
Barry


  #4   Report Post  
Old January 26th 10, 01:06 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 4
Default Can Autofill be Defaulted to copy cells instead of fill series


you get so used to doing things in certain ways, a simple tip in technique
helps

Thanks guys

"Gord Dibben" wrote:

In addition you can right-click and drag......release and "Copy Cells"


Gord Dibben MS Excel MVP

On Sun, 24 Jan 2010 02:16:01 -0800, Andy
wrote:

Hi Barry,

I had the same problem. All you have to do is press "Ctrl" while you are
dragging the data.

Andy

"Barry A&P" wrote:

i know im just being lazy but i use the drag box to copy lots of data and it
always wants to copy as an incremental series and i want it to default to
just copy cells without having to open the autofill menu and select it..

Thanks
Barry


.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why has Office Download KB967642 defaulted cells to Accounting TeaPea Excel Discussion (Misc queries) 0 May 8th 09 03:34 AM
How do I drag a hyperlink series to fill instead of copy? PCRONE Excel Worksheet Functions 2 April 16th 08 01:41 AM
I want to use a fill series to copy down a pattern of dates. DEQhl Excel Discussion (Misc queries) 1 December 20th 07 09:18 AM
How can I autofill a series to reference non adjacent cells? Microcell Excel Discussion (Misc queries) 1 June 30th 05 09:49 PM
Can I use AutoFill or a formula to fill a series of letters? tadpgk835 Excel Discussion (Misc queries) 3 April 28th 05 02:46 PM


All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017