ADVANCED COPY AND PASTE IN EXCEL
Copy and Paste is one of the simple tool use in Excel but today we will be learning one of the rarely used Copy and Paste Special tool. Do you have a data in Vertical orientation that you want to copy and paste in Horizontal orientation or the vice versa then follow this tutorial to get the work done. 1. Highlight the cells and copy. (Shortcut for copy is Ctrl+C) 2. Select the cell you want to start the paste, click on the paste button and select PASTE SPECIAL. 4. Tick the TRANSPOSE and Click OK. You can also watch the video tutorial here. In my next tutorial we will be learning how to link Excel to Power Point for presentation. Anytime the Excel is updated it automatically update on the Power Point. Subscribe to receive first hand information and leave your comments. Thanks.