Hello. I use the auto fill handle to fill several cells with a number.
However, auto fill is creating a series, and I only want to copy. Each time,
I have to go into the drop down Auto Fill Options and click 'Copy Cells'
instead of 'Fill Series'. Any way to set the auto fill option to Copy Cells
instead of Fill Series? I am using 2007.
Thank you.