Copy with or without formatting, paste values, transpose, and what a paste carries. Copy, cut and paste with control over what travels: WITH FORMATTING (values, formulas and styles) or VALUES ONLY, plus PASTE AND TRANSPOSE (Ctrl+Shift+T) which flips rows and columns. A multi-cell clipboard payload from outside the app (tab-separated text) is distributed across cells rather than dumped into one, even when a cell is in edit mode. Cut clears both values and styles by default; the values-only variant leaves formatting behind.
This site needs JavaScript for the full experience. Every page above is reachable without it.