12 Excel Copy Paste Hacks - I Bet You Don't Know All!

00:00 Intro 00:29 Copy Paste Basics 01:32 Click and Drag 04:33 New Paste Values Shortcut 06:32 Paste Special Options 14:07 Paste Special Operations 15:44 Copy and Paste as a Dynamic Picture 19:50 Copy and Paste from Clipboard 23:22 Copy Formula Without Changing Cell References 25:00 Copy from the Cell Above 26:18 Copy Paste Non-Adjacent Cells 26:50 Make a Copy of Worksheet 27:57 Wiggle Trick 30:27 Copy Pasting in Pivot Tables 32:26 Copy and Paste Formatting in Charts

1- If we double clicks CRTL+C when we are working in excel workbook, it will open clipboard and we can use this copied values or functions whenever we want to use. Also, you can find this property if you open clipboard pane and select property section which is located at the left bottom side of the pane.

2- If you want to copy unhidden rows or columns, select the whole range and copy and then click ALT+SHFT+; then you'll find that just visible cells will be copied and you can paste them whichever you want places.