. 2018 May 7;11(4):504–516. doi: 10.1007/s40617-018-0259-3

Table 2.

Instructions for adding dropdown menus to the data collection table

Instruction	Description	Explanation	Alterations
1. Create a dropdown list with labels to indicate if the target behavior occurred.	(a) Select cell C2 and open the DATA tab (at the top of the screen). (b) Select the DATA VALIDATION Icon (it has a green check mark and red circle with a line on two rectangles). (c) In the DATA VALIDATION menu, open the dropdown menu under ALLOW and select LIST. (d) Click onto the SOURCE Cell that appears under the menu and type “Yes, No”. i. Select OKAY at the bottom of the menu.	Any dropdown list can be made by entering labels in the format of “option1, option2, option3…”. A second option for creating a dropdown list would be to enter the options in a column of cells in a spreadsheet, selecting the SOURCE cell in the DATA VALIDATION menu, and highlighting the range of cells that contain the desired options.	“Yes” and “No” can be substituted with any other appropriate data labels including specific numbers for frequency data collection or other labels such as partially prompted and independent. For a frequency system, you would enter the numbers to indicate the amount the behavior occurred (i.e., “1, 2, 3, 4, 5, 6, 7, 8”).
2. Copy the dropdown menu into other cells.	(a) Drag cell C2 by clicking the bottom-right corner of cell C2 (the little green square). Your mouse should turn into a (+) sign. i. Drag down to cell C7 (this should highlight cells C2:C7). 1. While C2:C7 is still highlighted, drag to cell F7 (this should highlight C2:F7).	Dragging is the most efficient way to “copy and paste” formulas and formatting, but traditional copy and paste methods could be used instead.	This can be done for any number of rows and columns.

Instruction

Description

Explanation

Alterations

1. Create a dropdown list with labels to indicate if the target behavior occurred.

(a) Select cell C2 and open the DATA tab (at the top of the screen).

(b) Select the DATA VALIDATION Icon (it has a green check mark and red circle with a line on two rectangles).

(d) Click onto the SOURCE Cell that appears under the menu and type “Yes, No”.

i. Select OKAY at the bottom of the menu.

Any dropdown list can be made by entering labels in the format of “option1, option2, option3…”. A second option for creating a dropdown list would be to enter the options in a column of cells in a spreadsheet, selecting the SOURCE cell in the DATA VALIDATION menu, and highlighting the range of cells that contain the desired options.

“Yes” and “No” can be substituted with any other appropriate data labels including specific numbers for frequency data collection or other labels such as partially prompted and independent. For a frequency system, you would enter the numbers to indicate the amount the behavior occurred (i.e., “1, 2, 3, 4, 5, 6, 7, 8”).

2. Copy the dropdown menu into other cells.

(a) Drag cell C2 by clicking the bottom-right corner of cell C2 (the little green square). Your mouse should turn into a (+) sign.

i. Drag down to cell C7 (this should highlight cells C2:C7).

1. While C2:C7 is still highlighted, drag to cell F7 (this should highlight C2:F7).

Dragging is the most efficient way to “copy and paste” formulas and formatting, but traditional copy and paste methods could be used instead.

This can be done for any number of rows and columns.