Have you ever felt the need to work on multiple cells simultaneously?
On my excel sheet, sometimes I need to implement the same formula on various cells. For this I have to put the formula in one cell, then copy them to the other cells. This is very time consuming.
For example in my road model, I have to implement the same formula over various financial years. For this I have to keep copying the same formula into every cell.
Is there any way to do this quicker and more effectively? Yes Use Multiple Fill!
I have a shortcut which implements the formula in every selected cell.That shortcut is the multiple fill shortcut. I can use the shortcut after selecting the cells to fill.
⌃ + Return is the shortcut for multiple fill.
How is it useful to me ?
It saves me the time and energy of filling cells repeatedly!