Sometimes we need to copy a cell or range of cells to some other cells or range of cells along with formatting, along with formulas etc… Also, we need to copy & paste only values without bringing anything else along with it. Sometimes in Excel, you need to perform some very real quick things. read more we can press ALT + E + S + V for values only. "Alt + E + S + V" is the shortcut key for pasting values. Paste special in excel means when we want to paste only some aspects of the data rather than the original data we use this option, there are various methods to paste special in excel and they are by right click on the target cell and select paste special or by keyboard shortcut as CTRL + ALT + V or we can press ALT + E + S, to use the aspects we can use the Excel shorcut of paste values Use The Excel Shorcut Of Paste Values Pasting values is a common procedure that allows us to eliminate any formatting and formulas from the copied cell and paste them into the pasted cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |