11 Best Google Sheets Tricks

Google Sheets is one of the best alternatives to Excel . In fact, I think it has some notable advantages over Microsoft’s application . The first is that most Sheets formulas are identical to those in Excel. On the other hand, its cloud-based operation is very conducive to collaborating with other users. Yes, I know Excel can also be used for collaboration, but Google’s suite is very fast at synchronizing changes . On the other hand, if you don’t want to pay for licenses, a Google account is enough to take full advantage of its potential. With the 15 GB free that Google offers, you won’t even have to pay for Google One .

In the following sections, I’ll take you on a journey through the most interesting features of Google Sheets . In this case, I won’t focus on using spreadsheets, but rather on the tricks that will help you get the most out of this application. If you’re new to this platform, stay with me. You’ll leave this post as a Google Sheets expert.

  • Use the predefined tables to get started
  • You also have templates
  • Create spreadsheets with a quick URL
  • Use Excel format with Spreadsheets
  • Take advantage of smart chips
  • Link a form to a spreadsheet
  • Learn to use macros
  • Work faster with keyboard shortcuts
  • Use conditional formatting
  • Learn the syntax of formulas
  • Use your data more intelligently

Use the predefined tables to get started

Google Sheets comes with a ton of pre-designed tables to help you get started with your new spreadsheets. Depending on your goals, you’ll be able to apply the most suitable layout to your spreadsheets with just a few clicks.

Pre-designed tables are great for getting started with Google Sheets. The best part is that there are tons of options.

To start taking advantage of this feature, simply click Insert and then Tables . Then, open the various drop-down menus to view all the options available to you. If you hover over each table, you’ll see a spreadsheet implementation that will help you understand its power and, above all, whether it will actually be useful to you.

This is a little-known Google Sheets trick, especially since the company only recently introduced it . Be that as it may, it’s also one of the most useful.

You also have templates

In line with the above, I also think it’s worth mentioning that Google Sheets has a fairly comprehensive collection of templates . The pre-designed tables are great for getting started, but with templates, you can design your entire spreadsheet from scratch.

Templates are also available, although you’ll need to choose them before creating the new sheet.

Templates are selected from the main Sheets menu , both in the browser and on mobile. If you’re using Android or iOS , when you create a new sheet, the app will ask you if you want to select a template. The desktop version offers some templates at the top, though you can view them all by tapping on the Template Gallery .

Without a doubt, between the pre-designed tables and templates , you don’t have to complicate things much to start taking advantage of this tool.

Create spreadsheets with a quick URL

Pay attention to this trick, because it’s one of the most useful you’ll see on this list. As far as I know, Google has purchased five .new domains . You may not have known these domains existed, but Google did, and the best part is that it knows how to take advantage of them.

With this URL you will be able to create new files in Google Drive

You can create a new Google document by simply typing one of these URLs into your browser:

  • doc.new / docs.new (new Google Doc)
  • sheet.new / sheets.com (new Google Sheets)
  • presentation.new (new Google Slides)

Use Excel format with Spreadsheets

Google Sheets is perfectly capable of working with XLSX files . It’s true that using the company’s own format has some advantages, such as additional features and faster loading speeds. However, opting for Excel’s format also has its benefits. The main one is that files are fully synchronized with any computer , making backups easier.

Uncheck this option to prevent Google from converting Excel files to its own format

With this in mind, if you go to Google Drive and go to Settings, you’ll see an option that prevents uploaded Excel files from being converted to Google’s own format. You should leave it unchecked in the General section , as seen in the image above.

However, it’s not possible to natively create XLSX files from Google Drive on your computer. The only option is to download spreadsheets in Excel format and upload them to Drive after unchecking the option I mentioned.

Interestingly, on Android, you can enable the option to create XLSX files in Sheets . You can find this option in the settings menu.

Take advantage of smart chips

Smart chips have been in Google Docs and the company’s other office applications for some time now. Just type an at sign (@) to bring up a list of all the items you can add to a cell.

Smart chips are added by entering an at sign (@)

Among the various formats supported by chips are ratings, dropdowns, dates, and calendar events. If you right-click and select Smart Chips from the context menu, you’ll see even more formats. For example, as seen in the image below, you can add places from Google Maps.

Among the many out there, the one that lets you add places from Google Maps is great.

