Paste Special is one of the most useful editing tools in Excel. It allows you to paste information into cells using specific criteria or commands.  Using the “Transpose” command, you can move data from columns to rows, and vice versa, with the click of a few buttons.