Data that you print in a spreadsheet can be difficult to read, especially when there are a lot of rows and columns. It’s very easy for a reader’s eyes to glaze over when viewing this type of information, as it all starts to run together. This problem becomes amplified if the data isn’t visibly separated […]

Google Drive makes it very easy for you to share a link to one of the Google Sheets files that you’ve created. Simply turn on a sharing setting to get a link to the file, which you can then send to anyone you wish. But you may find that that link ends up in the […]

When you make a workbook in Google Sheets that contains a lot of worksheet tabs, finding the important ones can be difficult. In some cases you might actually need to access every tab in your worksheet but, in other cases, there might be some old tabs, or tabs that are just for formula references, which […]

The collaboration feature in Google Sheets makes it easier for a group of people to work on the same file. But if you have shared your file with others, you might not want them to be able to change some of the information found in that file. Fortunately Google Sheets provides an effective way for […]

Sorting data in a spreadsheet is very useful, and some sort of sorting method is usually preferred when you are submitting a report at your job or school. Arbitrarily analyzing data can be difficult, especially when important values are spread across a lot of cells without any real order. You may be familiar with sorting […]

Do you find it difficult to manage your files in Google Drive because the names aren’t descriptive enough? Sometimes we may have an idea of how we want to name our files when we initially create them but, over time, we can discover that our original file names weren’t very helpful? You may be familiar […]

When you create new spreadsheets in Google Sheets, you are probably accustomed to adding data to blank cells. This is easy to do when you are working with a new file and are adding data for the first time. But as your spreadsheet starts to fill in, or if you are working with an old […]

Many of the programs and Web applications that you use will have the ability to autocomplete as you type. As you become familiar with this feature it can really be helpful when typing, especially if you often retype the same string of characters. But the autocomplete feature in Google Sheets can also lead to problems […]

Does it seem like your printed spreadsheet isn’t making the best use of the space on the page? If it seems like you aren’t fitting as much information on a page as you could be, then changing the orientation could be a beneficial change. In Microsoft Excel the orientation setting is fairly accessible, so it […]

Formulas in spreadsheets can save you a lot of time and frustration, while also making it easier to both keep your values up to date, while also ensuring that the results of those formulas are accurate and not subject to typos or human error. In many cases the only thing that is important about a […]