-1

I'm working with formulas summarizing table columns (e.g. SUM(Table1[Column1]) and I would like to fill the formula to the right using only the keyboard.

When I autofill my range by mouse drag, it works fine ([Column1] => [Column2] is automatically updated), however I can't find a way to make it working with keyboard, it always manage my references as absolute ones.

I've tried all the answers to this question: Excel Auto-Fill a Series Without Mouse (Keyboard Only) (Alt + H F I R; Ctrl+R; Ctrl+C & Ctrl+V), they work well formulas with standard cell references, but none of them works for me.

Of course my formulas are more complex then the example posted above, and also for other reasons it's not an option to change from table references to standard ones.

Is there any other trick I could try?

(I know it probably can be done in VBA and then adding the macro to Quick Access Toolbar, or create a shortcut to it, but now I'm not interested in it, as my toolbar is already too crowded).

Community
  • 1
Máté Juhász
  • 21,403
  • 6
  • 54
  • 73

1 Answers1

1

Try the following:

(-> indicates you don't hold the previous button. + means you do)

Firstly, select the first cell with your formula, then hold Shift and tap Right Arrow to the last column you want the formula in.

Then:

Alt -> H -> F -> I -> S -> Alt + F -> Enter

enter image description here

enter image description here

Jonno
  • 21,049
  • 4
  • 61
  • 70