Tips for using heart-to-heart talk record sheet
Heart-to-heart talk record sheetPreparation of:
① Design an interview outline.
②. Ask questions appropriately.
③Accurately capture information and collect relevant data in a timely manner.
④Respond appropriately.
⑤ Make timely records of interviews, usually audio or video recording.
General tips for heart-to-heart talk record sheets
1: Forced line breaks within cells
By pressing alt+Enter after a certain character in a cell, you can force the cursor to the next line.
2: Automatic line wrapping
After typing the text in the cell, find the "Automatically wrap" button on the toolbar and you can freely switch the text between wrapping and not wrapping.
3: Hide the chapter list
Select the first line, hold down [shift+F] to open the "Find and Replace" dialog box, "Remarks to find all, hold down shift+A to select all, then close the dialog box, hold down [ctri+0] to hide
4: Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, select "First Row", after the settings are completed, open the name box in the upper left corner, click the corresponding list to jump to the specified column.
Two-column name verification
If you want to check whether the name in Table 2 appears in Table 1, a formula can be used to do it immediately.
=IF(COUNTIF(A:A,C2),"Yes","No")
Recommended by the editor of Huajun Software Park
The heart-to-heart record sheet is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the heart-to-heart record sheet, download it quickly.Material purchase request form,Software product quotationIt is also a good software. Welcome to click to download and experience it!





















Useful
Useful
Useful