Learn to automate and grow your business with spreadsheets
Did you know that in Google Sheets there is an easy way to clear the formatting of a cell? The “Clear formatting” feature will instantly reset the formatting of a cell or a range of cells, which includes fill color, text formatting, borders, conditional formatting, data validation, and every different […]
In Google Sheets, you can copy formatting from one location in your spreadsheet to another. This is a very handy trick that makes formatting spreadsheets fast, and it allows you to quickly replicate formatting over and over after you spend the time to customize the formatting the first time. When […]
If you have values in your spreadsheet that are displaying in date format when you do not want them to, there are multiple ways to remove the date formatting. This happens often when you enter data into a column that was previously formatted for dates, and sometimes it even seems […]
Do you have a date in your Google spreadsheet that you want to add days to (or subtract) with a formula? There is a very easy way to do this, and in this article I am going to show you multiple ways to add or subtract days, months, or years […]
Have you ever wanted to quickly make the cells in your spreadsheet the same size? Sometimes you may want to change the size of the cells for a certain project, and make sure that all of them are the same size… or sometimes you may just want to clean up […]
In this lesson I am going to teach you how to get a list of dates without weekends in your Google spreadsheet. I will also teach you how to use the WORKDAY function, which allows you to calculate a date that falls a certain number of workdays (business days) in […]
By default Google Sheets has 1000 rows in a new spreadsheet, but you can add more rows anywhere you want in your spreadsheet. Sometimes you may need more rows to hold more data in your spreadsheet, or you may simply need to insert a row in an exact location. In […]
By default Google Sheets has 26 columns in a new spreadsheet (A through Z), but you can add more columns anywhere you want in your spreadsheet. Sometimes you may need room for more data, or you may simply want to insert a blank column in an exact location. In this […]
In Google Sheets there are several different ways to format dates. In this lesson I am going to show you the different options for date formatting that Google Sheets provides, and I’ll show you how to use custom date formats so that you can display your dates in the exact […]
Are you wanting a way to make the cells in your spreadsheet bigger or smaller… or maybe even a different shape? There are several ways to change the size of cells in Google Sheets, and in this article I will show you each of them. I’ll show you how to […]
In Google Sheets, there are multiple ways to adjust the width of columns. In this article I am going to show you how to change the column width to be wider or narrower, and I will also show you how to change the width of specific columns or every column […]
Are you looking for a way to insert a text box in Google Sheets, where the text box is inserted over the cells? Text boxes are a handy way to display text in your spreadsheet, in any location that you want, and in any position that you want. In this […]