Through to paste special we have three categories including the current options Use Paste Special to Use Advanced Copy Paste # Now here I am selecting the position then right clicking and go to paste special. Now go to the home tab and on clipboard commands, you have the paste option and at first, select the position and paste your file there. Or right-click on other place and click paste or paste special. You can directly move your mouse on other mouse and click enter to paste the table into another place. When you copied the table you to paste the table or text to another place you have the current options At first, select them and right click then copy them. The most important point is this that, here our information is in horizontal and vertical cells.

Here I made a table of selling date palm in four cities, here we are comparing the selling of date palm in three years.

Now make a table of information about anything in your Excel worksheet. Then copy from outside and paste it into your worksheet. To do the special paste in Excel worksheets first you need to do the copy from inside of the worksheet. Use Advanced Copy Paste Options in Excel Worksheets #

Copy paste list into excel