Smart chips will help you add dynamic content to your tables and spreadsheets, as well as links to other documents and much more.

Link a form to a spreadsheet

Here’s another trick to turn Google Sheets into a repository of information. You may already be familiar with Google Forms. If not, here’s a quick overview. With Forms, you can create online forms to share with anyone. For example, you can use it to create surveys or contact forms.

Linking a form to a Google Sheets spreadsheet

The most interesting thing is that you can create a new form from Google Sheets based on the contents of the current spreadsheet. This option is found in the Tools menu . Additionally, when you’re creating your new form, you also have the option to link it to a spreadsheet. This way, all the information you receive through the form will be saved in a spreadsheet. This allows you to work with the data, creating filters, charts, or statistics.

Learn to use macros

Let me quickly explain what macros are . Basically, they’re sequences of instructions or commands that automate repetitive tasks in Google Sheets. For example, they allow you to record a series of actions and then play them back with a single click, associating them with a button or link.

Macros are especially useful for handling large volumes of data, as they can quickly perform calculations, format information, or generate reports . But they’ll also help with smaller projects where you may need to repeat the same action over and over again .

Google Sheets also has macros

Well, although it’s a feature associated with Excel, Google Sheets also offers the ability to record macros and run them later. You can find this option in Extensions . By the way, you won’t see it available if you’re working on an XLSX file instead of one in Google’s native format.

Work faster with keyboard shortcuts

Working in Google Sheets without lifting your hands from the keyboard is possible. And, just like the Windows 11 keyboard shortcuts , this platform also has a ton of combinations to help you work faster . Here are the most important ones:

  • Select column → CTRL + SPACE
  • Select row → SHIFT + SPACE
  • Select all → CTRL + A
  • Undo → CTRL + Z
  • Redo → CTRL + Y
  • Search → CTRL + F
  • Copy → CTRL + C
  • Cut → CTRL + X
  • Paste → CTRL + V
  • Paste only values ​​→ CTRL + SHIFT + V
  • Bold → CTRL + B
  • Italics → CTRL + I
  • Insert link → CTRL + K
  • Insert time → CTRL + SHIFT + ;
  • Insert date → CTRL + ;
  • Go to the top of the sheet → CTRL + HOME
  • Go to the end of the sheet → CTRL + END
  • Rename sheet → ALT + 1
  • Format currency → CTRL + SHIFT + 4
  • Format as percentage → CTRL + SHIFT + 5
  • Clear formatting → CTRL + \
  • Fill Down → CTRL + D
  • Fill to the right → CTRL + R
  • Open revision history → CTRL + ALT + SHIFT + H
  • Insert a new sheet → SHIFT + F11

Use conditional formatting

Here’s another important concept you should know. I’m talking about conditional formatting . Simply put, this tool changes the appearance of a cell or range of cells based on its contents. For example, imagine you want the cells in a list to be red if you type NO and green if you type YES . Conditional formatting allows you to do this, which greatly simplifies data visualization.

Conditional formatting helps you intelligently highlight data

Access the conditional formatting options from the Format menu . Then, select the cells to which the rules will apply and add the parameters you want. You’ll see that Google Sheets suggests some conditions. In the image above, you can see the option Format cells if… cell is not empty . Choose the one that best suits you.

Learn the syntax of formulas

Let’s now look at another simple trick that will help you improve your Google Sheets experience. When you start entering a formula with the equal symbol (=), a list of all possible matches will appear at the bottom . For example, if you type =SU, all matching formulas will appear in the list, such as SUM.

When you add a new formula, you’ll see its syntax.

This is already quite useful, especially if you want to find new formulas you don’t know. The best part is that once you’ve chosen the formula you want to add, Google Sheets will tell you its syntax . This way, you’ll know how to build it so it actually works.

Use your data more intelligently

One of the latest features to arrive in Google Sheets is duplicate removal . When things get complicated in your spreadsheets, duplicate data may appear.

Avoid duplicate data with this tool

If you go to the Data menu, you’ll see the Data Clear option . There’s a tool there to remove duplicate data. This same menu also includes other functions to draw conclusions from the information in your spreadsheets. For example, there’s Column Statistics , which lets you quickly see unique values, the total number of rows, the maximum value, and other data for the selected column.

Leave a Comment

Scroll to Top