Many other options like tab color is there to change the color of the tab. In the video above I share 5 keyboard shortcuts (plus a bonus) to paste values. As I mentioned before, the most common we use is Paste Values. There are keyboard shortcuts for all of the Paste Special commands.
WHAT ARE THE DIFFERENT PASTE OPTIONS IN EXCEL 2016 FULL
Similarly we can do this with our different sheets, we can rename them, delete them, by just right clicking them. The Paste Special button on those menus opens the full Paste Special Menu. We can select as per our requirement and it will be done. If we highlight any four cells and right click on that and select Insert option we will be asked to choose that where do we want to shift that cells, to the right, down or change entire row or column. Similarly if you want to delete that row which we inserted we can do it with the help of delete option. If you are copying something from outside excel, it will give you some different options for paste special, but Alt, E, S will get you there.
This works well for anything copied from excel. In MS Excel we have different kind of tabs and different options, which sometimes create question in our mind that which option do we need to use for our required task.įor example if we want to insert a row between two rows than we will right click on that cell and see mini toolbar there, where we will select Insert option, and a row will appear as we needed. Alt, E, S will open the paste special dialog box, V will select Values and then Enter will make it happen.