Now, for the magic: Call up the Paste Special dialog with Ctrl+Alt+V (or command+control+V in macOS) hit E to select the Transpose option, bottom right, then Enter. Copy the selection, then select the leftmost of the cells where you would like the transposed labels to appear. You can click and drag or, if the column is very long, try this: Select the first cell in the column, hold down the shift key, and double-click on the lower border of the selected cell: Excel will extend the selection downward until it encounters an empty cell. Rather than cut and paste them one at a time to their correct position, why not flip the column of data through 90 degrees using the Paste Special/Transpose option? Start by selecting the column of labels or other data you want to transpose. You distractedly type in a whole series of labels, then realize that you meant them to go across a row, and not down a column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |