A Drop of Excel - 10 | Paste Special, Find & Replace, Go to Special

Описание: Let us today learn about,
Paste special
Paste with same column width as source
Paste as values
Transpose in Excel
Find & Replace
Replace in whole sheet
Replace in selected cells only
Replace with a space
Replace with a blank
Go To Special
Blanks
Formulas

Example file link
https://drive.google.com/file/d/1qrIG...

\ Previous video:    • A Drop of Excel - 09 | Working with IF Con...  
/ Understanding of the data being used in the examples:    • A Drop of Excel | Understanding the datase...  

Related Videos/Posts
How to delete all blank rows in between data --    • How to remove blank rows in one shot in be...  
18 Most Useful Excel shortcuts --    • 18 Most Useful Excel Shortcuts