One of the biggest struggles I notice with novice Microsoft Excel users is simply where to “click”. Instructions like, “Double Click the autofill handle” or “Click and drag between the rows,” may not be clear enough. The reason for this is, what the user intends to click on and what they end up clicking on can often be a difference of a fraction of a centimeter. I have seen students who are already uncomfortable with the program get frustrated when they are trying to tell the program to do one thing but they are just slightly off with the mouse. Thankfully Microsoft created a set of dynamic icons, or “looks”, for the cursor that tell the user what will happen before they do it. I always make a point to explain this and I find it eases some of the frustration. The most common issue seems to be selecting the autofill handle. This makes sense because there is a lot going on in the junctions of the cell.
When you try and grab the autofill handle you will get one of the four options above.
Number (2) is the cursor icon and is telling the user that they are over the autofill handle. When this thinner black cross is on the screen the user can click and drag, or double click to utilize autofill.
Number (3)means the user has entered edit mode and can change the contents of the cell.
Drew Hamilton
Applications instructor
ahamilton@nhlearnninggroup.com
"If all else fails, try Ctrl+Z."