inHave you ever entered a list of headings in Excel only to find that you’ve entered them as Row headings instead of Column headings or vice versa? It’s easy to change where the headings are displayed without having to delete them all and start again.
Select the headings and copy them as normal. Position the mouse where you want the headings to appear and right click the cell. From the shortcut menu, click Paste Special and then choose Transpose.