The fastest way to create FMEA in Excel

FMEA Excel Quick Tips - Light

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. TreeTABLE comes into play and introduces the fastest way to create professional FMEA right inside Excel. This instruction shows you how it can help you create FMEA in Excel quickly.

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 with by merging cells in other columns.
  • With TreeTABLE: TreeTABLE provides a rapid way to insert new item FMEA in Excel. Just select the current item and press Enter.

#1 FMEA Creator for Excel

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 TreeTABLE Add-in: TreeTABLE 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.
  • TreeTABLE Way: Turn Auto Fit in TreeTABLE ribbon, and TreeTABLE will automatically change row height to make the cell content fit.

2. Quickly create Formula of RPN in Excel

Creating the 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 fomulas one by one since formulas of RPN items are different.
  • With TreeTABLE: You also have to enter the formula for the first one, then click Copy Formula. It will implement RPN formula for all below RPN items.

Easy to edit FMEA right inside Excel

Like? Share it with your friends


The Best FMEA Software for Excel

TreeTABLE Free for 15 days trial of all major features