Man on the rocket

The fastest way to create FMEA in Excel


Excel is easy to use but not specialized for FMEA, you have to spend time trying to work-around with Excel’s alternative functions. FMEA Analysis comes into play and introduces the fastest way to create professional FMEA right inside Excel.
This instruction shows you how to create FMEA in Excel quickly with FMEA Analysis

1. Quickly Edit FMEA in Excel

1.1. Quickly Insert New Item

In the below FMEA, there are 1 or many Potential Failure Mode for each Requirement. Potential Failure Modes should be separated from each other but still aligned with their common Requirement.

Excel worksheet is a flat table. One Potential Failure Mode corresponds with one Requirement. How do you add one new item in Potential Failure Mode but still keep it align with the current item of Requirements?

  • With Excel: insert a new row below the current one for the new item, but this action also creates new items that we don’t need. To fix this problem, you may work around by merging cells in other columns.
  • With FMEA Analysis: FMEA Analysis provides a rapid way to insert new item FMEA in Excel. Just select the current item and press Enter.

# 1 FMEA Tool for Excel

Save hours of work

1.2. Quickly Delete Item

If we want to remove an item in Causes column without effect to other content, deleting its row is not a suitable solution because it may delete other items. What should you do?

  • With Excel: Unmerge some items, delete the unnecessary item, and then merge again. This method requires a lot of tasks.
  • With FMEA Analysis Add-in: FMEA Analysis provides a quick way to delete. Press the Delete button or right-click and select Delete Item.

1.3. Fit & AutoFit

Excel does not allow autofit for merged cell. In the example FMEA below, if you add more text for the pink item, its row height does not shrink to fit addintional text.

Fit and Auto Fit content of FMEA in Excel
  • Excel Way: you have to resize row height to fit content manually.
  • FMEA Analysis Way: Turn Auto Fit in FMEA Analysis ribbon, and FMEA Analysis will automatically change row height to make the cell content fit.

2. Quickly create Formula of RPN in Excel

Creating the formula for one RPN is simple, but it isn’t easy to create formulas for all RPN cells of FMEA in Excel quickly. So how should you do it?

Excel Quicl Formula Copying
  • With Excel: You have to create RPN formulas one by one since formulas of RPN items are different.
  • With FMEA Analysis: You also have to enter the formula for the first one, then click Copy Formula. It will implement an RPN formula for all below RPN items.

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

More To Explore



DFMEA stands for Design Failure Mode and Effects Analysis and PFMEA stands for Process Failure Mode and Effects Analysis. They are both FMEA, use the

FMEA Automation Tool for Excel
Use FMEA Analysis tool to save hours of work

Download FMEA Analysis

And get the lastest news and supporting articles

An email with download link and installation instruction will be send to your email address in a minute.