This issue has me flabbergasted. Here’s the problem. My mouse is broken (yeah I know they’re cheap but I’m trying to get this done quickly) so I’m trying to extend a series by highlighting a group of cells and then clicking on the bottom right corner of the highlighting box and it drag down. When I do this, Excel automatically extend the contents but doesn’t do it very well. Is there a keyboard function that will allow me to do this manually?
I can use the shift key and arrow keys to make a selection, but I don't know what (if any) key can trigger this function.