Google Sheets has long had an option that allowed you to view the history of a file. You could open up the Version History, select a version of the sheet from a different date, and even revert to that version of the file if you wanted. But they have recently added a feature that gives […]

Have you ever made a change to a spreadsheet, then realized later that it was a mistake? Often these sorts of changes can be rolled back with Ctrl + Z or the application’s Undo option, but sometimes they can’t. Typically you may decide that you simply need to manually recreate everything, or possible even give […]

Google Sheets is very similar to Microsoft Excel in many ways and, for a large number of users, is a perfectly acceptable replacement. Sheets lets you perform much of the same formatting, and many of the same calculations, that are possible in Excel, and the ability to share and collaborate on projects with other Google […]

The rows in your Google Sheets spreadsheet have a height of 21 pixels by default. This is meant to fit a single line of text at the default font size. But you may find that this row height is too small, or your spreadsheet needs require the height of your rows to be either smaller […]

Sometimes when you are creating a spreadsheet you will focus first on adding all of the data, then format everything so that it is more presentable for your audience. This could include things like making it look better when you print, or applying the correct type of formatting for your data. But you may discover […]

Google Sheets, much like Microsoft Excel, lets you add new worksheets to your file. This makes it easy for you to organize all of your relevant data in one file so that you aren’t constantly switching between multiple files. You may already be familiar with how to change the name of your file in Google […]

Adding a picture to a Google Docs file is as simple as clicking a button in the toolbar and finding the picture you want to insert. But that picture is going to be in your document in its original orientation, at its original size and transparency. If you’ve already edited the picture in another program […]

One of the best ways to make your spreadsheets more useful and easier to read is to apply the proper formatting to your cells. This can include things like adjusting the number of decimal places, and it can include formatting monetary values as currency. You may have noticed that Google Sheets only seems to let […]

Spreadsheet applications like Microsoft Excel and Google Sheets let you do things like create and calculate formulas using the data that you have entered into your cells. This data can further be customized with a number of formatting options that let you make the data easier to read and look better. But while these feature […]

Cell borders are useful in spreadsheet applications for providing a visible outline around cells of importance, or when you are printing your spreadsheet. But your needs for cell borders may change over time, or you might be working on a spreadsheet that has borders, but doesn’t need them. Fortunately borders can be removed in Google […]