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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!