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 […]

The height of a row in a spreadsheet can affect the amount of data that is visible. If it’s only a single line of numbers of text that uses the default font size, then you should be able to see everything without making any adjustments. But if you have multiple rows of data in a […]

When you initially create a spreadsheet, you often do so by including a row of column titles in the first row of the spreadsheet. Generally this allows you specify the fields of data that you need for the spreadsheet’s purposes, ensuring that you have everything that you need in order to properly evaluate your data. […]

Many of the spreadsheets that people work with in Google Sheets involve money. But it’s possible that the cells containing those monetary values are either formatted as numbers, or have some kind of other formatting applied to them. This can make your values display inconsistently, especially if the last decimal place of a number ends […]

Have you ever printed a spreadsheet, then found it a few months later, only to wonder what the spreadsheet was for, what date it was printed, or what information you should be concerned with? This is very common, especially if you often print updated versions of the same spreadsheet. One way to resolve this issue […]