DATABASE FUNDAMENTALS
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: -In the Paste Special dialog box, select Transpose and click OK.
Detailed explanation-2: -Here’s how: Select the table that you want to transpose, and press Ctrl + C to copy it. Select the upper-left cell of the range where you want to paste the transposed data. Press the paste special transpose shortcut: Ctrl + Alt + V, then E.
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.