How to change the header in excel spreadsheet?

1, we first open an excel form on the computer, and then enter a simple form with horizontal and vertical headers. For demonstration, only three lines of code are needed.

2. We need to select the horizontal header together, and then right-click to copy it, or directly use the shortcut key "ctrl+c" to copy the header.

3. Then, we need to select three vertical tables behind the corresponding vertical rows in the table, and then click the "Paste" button in the upper left corner or the right, and then select "Paste Special" among them.

4. After clicking Paste Special, the options dialog box for Paste Special will appear. We will see a "transpose" function on the right side of the dialog box.

5. We need to tick the "transpose" function, and then click the "OK" button below.

6. After clicking the "OK" button, we will see that the contents of the horizontal header have appeared in the three vertical tables we just selected, even if there are more, the practice is the same.

7. Next, we transpose the original vertical header into a horizontal header in the same way, so that our operation is completed.