USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which dialog box 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: -In the Paste Special dialog box, select Transpose and click OK.
Detailed explanation-3: -When you copy text that has different formatting into an Office program, the program, such as PowerPoint or Word, automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or paste it as a link or a picture, for example.
There is 1 question to complete.