Great video! That search and replace feature is something I've never thought of doing before! For me, I like merging cells at the top and creating a big cell for a title or description, as well as setting the header row to a different color, typically one that's a darker variant of the color I used in the alternating rows.
Nice video! With very long description fields I made a small script that basically copies each description cell in a note placed in another cell in the same row. In this way anybody can read full descriptions just holding the pointer over that cell.
I knew many things you did in this video. Also that formating for poisitve , negative & zero numbers was new for me , check box methods were also pretty good. Nice content for beginner. You are doing great work sirji. keep doing it. I appreciate your work
Very nice video. Everything in a single video. Regular expressions in find and replace, data validation, border styles, conditional formatting all in a single video and very nicely explained. Thankyou
This is a really cool video ! I learnt a things or to ! (especially with the number formatting). Next time, you should present the line conditional formating depending on only one cell in the spreadsheet ! :D Let's suscribe! Keep up the good work ! Thank's you
I suggest highlighting exception values, whether amounts, times or True/False values for action. So the Yes/No column I would select blank for the most common value (No) and focus attention on the presence of a Yes value to alert a reader and generate a response.
Nice video! I would love to watch something related with statistics and charts (as usual the perfect speed set for your video is 1.25x). You've been making a nice work sharing all that knowledge.
Nice video, thanks. May I know what tool did you use to create the cover page of this Video? The color of the Font with gradient color, and Google sheet on its background, how did u make it?
Can you do a tutorial about embedding google sheets on a site and what we can do with it? Can there be a search function if embedded? Can the sheet be shared without knowing who to invite to view while also staying a private sheet? Etc
@@ExcelGoogleSheets I am currently building a family tree google site and would like to incorporate Google Tables as a relational database to record, edit and and display family members and relationships through the Tables forms and workspaces. I am currently using sheets to accept the data with Forms then use App script to create a Doc for that persons data for each entry. This is just a family project not a commercial site so cost is a factor. Being Tables is relational and Workspaces can be made to be user friendly I was hoping that it could be utilized in sites as a replacement or used with sheets. This looks like it could eventually become an online replacement for Microsoft Access which I use extensively on the desktop but cannot use online.
Is there a way to freeze the data dynamically once it is entered in the cell by a colleague in sheets? It can be done in excel but I haven't been able to do it in sheets
I'd very much like to know that. Maybe with a script... haven't looked into it yet, but I'll definitely need it down the line, so let's see if someone already knows :)
@@ivane.garcia7292 The sheets or ranges can be protected, but my concern is that I work in a collaborative environment in which 2-3 people work parallel to each other. So if one enters some data in the cell it should automatically freeze that cell so that it cannot be changed by anyone except the admin.
Always remember to repent of your sins (sin is transgression of YAHUAH’S LAW: Genesis, Exodus, Leviticus, Numbers, & Deuteronomy) And Have Belief On YAHUSHA HAMASHYACH. HE Died and Rose three days later so that you can be forgiven of your sins! HE Loves you! Come to HIM!🙂🙂