![]() The use of this function is a little tricky and requires knowing more than pressing TAB so follow the steps closely. Yes there is a function that can do the somersault called TRANSPOSE. Told ya! it is easy! Method 2: TRANSPOSE Function to switch columns to rows or vice versa This will open the paste special dialogue from which check the transpose checkbox and click OK button under paste sub-group click transpose button that comes with this icon OR.And go to Home tab > clip board group > click the drop down button just under paste button > select: Step 2: Go to the cell where you want the data to paste. Step 1: Select the data that you want to transpose and copy it using the copy button or with Ctrl+C shortcut. flipping columns to rows or rows to columns. In Excel you can copy a data and then using paste special functionality you can twist, rotate, manipulate, process and do other things with the data very easily including Transpose i.e. With Paste Special it really went miles ahead. Method 1: Convert columns to rows using Paste SpecialĬopying and Pasting is one great thing happened to PC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |