USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Transpose
|
|
|
Transfer
|
|
|
Paste
|
|
|
Revise
|
Detailed explanation-1: -If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you rotate the data from columns to rows, or vice versa. on the Home tab, or press CONTROL+C. Note: Make sure you copy the data to do this.
Detailed explanation-2: -Now, enter the formula =TRANSPOSE(A1:F5) Don’t press Enter! You need to execute array formulas by pressing Ctrl+Shift+Enter.
Detailed explanation-3: -Right-click and select the Paste Special option. 4. Select Transpose in the popup menu. Then the horizontal data will immediately be converted to vertical.
Detailed explanation-4: -If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.