The unique function in Google Sheets can be very useful – when applied to a list with multiple entries that repeat, it provides a second list that only features one of each entry. This means that if you have a list featuring multiple sign-ins from multiple people, you can use the unique function to find out who signed in. The result of the unique function is a list featuring … [Read more...] about How to Use the Unique Function in Google Sheets
Google Sheets
Google Sheets: Remove Formatting From Cells
Removing existing formatting from cells in a Google Sheet can be done very quickly! It’s a two-step process. … [Read more...] about Google Sheets: Remove Formatting From Cells
Google Sheets: Change Graph Colors
Google Sheets is a fantastic tool for keeping track of data, and for visualizing it as well. Graphs, Charts and more – thanks to Google’s free online program, it’s easier than ever. Or, at least, it should be. Not every function is always apparent, especially for new users, so here are some tips on how to change the colors of your graphs and charts, and a few other tips that … [Read more...] about Google Sheets: Change Graph Colors
Google Sheets: Add Multiple Lines of Text in Single Cell
There are many different scenarios in which you would want to add multiple lines of text within a single cell in Google Sheets. For instance, you may need to describe the calculations you are making. Perhaps you wish to detail line items on a budget. Whatever the reason, getting all of your text to fit into a single cell while still keeping your spreadsheet looking professional … [Read more...] about Google Sheets: Add Multiple Lines of Text in Single Cell
How to Spell Check in Google Sheets
I’ve mentioned many times how heavily I rely on the Google suite of tools. I am fairly sure I have also told you I type insanely fast - to the point I sometimes type words without thinking and do not realize they’re misspelled until Docs underlines them. However, working within Google Sheets is not the same. That program does not underline misspelled words for me! Let me show … [Read more...] about How to Spell Check in Google Sheets
Hide and Unhide Rows and Columns in Google Sheets
Google Sheets is an excellent alternative to Microsoft Excel. Some of us even feel it is better. It is much more intuitive. Things are easier to find and do without always having to stop to look things up. With that said, though, there are some things about Google Sheets that may be a little difficult to figure out at first. This is true of nearly all software, no matter who … [Read more...] about Hide and Unhide Rows and Columns in Google Sheets