81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Quick Google Sheets Tips

32 Tutorials

2 hours and 20 minutes

Quick Google Sheets Tips: Boost Your Productivity and Get More Done in Less Time

Quick Google Sheets tips are perfect for busy professionals who want to improve their productivity and efficiency. These short and sweet videos offer quick and easy tips that can be implemented in just a few minutes, helping you to save time and get more done. In this article, we'll take a look at some of the best quick Google Sheets tips, including how to link directly to a tab in a sheet, how to download a sheet as a CSV with a URL only, and how to create an interactive to-do list.


Quick Google Sheets Tips
Very short videos with a quick Google Sheets tip. Rock and roll! If you’re in a rush these tips will add one more tool to your Google Sheets toolbelt in just a few short minutes.

Sample of Tutorials in this section.

Every Tab Has a Unique ID called GID
Each spreadsheet file has its own unique ID, which is its URL. However, every tab in a sheet also has a unique ID, known as a "gid." By using this ID, you can link directly to a tab in a sheet, saving you time and effort. This is especially useful when you're working with large sheets with multiple tabs.


How to Download a Sheet as a CSV with a URL only
If you want to download a Google Sheet as a CSV, you don't need to go through a lot of steps. In fact, you can do it with just a URL. All you need to do is add "/export?format=csv" to the end of the sheet's URL, and you'll be able to download it as a CSV file.


2 Ways to Hide Data
Sometimes, you might want to hide data in your Google Sheet. Perhaps you're sharing it with someone, and you don't want them to see certain information. Or maybe you just want to declutter your sheet. Whatever the reason, there are two simple ways to hide data in Google Sheets: using the IF() formula, or using the "Hide" feature in the "Format" menu.


Interactive To-Do List
Creating a to-do list in Google Sheets is easy. But did you know you can create an interactive to-do list that does so much more? With a little bit of creativity, you can add features like progress tracking, due dates, and even automatic reminders. This is a great way to stay organized and on top of your tasks.


How do I Insert Emojis into Google Sheets?
Emojis are a great way to add some fun and personality to your Google Sheets. To insert emojis, all you need to do is press "Control+Command+Space" on your keyboard. This will bring up a menu of emojis that you can choose from.


Hide Gridlines for Better Communication
Gridlines can be useful when you're working in Google Sheets. They help you to see where each cell begins and ends. However, sometimes they can get in the way and make your sheet look cluttered. If you want to hide gridlines, simply go to the "View" menu, and uncheck the "Gridlines" option.


Frustrated With Sheets New Dropdown Pills?
Google Sheets recently introduced a new feature called "dropdown pills," which are similar to dropdown menus. While some people love this feature, others find it frustrating and prefer the classic dropdown menus. If you're in the latter group, don't worry - there are three simple options to show dropdowns in Google Sheets.

32Tutorials

Less than 2 minute tip to help you link directly to a tab in a sheet. Each spreadsheet file has it's own unique id, a url. But also every tab has a unique "gid" that you can use to link directly to a tab in a sheet. Saving people a click.
Do you know all the ways to add columns to your Google Sheets?

2

Create a new sheet and do it well.
So you want to download a Google Sheet as a CSV. Let's do it!
Add one more feature to the 100 Twitter Templates tool.
Discover 4 easy ways to check if 2 cells in Excel are equal or not! Whether it's numbers, text, or dates, get the answer in seconds with simple tricks. Learn now in this video. 
Create a little web app, or a tool inside of Google Sheets that can take any text input and give us the correct case we want. It can do Title Case or Sentence Case. It can do UPPER and lower case as well.

I added a little apps script to it that will check only one of the options. Check out the Radio Button Apps Script in another video.
Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How! 
Without gridlines our sheets become a lot easier to communicate exactly what we want to communicate.

9

Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.

10

Create a slug maker inside your sheet. We'll take any title with any case, even if it's wrong. Our sheet template will lower case the whole line, and replace any spaces with hyphens. This way we can enter any kind of title we want and get a hyperlink slug out for use in blogs or cataloging.
Hide data with these simple tricks. Just using the IF() formula.

12

3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.
Create a simple to-do list that does so much more.

14

Using Control+Command+Space in inserting emojis into Google Sheets.

15

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.

16

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution

17

Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)

18

Improve Google Sheets Readability Improve the readability of your spreadsheets and supercharge your productivity with our top tips for better numbering and bullet points in Google Sheets. Create Visually Appealing Sheets Discover how to create clear, concise, and visually appealing spreadsheets that engage your audience and get results! Make your lists spicy hot with numbering and bullet points. Learn how to execute this to make your sheets look better. Understanding the Importance of Readability in Spreadsheets Readability is crucial when it comes to spreadsheets. It refers to how easy it is for your audience to read and understand the data you are presenting. If your spreadsheet is cluttered, confusing, and hard to read, your audience will quickly lose interest and may not be able to make informed decisions based on the data you are presenting. The Benefits of Using Bullet Points and Numbering in Spreadsheets Using bullet points and numbering in spreadsheets can help to improve readability by breaking down complex information into more manageable pieces. Here are some of the benefits of using these features: Bullet points and numbering help to organize information in a logical and easy-to-follow way They make it easier to scan and find important information quickly They can help to emphasize key points and make them stand out from the rest of the data They make your spreadsheet look more visually appealing and professional
While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/

20

A quick video to share with you this theory. Consider repositioning your headers as labels in a dashboard.
Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.
You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.

23

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.
Very quick interesting little keyboard shortcut where you might not even know it exists. Repeat what you're doing, over and over again.

26

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.
Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.
Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting
I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today! 
How to add a timestamp to done tasks. Learn how to easily add timestamps to your done tasks! Say goodbye to manual formatting and hello to this simple code. Click now to save time!