So very shortly, I want a shortcut equivalent to dragging the little handle in the right-bottom in a cell-selection portion in Excel 2013 (for Windows).
There is many similar questions on the site, but either the questions or their answers are non-relevant for me and my needs, so I am going to give you specific details here of what I want to do and my constraints.
- I want a keyboard SHORTcut (the answer "ALT+H+F+I+S+ENTER" is superfluous since it is a menu-mnemonic path and not a shortcut)
- I want to AUTO-fill (the fill-down/right shortcuts "CTRL+D" and "CTRL+R" are not relevant since it just copies values. I am searching something like this, but the action being "autofill", not "fill")
- I don't want to duplicate formulas, don't propose to make formulas instead of using absolute values, I want to auto fill series (numbers/dates etc...)
Since I didn't find anything during my research I suspect there is no way of doing so, but are there any way to solve this with "custom-shortcuts" or macros (which I have no experience of)?