If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|