How to Use the Paste Special Command in Excel. Part of the series: Microsoft Excel, SQL & Internet Tips. In Microsoft Excel, the paste special command allows the user to choose what features of a cell they want to paste. Copy and paste a value without pasting the formatting with tips from a software developer in this free video on using Microsoft Excel.