google sheets invisible text This is a topic that many people are looking for. s-star.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, s-star.org would like to introduce to you Google Sheets New Features – Text Rotation & Border Tools . Following along are instructions in the video below:
“And thanks for joining me here at the techie coach and today. I m going going to talk about a couple of new features that were just recently added to sheets a couple of features that i think you re going to love that will make your life. A little bit easier one specific feature that many teachers that i work with have been asking for is the ability to align or rotate text. So that it can be used vertically or at an angle in sheets.
And this is a feature that you can find in some other programs like excel. But for one reason or another. It just hasn t been there in sheets. And people been waiting for this one.
What you have to do is if you wanted for instance these dates to appear vertically or at an angle. Just highlight the cells and you have a couple of options for formatting you can go to the format menu and choose text rotation. Which gives you all these options here or custom angles. That you can choose or you can simply go up to the toolbar and choose this text rotation tool and from here i want these to be tilted up so if i do that it arranges it so that they re tilted up now the great thing about this that i like is that if i wanted to make these columns a little bit narrower.
Because that s one of the things that this affords is the ability for your columns to take up less space. When your header is not as big then once i resize those columns and add borders to this it s going to look a little bit different than you re used to now that brings us to another feature and that is the fact that inside sheets. Now you have more boarder options. If you go to the toolbar for the borders tool and you click and add borders you ll see that because i ve tilted that up it automatically creates an angled border to those cells.
Now you have the option of using a dashed line or a dotted line. That you often find in a lot of accounting spreadsheets. When you add borders to your sheet. So i m going to go ahead and add the dots and of course you can still add any kind of color that you want to that and of course for what we re doing today.
I m just going to go ahead and change this back because i d like that to be a solid line. So i m going to leave that as is but as you can see my dates now take up less space. My columns are smaller. And if i wanted to add more dates out to the right as we have more meetings.
Then i won t have to scroll in scroll and scroll to the right..
I have more room to work with here and finally the last feature that s been added our accounting number format. So if you re using google sheets for budgets or expenses. Then you now have monetary amounts that line up with accounting measures. So for instance.
If i had students and we re taking dues for our clubs. And some had paid and some have not i go ahead and put those in and i want those to appear as a dollar amount. If i highlight those cells and then go to the format menu and go to number you re going to notice that what s been added this week is an accounting option and so by clicking on accounting. It retains that number format and of course.
You ve got if you ve got larger dollar amounts that go above 100 into the thousands range you ve got the comma that s inserted in there..
And you also have your dollar sign that appears so let me show you what that looks like of course. There you are so great features to add to sheets this makes sheets a much more robust tool for those that have been hanging on to excel and waiting to make the switch the sheets. I hope you find this to be useful for you and if you have any other questions feel free to contact me or you can check out my blog at wwdc um. Thanks for joining.
Thank you for watching all the articles on the topic Google Sheets New Features – Text Rotation & Border Tools . All shares of s-star.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“This video covers new features added to Google Sheets that include Text Rotation, Border Tools, and Accounting Formatting.”,
TechyCoach, Techy Coach Blog, Google Tutorials