Make sure the number of cells in the new area can fit all the data in your table. Decide where you want to paste the transposed table. Since this technique makes a static copy of your original table, your transposed table will go to a new location in your workbook. Choose a location for the transposed table Copy the table using the Ctrl + C shortcut or by right-clicking on the table and selecting “Copy.” 3. Highlight all the columns and rows in the table you want to switch. For example, for the formula given above, you would add the dollar sign before the columns (A and B) and row (4), so it would read as =$A$4*$B$4. If you want your formulas to maintain the original cell reference in the transposed table, you must manually change your formulas from relative to absolute before transposing.Īdd the dollar sign ($) before the column and row data in the formula to make the cell reference absolute. If you want the formulas to adjust, leave them as they are. For example, if you copy and paste the formula =A4*B4 from cell C4 to C5, the formula will adjust to =A5*B5. When transposing your table, Excel automatically updates the formulas to match the new placement, as most formulas contain relative references. Follow these steps to switch your column and row data. This method creates a static copy of your table in a new orientation, that way your changes to the transposed table will not alter the original. If you want to rearrange your column data to rows or vice versa, you can use the transpose feature in Excel to switch your data automatically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |