Follow these steps to create a simple and effective test case template in Excel: Step 1: Create Headers For The Columns. ... Step 2: Create Rows For Each Test Case ID. ... Step 3: Document The Results in The Test Case Row. ... Test Case ID. ... Test Case Description. ... Test Steps. ... Expected Results. ... Actual Results. More items...