This is very useful when you created a form and would like to replicate some of the cells to another area. Love copy those input validations you have created but not the cell contents or anything, just press ALT+E S N. You can achieve the same effect by dragging the formula cell to new range if the new range is adjacent. Just copy the cells containing the formulas, hit ALT+E S F. If you want to copy a bunch of formulas to a new range of cells – this is very useful. Like that sleek table format your colleague has made? But don’t have the time to redo it yourself, worry not, you can paste formatting (including any conditional formats) from any copied cells to new cells, just hit ALT+E S T.
Very useful when you want to strip away existing formatting and work with plain data. If you want to just paste the values from copied cells, just hit ATL+E followed by S and V. Pressing right mouse button > Paste Specialīasic Copy Pasting of Data thru Excel Paste Special.
But how well do you know “Paste”?, do you know that there are many variations to paste data to your excel sheets? Surprised? Well, read this post to become a master paster 🙂Īfter copying your data, You can activate Paste Special by Paste or Ctrl+v is probably the most effective productivity tool available to us.
