how to format currency in google sheets

How to Use Currency Formatting in Google Sheets

Proper formatting in a spreadsheet can make it much easier for your audience to interpret the data that they are looking at. When the data in a row or column is uniform, it’s easier to spot problems or errors. This is particularly useful when you have monetary values in cells, as some of the values… Continue Reading How to Use Currency Formatting in Google Sheets

convert google sheets to microsoft excel

How to Export a Google Sheets File for Microsoft Excel

Google Sheets is a great, free spreadsheet application that is available to people with Google Accounts. You can create, edit and manipulate data using this powerful program, and you can accomplish many of the things that you might otherwise do in Excel. For example, Google Sheets has the ability to combine multiple cells into one,… Continue Reading How to Export a Google Sheets File for Microsoft Excel

how to remove strikethrough in google sheets

How to Remove Strikethrough in Google Sheets

Some formatting options will have a minimal amount of effect on the appearance of data. For example, changing the font size or using a different font may not make the text any more or less readable. But if you draw a line through some of your text, it’s possible that some people might have trouble… Continue Reading How to Remove Strikethrough in Google Sheets

how to left align a spreadsheet in google sheets

How to Left Align a Spreadsheet When Printing in Google Sheets

In many cases a spreadsheet will look better on the printed page if all of the spreadsheet data is aligned at the center of the page. You may even find that merging some of your cells and centering is useful as well. There’s something about centering information on a page that is just more visually… Continue Reading How to Left Align a Spreadsheet When Printing in Google Sheets

how to hide gridlines in google sheets

How to Hide Gridlines in Google Sheets

Gridlines are an important element for both editing your spreadsheet on a computer and viewing the spreadsheet on the printed page. In fact, Google Sheets has set this as the default behavior for the application. However, you may find your self in a situation where you need to display or print your spreadsheet without gridlines.… Continue Reading How to Hide Gridlines in Google Sheets

how to restore old version of file in google sheets

How to Restore an Older Version of a File in Google Sheets

When you are working with big spreadsheets and large amount of data, it is always a possibility that you will inadvertently change the wrong data, or you will copy and paste the wrong information. This problem can be made even worse when you are collaborating with a team of people on a single file. Google… Continue Reading How to Restore an Older Version of a File in Google Sheets

click the worksheet tab, then click rename

How to Rename a Worksheet in Google Sheets

Large workbooks often have multiple worksheets contained within them, as it is usually more convenient to contain related information entirely within one file. The default worksheet naming convention in Google Sheets will label each worksheet with names like Sheet1, Sheet2, Sheets3, etc, which is typically not very helpful in identifying the information contained in that… Continue Reading How to Rename a Worksheet in Google Sheets