copying formulas and conditional formating when adding new row or column

[aljoman]

Hi all,

I am preparing a risk report template (risk analysis) and I ran on a problem.

My table looks like that:

|Risk ID| Description| Probability [%] | Severity [EUR] | Severity [md] | Impact [EUR] | Rank |

where:

Risk ID: is automatically calculated (I am using a formula for that)
Description: is text value
Probability: is a list (using data validation function)
Severity [EUR]: text/number value
Severity [md]: number value
Impact [EUR]: using formula where Probability is multiplied with Severity
Rank: is a conditional formatting formula - based on Impact value

I have a several risks already, and now I would like to add another row. The problem is that if I do that with "insert new row" formulas and conditional formatting is not copied to inserted new row.
Is there any simple way to add a new row where formulas and conditional formatting is automatically copied to inserted row? or column?

Thank you in advance for your help.

Aljoman

[dilipandey]

Hi Aljoman,

Welcome to the forum.

After inserting a new row to the below of you data, select the newly inserted row and press Ctrl +D

Regards,
DILIPandey

<click on below 'star' if this helps>

[aljoman]

Hi dilipandey,

tnx for your fast response.

Is there also any other option to copy all formulas and formatting.

I would like to use a document as template and want to make it as easy as possible.

If this is the only way then I will go with it.

thnx aggain.

[dilipandey]

I guess that one is a quick shortcut.... and if you want that can be triggered using vba (macros) .


Regards,
DILIPandey

<click on below 'star' if this helps>