In principle, factorial designs can include any number of independent variables with any number of levels. For example, an experiment could include the type of psychotherapy (cognitive vs. behavioral), the length of the psychotherapy (2 weeks vs. 2 months), and the sex of the psychotherapist (female vs. male).
Delete rows or columns in a table. Select one or more table rows or table columns that you want to delete. Tip You can also just select one or more cells in the table rows or table columns that you want to delete.On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Table Rows or Delete Table Columns.ip If you select a cell or range in the last column, you can also insert a column to the left or to the right of that column. On the Home tab, in the Cells group, click the arrow next to Insert. Do one of the following: To insert table rows, click Insert Table Rows Above.
Format blank cells in a Pivot table to make it more attractive. Click on your pivot table report. The Options and Design tab should appear in your menu options at the top of the page. Click Options in the PivotTable group and select Options from the drop-down list. Select the Layout & Format tab. Click the box next to For empty cells show, and enter the value you would rather have shown than the word blank.. Clicking the box and leaving the value field empty will display a blank cell. You can display a 0 by leaving the box unchecked. Click on your Pivot table.