and choose Transpose under the Paste Special options. In large datasets, it's common to lose sight of column or row headers as you scroll. Excel's freeze pane feature helps by allowing you to lock ...