| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why has Office Download KB967642 defaulted cells to Accounting | Excel Discussion (Misc queries) | |||
| How do I drag a hyperlink series to fill instead of copy? | Excel Worksheet Functions | |||
| I want to use a fill series to copy down a pattern of dates. | Excel Discussion (Misc queries) | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
| Can I use AutoFill or a formula to fill a series of letters? | Excel Discussion (Misc queries) | |||
Linear Mode
