excel shortcut keys for paste special values

Once you copy data and press ALT + E + S, various paste special options appear. Paste Special offers you a wide range of options Paste Special is the gateway for many powerful operations, including paste values, which is most commonly used daily. When you copy data from one cell and try to paste in another cell, various paste options appear under paste special if you select it. The format means it can be background color, font color, borders. The attribute of a cell is the formatting, which can be decimal places or preceding dollar signs and in applying cell styles. In Excel, you have an excel paste special option of pasting only a certain attribute such as value, format, formula & comment. You can paste any type of data Data may be numbers or texts or special characters.

Again, under the paste options, you can observe various types of paste parameters. In the HOME menu toolbar of excel, you can see the Clipboard group of commands which contains copy & paste options. Excel functions, formula, charts, formatting creating excel dashboard & others

Excel shortcut keys for paste special values