DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Page Setup
|
|
|
Paste Special
|
|
|
Column Width
|
|
|
Row Height
|
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: -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-4: -Technical details. The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa. The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows.