Home  >  Article  >  Topics  >  How to swap horizontal and vertical coordinates in excel

How to swap horizontal and vertical coordinates in excel

尚
Original
2019-06-12 15:59:5438763browse

How to swap horizontal and vertical coordinates in excel

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.

How to swap horizontal and vertical coordinates in excel

#2. In the pop-up dialog box, check "Transpose (E)" and click "OK".

How to swap horizontal and vertical coordinates in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:where to save excel asNext article:where to save excel as