Adding a row while still keeping the formula and merge settings

[apar93]

This may or may not be a simple question. But how do I add a row (with assigned formulas) so that the formulas are automatically applied to the new cells, without having to drag the cell down myself.

Also how can I make the new row copy the other row's merge settings?

Thanks in advance.

 

[Little_Clubber]

Right-Click the row and then click on Copy, then Right click the row number of where you want the data and left click on Insert Copied Cells.

 

[apar93]

Thank you for the tip Little_Clubber. Do you know if there's a shortcut for that, for someone who might not be excel savvy?

 

[Little_Clubber]

I'm afraid I don't know of a short-cut for that. It is only 4 mouse-clicks after all...

 

[apar93]

You are absolutely right. But I'm sending a sheet out to all the employees and some might just not get it...
I guess they'll just have to. Thanks