hairwormman
Programmer
Fellow Troubleshooters:
I have searched old posts and have not found anything but people broaching this subject, so here we go. I want to copy single cells in Excel by using my mouse (i.e. Auto fill). No matter what I do, Excel uses Fill Series by default (so that when I put in F02, and want to drag it to the next 20 cells it fills in F03, F04…). This even happens when I select only ONE cell, and there is only that one cell in a column I am trying to populate.
Now, I know that I can: a) hold the ctrl key, or b) click on the annoying box (after my fill), and change the checkmark from Fill Series to Copy Cells. However, I would like to avoid any additional key strokes or mouse clicks by changing the default in Auto Fill to Copy Cells.
Anyone who could provide help would be directly responsible for saving my sanity.
Cheers…Ben the worm
I have searched old posts and have not found anything but people broaching this subject, so here we go. I want to copy single cells in Excel by using my mouse (i.e. Auto fill). No matter what I do, Excel uses Fill Series by default (so that when I put in F02, and want to drag it to the next 20 cells it fills in F03, F04…). This even happens when I select only ONE cell, and there is only that one cell in a column I am trying to populate.
Now, I know that I can: a) hold the ctrl key, or b) click on the annoying box (after my fill), and change the checkmark from Fill Series to Copy Cells. However, I would like to avoid any additional key strokes or mouse clicks by changing the default in Auto Fill to Copy Cells.
Anyone who could provide help would be directly responsible for saving my sanity.
Cheers…Ben the worm