9/27/2023 0 Comments Vice versa vs.visa versa![]() If your data includes formulas, Excel automatically updates them to match the new placement. ![]() ![]() ![]() Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. The new table that you paste there will entirely overwrite any data / formatting that’s already there. Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.Ĭhoose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |