|
Home > Data > Data Entry > Google Sheets Google Sheets 5 Quick Tips
|

In this video, Dylan shows 5 favourite tips and tricks that he learned to use in Google Sheets, and his written steps are below the video
You can see more of Dylan's Google Sheets videos on his YouTube Channel, .
This first trick can be used when you have a list of decimal numbers that are not lined up. Some numbers might have zero decimals, and other numbers could have 1 or 2 or more.
When decimals points are are not lined up, it can look like some numbers are larger then others, even though they’re smaller. For example:

To fix this problem, follow the steps below, to format all of the amounts with the same number of decimal places:
This will automatically make all of your selected decimals exactly 2 decimal points long, by rounding up or down.

Next I have a few shortcuts that you can use, to select cells on the sheet.
Another great tip is adding checkboxes to your sheets, which is super simple.
Instantly, a checkbox will appear in the selected cell.

So, why are checkboxes so useful?
I also found out that you can change the colour of a check box by going to “Text Colour” in the menu bar and changing that colour.
Next, I want to show you how to completely move a cell without all of the commands.
This is an easier way to move cells, rather than copying and pasting, or using the cut feature. With this tool, there are no commands you need to know, and you don’t need to paste the cell that you copied or cut.
Finally, let’s talk about freezing rows and columns. It’s a useful feature for keeping important data visible while you scroll through large spreadsheets.
This feature is incredibly useful when you’re working with large datasets.
For example, if you have headers in the top row that describe your data, freezing that row ensures those headers stay visible as you scroll down.
It’s a simple trick, but it makes navigating and analyzing your data much easier.
Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
Our summer intern, Dylan S, is a 4th year Design Studio student, at a high school in Toronto, Canada. As the summer intern at Contextures, Dylan added spreadsheet and video skills to his repertoire. We’re excited to see him share those new skills online, through videos on his YouTube Channel, and in his articles on the Spreadsheet Day blog.
Last updated: June 17, 2025 7:53 PM