I always use the contains formula in conditional formatting. It lets users know exactly where they need to type in data and where they should not mess with things This has a lot of other great tips too. Great job
Thank you for this video. I stumbled upon your channel. This is by far the best video or perhaps I have come which gives direction on best practices in structuring tables.
I have been trying without success to do the following in Google Sheets: I would like to lay out a Google Sheets Pivot table similar to what we get in Excel Pivot table when we select Field Settings... Layout & Print... Show Item Labels In Outline Form. In Excel this gives me the "next" field on a new row instead of the default of a new column adjacent to the other values. Think of it like addressing an envelope: The data fields are stacked on top of each other instead of in new columns. I am an Excel expert, but new to Google Sheets. I can handle Google Sheets Query and other advanced concepts if necessary. Is this even possible in Google Sheets?
Hiya thanks for the question. I’m on vacation for the week, it’s ofen hard to visualise these things, maybe you can try one of the forums that let you upload images & files. My query function in google sheets video may help though!
Thanks for the comment. Unfortunately Google's "alternating colours" are not treated as Tables like Excel's its one area where Sheets falls behind, you can however name a range in Google sheets by clicking Data > Named ranges, but it doesn't grow dynamically unfortunately.
Thanks for the help !
A brand new feature just came to sheets which is very relevant to this, I’ll release a video on Tables in Sheets this week! Look out for it 😃
I always use the contains formula in conditional formatting. It lets users know exactly where they need to type in data and where they should not mess with things
This has a lot of other great tips too. Great job
Absolutely!!! Couldn’t agree more 😃
Thank you for this video. I stumbled upon your channel. This is by far the best video or perhaps I have come which gives direction on best practices in structuring tables.
This is so lovely to hear! I'm glad its helpful. Thanks so much :)
Great! Thanks for demonstrating. Thumbs up!!
Glad you like it!
Good tips, thanks! I prefer to put lookup tables on a separate panel/sheet
Glad you like it! Yes good advice… I prefer that too usually!
Good tips
Thanks for the feedback!
I have been trying without success to do the following in Google Sheets:
I would like to lay out a Google Sheets Pivot table similar to what we get in Excel Pivot table when we select Field Settings... Layout & Print... Show Item Labels In Outline Form. In Excel this gives me the "next" field on a new row instead of the default of a new column adjacent to the other values. Think of it like addressing an envelope: The data fields are stacked on top of each other instead of in new columns. I am an Excel expert, but new to Google Sheets. I can handle Google Sheets Query and other advanced concepts if necessary.
Is this even possible in Google Sheets?
Hiya thanks for the question. I’m on vacation for the week, it’s ofen hard to visualise these things, maybe you can try one of the forums that let you upload images & files. My query function in google sheets video may help though!
Thanks. How can we name tables in a spreadsheet?
Similar to what we do excel ie., changing the name of the table from table1 to Sales.
Thanks for the comment. Unfortunately Google's "alternating colours" are not treated as Tables like Excel's its one area where Sheets falls behind, you can however name a range in Google sheets by clicking Data > Named ranges, but it doesn't grow dynamically unfortunately.
How come gsheets never copied Table objects from Excel?
It’s a good question. I’m not sure. Tables & Power Query are two main missing things I would say
Very useful. Please take some time to explain.
Glad you like it!
Kindly send the file
Sure! Please email to david@xlconsulting-asia.com & subscribe to my channel & I’ll send it acoss