61
23
So when I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then attempt to automatically extend the contents as well as it can. Is there a keyboard function that will allow me to do this? I like to use the keyboard to avoid repetitive mouse motions.
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.
I also don't really know what this function is actually called.
1If anyone finds a shorter (non-macro way) / "the official shortcut" to do this for linear series please let us know! – nutty about natty – 2018-08-22T13:10:39.097
1Nice, this works well. The AutoFill option (Alt-F) seems to work well for most of my past use cases. Using Trend and Growth also allows me to do multiplicative series. Very cool! Sort of a lot of keys to press, but I guess that's what I asked for. – jtpereyda – 2011-04-13T15:18:43.133
3Mnemonics help ... Home FIll Series (Enter). Thanks for this! – Scott Rippey – 2011-12-19T17:44:19.743