How to Design Good Looking Spreadsheets - Google Sheets

[@SergioLanzone]

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.

[@mattmorrisson9607]

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.

[@Norvys]

Great video !!! I loved these 2 topics: "custom number format" & Find and Relace with "Search with regular expressions"🙌🙌🙌

[@tanhuenyinadam9111]

Life saver for my assignment, knew a lot of hidden feature and function from your video, thanks !!

[@barmolino]

A big fan of your lessons. Actually all in spreadsheet depends on the idea all other can be done with google stack

[@jordinp2140]

Oswald is best font. Bold comes out very nicely, Font is very easy to read while also being compact. Who else has a favorite font?

[@oompalumpus699]

Georgia

[@pancux670]

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

[@kaifcorner6621]

Amazing tutorial and I appreciate this vedio to help us for Excel formating as the better way. Thank you so much sir

[@tobbygaudreau699]

Awesome work, your videos are amazing! Keep up your great work!

[@sdsa007]

thanks, great stuff: data validation, number formatting, find and replace, checkboxs, and conditional formatting are all useful for the stuff I do!

[@ExcelGoogleSheets]

Excellent!

[@sksandeepkumarreddy8048]

NICE VIDEO FOR THE EDUCATION OF EXCEL OF REAL LIFE

[@mertnuhoglu]

Great lesson video. It is so much fun to watch and learn new methods. Thank you very much.

[@marufahmed2657]

Fan of your tutorials! Please share about awesome table for Google sheets.

[@950886994]

I like you all video in google sheet tut

[@siddharthjain6629]

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

[@jamiec5981]

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

[@johnangelico667]

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.

[@walterpaiva719]

Cool video

[@luiscorado2868]

Excellent video , you never disappoint!!!

[@TonyAnschutz]

Wow! Great ideas to tune up my sheets. Thank you

[@alphabeta01]

great video

[@satyendratandan3364]

superb man

[@JohnBGood1]

You forgot the freezing columns. But, great video, as always. Thanks!

[@thansovan]

Helps alot😍

[@sapphire6442]

It was very helpful! Thank you!))

[@kennethforbin5604]

I hit the like button before going through the tutorial and I didn't regret it. Thanks. Anymore tips on Google Query and SuperSQL? We are waiting.

[@RalphNgOfficial]

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?

[@alansavage3549]

Thanks. Couple of gems in there 👍

[@iamme3685]

Thanks. I'm learning a lot.

[@ExcelGoogleSheets]

Glad to help

[@robinlioret7808]

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

[@wakabeind4907]

cool man! thanks

[@WizeChoice]

Great Video. Thank you very much

[@illmtoloko]

thank you so much for the lesson!

[@PrasadHariharan]

Nice video!

[@brittanygardner]

Thank you!

[@elliceestrada1732]

this is AMAZING!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@a_6019]

I think this video not teach me about design, is teach me how to use Excel. I love it this video

[@jordanursel2113]

Very helpful video, thanks!

[@bruno_veloso]

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.

[@TheMiningLeon]

Dang thanks i searched for that "resize collumn"

[@Polash87]

learnt a lot from this

[@nishantagarwal5165]

Please make a video on Power BI

[@66Komodo]

Cool. Thank you

[@sunnylk6991]

Great video. Thank you!

[@dgvisual7476]

I want to ask you: why did you add an initial column to the left and that rows at the beginning? Great video, thanks!

[@ivane.garcia7292]

It's for better symmetry and for making things look a bit less jammed together.

[@Mechquest01]

I actually do this too. And one more thing is you can add header to make this table easy to understand for who see it first time.

[@josemanuelherediagonzalez1542]

Yes, but don't do this if you plan to use the data in other files. It gets complicated to work with empty rows at the beginning

[@hadireg]

👍👍

[@bumpersmith]

How about doing a video on the Google Tables (Relational)

[@ExcelGoogleSheets]

I couldn't find any practical application to this with what they currently have available. Am I missing something?

[@bumpersmith]

@@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.

[@reinof_ash5221]

blog.google/technology/area-120/tables

[@sapisoftware1942]

@@ExcelGoogleSheets Hi, thanks for the eccellents videos. Could you do some video related get mails from gmail inbox to Google Sheets? regards

[@tomd8019]

@@reinof_ash5221 Thanks for the link. This looks fun. Like Airtable but Googlier.

[@tmpatklk]

Nice job. Very thorough. Do you ever use the Theme option under Format?

[@ExcelGoogleSheets]

I use it when I have Pivot Tables and Charts.

[@tmpatklk]

@@ExcelGoogleSheets Thank you!

[@cheewurz]

Sweeeeet!!!

[@MauricioHernandez87]

is there a tutorial for setting a timestamp based on a cell value. I've used function but it changes the whole sheet every time i reload.

[@mukulkhanna1135]

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

[@martin.lanfranchi]

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]

Would it work to set protection over a specific range? Once that's done, only the users you select will be able to edit that range.

[@mukulkhanna1135]

@@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.

[@ExcelGoogleSheets]

There is no normal way to do this.

[@aliphonesengmany9673]

can you pls do the attendance sheet for student with multi sheet :D

[@usmaniqbal1836]

Sr, plz share this file for practice...

[@MrArvinly]

Can anybody help me about the fill color in sheet not showing some color and most problem it not show color in the cell . Thanks

[@ExcelGoogleSheets]

Click on the cell, go Under Format-Conditional formatting and see if there are rules applied.

[@Назар-э4о]

I'd add a sticky/fixed header, not sure how it's called

[@EllDeez]

Row freeze?

[@mohamed.montaser]

please share the dataset with us

[@smmexp9]

i need this data set

[@Zues64]

good video but not a fan of small fonts. you need to be aware of your users of the spreadsheet--Not all have Hawkeyes :-)

[@pipeliner8969]

13:50 This could be done eaiser for users. Come on, Google Designers!

[@louisrobitaille5810]

It's already pretty much as easy as possible...

[@omenworks]

Title font is gradient... I watched the whole thing to learn a lot but nothing was said about gradients 🥲

[@ReyBanYAHUAH]

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!🙂🙂

[@AgusWardiman1408]

I'am Google Spreadsheet Creative I'am Drawing Building, office and college University with sheets

[@kgs012]

I was hoping he would make it look decent … waste of time

[@txkos]

Centering dollar amounts.....noooooooooooooooooooooooooooo! Please, oh please never do that.

[@emilianoreyes]

Thank you!

[@showkatakbar5529]

please share the dataset with us

[@ExcelGoogleSheets]

search Chicago Data Portal Datasets