USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following dialog boxes is used to transpose rows and columns?
|
|
Page Setup
|
|
|
Paste Special
|
|
|
Column Width
|
|
|
Row Height
|
Explanation:
Detailed explanation-1: -Hold down the Ctrl+Alt+V keys (Command+Ctrl+V on the Mac) to invoke the Paste Special dialogue box again. Check the Transpose option and click OK. This will convert the columns to rows.
Detailed explanation-2: -To use the paste special function, select the cells you want to convert, then click on the “Home” tab and select “Paste Special.” In the paste special dialog box, select “Transpose” and click “OK.” Your data will be instantly converted from rows to columns (or vice versa).
There is 1 question to complete.