What are the rules that apply to using the autofill of double clicking the handle of an active cell indicator's once the pointer has turned to cross hairs?
The autofill when double clicked will only go as far down the page as the column next to it has. If there is nothing in the column next to it, then it will not move.
Yeah try this. Right click the cell and select Copy, then hold shift and double click the top of the cell. This takes you right to the top, then just paste. Works for left too
Audiojoe
But through it all when there was doubt, I ate it up and spit it out This message was edited by Audiojoe on 2002-04-20 04:49
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.