Copy And Paste in Excel

Trick No. 1

The following data want to be transpose and make it horizontally.

First Transpose the Name, product and sales line for this select and copy then press Ctrl + Alt + V or Alt + E + S and select transpose and click OK.

Then write any two alphabet and give a space and =the cell name means where the data will locate in our case B1 then drag to right then write B4 for automatically fill all the field