Video: FMEA Magic - Repeat Data and Error-Checking

FMEA Template Training

Topics in this Video

• Overview — 0:00

  FMEA - Repeat Data and Error-Checking

  Primary training page for FMEA template

• Filter and Pivot Tables — 0:00

  Cells that look like blank or merged cells - aren't

  thereby enablilng Excel Filter and Pivot Table features

• How? — 2:10

  1) Scroll down below Print Area to find help for which columns do and do not require Repeat Data

  2) For columns that need Repeat Data, Copy the top row of a section, and simply Paste to all other rows in that column for that section. (and notice how the cells get automatically formatted to look to a human eye or a printer like they are merged cells — but they're not

  Use the button to 'Fix Row Heights'

• Error-Checking — 6:00

  In the Function column, if the background color turns pink, then 1 of 2 things is wrong