This method is especially useful when you have just started learning the feature.įor example, if you hover over the paste transpose icon, you will see a preview of how exactly the copied data will be transposed: A hit will pop up and Live Preview will take over enabling you to see the paste effect straight away. To find out what a particular icon does, hover over it. If you start hovering over the Paste Special… item in the context menu, a fly-out menu will show up offering 14 more paste options: Paste Special command in the right-click menuĪlternatively, you can right-click a cell where you want to paste the copied data, and then click Paste Special in the context menu.Īs you may have noticed, 6 most popular paste options appear directly in the pop-up menu, under Paste Options: paste everything (equivalent of CTRL + V), paste values, paste formulas, transpose, paste formatting, and paste link: The most obvious way to open the Paste Special dialog is clicking Paste > Paste Special on the Home tab, in the Clipboard group:Ģ. You can access its features via the ribbon, right-click menu and keyboard shortcuts. Usually, Microsoft Excel provides a numbers of ways to utilize the same feature, and Paste Special is no different. Yep, it's that simple! 3 ways to access Paste Special in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |