USING MICROSOFT EXCEL
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: -In the Paste Special dialog box, select Transpose and click OK. Copy paste this newly created transposed data to the one from which it is created.
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: -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.
Detailed explanation-4: -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.