Google Sheets adds new features

Spreadsheets are an everyday tool for some of us. Google sheets has often been criticized for having less features that MS Excel, but this really is no longer the case. Google has quietly been making changes to sheets to make it more versatile for gSuite users.

You can now rotate the text in a cell in Sheets (Format > Text rotation). This is especially useful when you need to fit long header names into thin columns, or when you simply want to fit more text on a single screen.

Another feature added this week is the ability to format text with accounting number formats. The currency symbols as well as numbers, decimal points and repeated characters can be formatted to line up correctly.

Late last year they added alternate row colors as a feature. Select a range of cells and choose (Format > Alternating Colors). Options for color combinations are loaded in a side pane.

These are just a few of the new great features that have been added to Google sheets. Don't forget to check out a range of cool Add-ons (Add-ons > Get Add-ons) which add features that even Excel does not have. My favorite is Power Tools.

Power tools adds some really handy features such as the ability to change case, split data into first and last names and even the holy grail of spreadsheets ... remove duplicates. Make sure you check out Power Tools.

Comments

Relax: You're in Complete Control!

Well, you may not rule the world but you are in absolute control of the content in your Google account. You can copy the content in your account to use elsewhere or use the archive tool as a simple backup. This works great if you want to backup your YouTube videos or a specific folder in g Drive. To accomplish this, follow the below instructions: Visit https://myaccount.google.com/ From the Personal Info & Privacy area, click on CONTROL YOUR CONTENT Click on CREATE ARCHIVE The next screen allows you to select what data you want to include. By default, all options are selected. If you want to archive one specific folder in gDrive and/or YouTube files, it is easiest to click on the SELECT NONE button. After clicking on the SELECT NONE button, you will need to select which ones to include in archive by clicking on the white square next to the X. The green square with a white checkmark indicates that this data will be included in archive. If y...

Review your Google app permissions!

I just LOVE the Sign in with Google buttons that you find all over the web. They are great because they use a protocol called OAUTH to securely log you in using your Google account. This means you don’t have to remember yet another username and password. We get so used to clicking these buttons to log in to sites and that means we’re racking up a bunch of sites that have access to our Google accounts. Today, I’m going to show you how to manage the connected apps and sites that you’ve authorized with your Google account. We can use this tip to review these apps and sites to see if we really use them and if we want them to have access to our Google account. Just follow these steps: Click your photo at the top right of any Google window, and select My Account. On the left side of the My Account window, click Connected apps & sites Then under the Apps connected to your account section, choose Manage apps. This will give you a list of a...

I want to Shoot My Screen!

OK so now I have your attention! If we re-arrange the words a bit "I want to take a shot of my screen" aah yes screen shots but what are they good for? Many websites while allowing students to do drill and practice and take quizzes, they lack the ability to save or record scores or results. Have the students take a screenshot of their results and submit via google classroom as an attached image. Screenshots are a way of capturing a picture of your screen, be it your chromebook, a desktop computer or even your cell phone. The secret to unlocking this feature is to know the magic key combinations or button presses for your particular device. Windows - The old standby is Alt + PrnScn which copies the entire screen to the clipboard. You can then paste it into your favorite editor to save as an image file. Windows 7 and above - Included in your list of apps is one called the Snipping Tool . Add a shortcut to your toolbar and when invoked this app lets you take a scree...

Tech Tuesday Tips

Search This Blog