Formatting

When working in spreadsheets, there may be times when you want to convert rows into columns or turn columns into rows. In spreadsheet programs like Google Sheets and Excel, this …

Using custom formatting in your spreadsheet can make your data much easier to read. One common formatting task that users of Google Sheets and other spreadsheet programs want to learn …

If you’re dealing with very large or small numbers, using scientific notation is great because it can be easier to understand your data. In Google Sheets, learning how to control …

When working in Google Sheets, there may be times where you want to create lists by adding bullet points to your spreadsheet. There is not a simple way to do …

In Google Sheets, you can add formatting to your cells so that your numbers will have a dollar sign ($) to represent a currency. Whether you want it to show …

When working with text in Google Sheets there are a number of times where you may need to modify the data. Google Sheets has a few text functions that are …

Sometimes Google Sheets will round your numbers depending on the settings you have applied to your spreadsheet. Sometimes this is a good thing, other times you may want to see …

Sometimes when you want your data to look uniform in Google Sheets, you have to round your numbers. Having all your numbers rounded to the same amount of decimal places …

Sometimes no matter how you format your data or adjust your print settings, your document will not look good without setting custom page breaks in Google Sheets. If you are …

Learning to set the print area in Google Sheets is an important skill for all spreadsheet users to learn. When you need to print your file onto paper you want …