Have you ever needed to fill a section completely with the same data values or formulas?
In my excel sheet, I usually have to use the same formulas or same values over different cells in a row or column. For this I can drag the data using the mouse.
For example in my road model, I have to use the same formula over every financial year in the row. For this I can copy the formula over every cell. But this is time taking. Instead I can use a shortcut to copy formula to fill sections.
Ctrl + R for copy to selected sections to right
How does this help me?
I can easily fill the section now and implement formulas in the section using a single shortcut.