Saved Bookmarks
| 1. |
Solve : Turn off spreadsheet auto-transpose? |
|
Answer» I use OPEN Office spreadsheet. When I copy and paste a FORMULA from one cell to another, it automatically transposes the cell data, like from B4 to C4, or B4 to B5. Most of the time, this is great. Once in a while, it's really annoying. How do I turn it off when I WANT to?You need to use the "Paste Special" and check or uncheck Transpose as seen in screenshot. When you right-click to get the menu Paste Special is at the bottom of LIST. |
|