I have a relatively simple Excel task (I hope). One workbook, two sheets (Sheet1 and Sheet2) Sheet 1 has a dropdown Data Validation list that has 30 options. The user will choose an option from ...

Repeat this action with any other sheets of your Excel worksheet. You can access the various sheets (usually named "Sheet1," "Sheet2" and "Sheet3" by default) at the bottom of the workbook file.

Select the second range (Sheet2) Type = TRANSPOSE =TRANSPOSE (Sheet1!B2:H2) Confirm with CTRL + SHIFT + ENTER to obtain an array formula. Note: Only the content is copied, to the format of the ...

Start Microsoft Office Excel 2007 and open the workbook you want to edit. Select the formatted sheet by clicking its tab at the bottom of the Excel window. For example, click "Sheet1." ...