I just got to this video today. Who knew F&R could do so much? (I didn't!). Another helpful and well-explained tutorial instruction--and much appreciated.
00:00 - Introduction 00:31 - Fix date structures 01:40 - Replace values in an entire workbook 03:09 - Apply formatting to cells with specific values 04:29 - Find & Replace number formatting 06:27 - Remove rows with specific values 08:40 - Remove every Nth row 10:15 - Bonus: Remove asterisks in a cell
If I have an article or a long text of 30 lines in a cell and I want to show 10 lines in the cell and the other rest 20 lines show by a scroll bar. how can I create a scroll bar in a cell if the cell has a long text?
Grab a copy of Advanced Excel Success and learn more advanced Excel tricks amzn.to/3nt5nqT
I just got to this video today. Who knew F&R could do so much? (I didn't!). Another helpful and well-explained tutorial instruction--and much appreciated.
Glad it was helpful! Thank you for your comments.
I have been using Excel since 1993 (ver.5) & still learning useful hints. Thanks for video.
Excellent! Thank you. I'm always learning too.
A very complete tutorial. Thank you Alan!!
Thank you very much Iván
I really found this feature is good and useful and I mostly use it in my work
Great! It is often overlooked. Thank you Akram.
Good job as always, you inspire me in the creation of spreadsheets for gambling. Keep doing the good job
Thanks, will do my best.
00:00 - Introduction
00:31 - Fix date structures
01:40 - Replace values in an entire workbook
03:09 - Apply formatting to cells with specific values
04:29 - Find & Replace number formatting
06:27 - Remove rows with specific values
08:40 - Remove every Nth row
10:15 - Bonus: Remove asterisks in a cell
Awesome video from Computergaga.
Thank you, Michal 😊
Thanks for the helpful video. Cheers.
You're very welcome Chris. Thanks!!
Thanks Alan. Informative video.
No problem. Thank you very much.
Nice! Thanks Alan!!
Thanks Wayne
If I have an article or a long text of 30 lines in a cell and I want to show 10 lines in the cell and the other rest 20 lines show by a scroll bar.
how can I create a scroll bar in a cell if the cell has a long text?
I'm not sure this is possible for a single cell