You can swap the horizontal and vertical coordinates in the table by copying the data that needs to be swapped horizontally and vertically, and when pasting, check "Transpose" in "Paste Special" " option to realize the interchange of horizontal and vertical coordinates.
The operation steps are as follows:
1. Copy the data that needs to be swapped horizontally and vertically, then enter the "Edit" menu, click "Paste Special", and a pop-up will appear. dialog box.
#2. In the pop-up dialog box, check "Transpose (E)" and click "OK".
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of How to swap horizontal and vertical coordinates in excel. For more information, please follow other related articles on the PHP Chinese website!