3w1h Format In Excel Link May 2026

=HYPERLINK("#" & A2 & "_Details!A1", "Details")

| A | B | C | D | E | F | |---|---|---|---|---|---| | ID | What | Why | Who | How | Status | 3w1h format in excel link

Back in your main 3W1H table, select cell E2 (How for TASK-001). Right-click → (or Ctrl + K ) → Place in This Document → Type How_Details!A1 . Now anyone can click the How cell to see the full method. =HYPERLINK("#" & A2 & "_Details

=HYPERLINK("mailto:john.doe@company.com?subject=Task-001 Update","John (Email)") =HYPERLINK("#" & A2 & "_Details!A1"