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
drive.google.com/file/d/1qrIG...
\ Previous video: • A Drop of Excel - 09 |...
/ Understanding of the data being used in the examples: • A Drop of Excel | Unde...
Related Videos/Posts
- How to delete all blank rows in between data -- • How to remove blank ro...
- 18 Most Useful Excel shortcuts -- • 18 Most Useful Excel S...