Is there a way to autofill cells in Excel 2013 with keyboard shortcuts?
This sounds like a job for the Quick Access Toolbar or QAT.
Use the pull-down on the QAT (shown above) and choose More Commands. When you get to Excel Options ► Quick Access Toolbar you can pick Fill Series
from the Home Tab group and add it to the QAT.
Use the positioning arrow buttons to set the commands position before committing the command addition with OK
. This is important as its position will also set the keyboard shortcut. The first is Alt+1
, the second is Alt+2
, etc.
With that in place, you just have to tap Alt+<whatever>
to get your Home ► Editing ► Fill ► Series command. It looks like you might need to hit Enter
to accept the Series dialog's suggested method of AutoFill
, but that is simply because there are usually choices.
FWIW, my own command demon has always been Home ► Clipboard ► Paste ► Paste Special ► Values. I have set the Paste Values
in my QAT at position 2. Now I can simply Ctrl+C
then Alt+2
to copy and paste special, values. I also usually remove Save
, Undo
and Redo
to make room for other custom QAT commands as I can remember Ctrl+S
, Ctrl+Z
and Ctrl+Y
.
More on the QAT at: Customize the Quick Access Toolbar
On a related note, double-clicking the Fill Handle of a cell with a formula is the equivalent of Fill Down
according the the number of populated cells to the left. I habitually use Ctrl+D
but if my hand is already on the mouse, this is an alternative. Experiment with this little-known/used trick and you might want to add it to your repertoire.
Related videos on Youtube
MahNas92
Updated on September 18, 2022Comments
-
MahNas92 over 1 year
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)?
-
RobH over 9 yearsActually, the fill down/right/up/left commands also copy formatting. (I know that from experience using them.) If what you're copying refers to other cells, the new cell will contain references to cells below/to the right/above/to the left of the originally referenced cells the same distance away as the destination cell of the fill is from the source cell.
-
Hannu over 9 yearsgoogle.se/… - brings up hits that might help get on the way with VBA/Macros - but I doubt that you will be able to achieve something similar to the use of the fill handle.
-
phuclv about 5 yearsFill a large range with a formula in Excel, without mouse-dragging to extend, Possible to apply a function to an entire column?, Apply Formula to a Range of Cells without Drag and Drop, How to make Excel 2010 auto-fill new row with formulas?, Excel Auto-Fill a Series Without Mouse, AutoFill Large Number of Cells in Excel?
-
MahNas92 over 9 yearsThis is actually a solution I haven't thought about or seen before that I will consider, though I will wait to mark this as the answer to my question since it feels like there should be a smiple/obvious keyboard shortcut equivalent to dragging the bottom-right handle in a cell-selection.
-
Prasanna over 9 yearsNice explanation +1
-
MahNas92 over 9 yearsI forgot to update, but this was an excellent neat solution that I now use, thanks!