Register now for better personalized quote!

How to use pre-built tables in Google Sheets to simplify your spreadsheet life

Aug, 20, 2024 Hi-network.com
Jack Wallen

Spreadsheets are a great way to chart, sort, and present data. For some, creating a spreadsheet is second nature -- for others, however, it can be a real chore. Sure, you might understand how to add data to the document, but what about creating a unique color palette for your spreadsheet or making a spreadsheet for a specific task, event, or roadmap?

Also: How to redact PDFs in Google Docs - for free

Fortunately, Google Sheets offers pre-built tables, a feature meant to help simplify designing your ideal spreadsheet. These pre-built tables include features like smart chips, placeholders, and custom color palettes. Sheets has templates for many use cases, including project tasks, content tracking, product prioritization, recruitment applicants, travel and event planning, customer relations, project roadmap, inventory management, recruitment, team planning, and marketing.

Pre-built tables are easy to use -- here's how to get started.

How to add a pre-built table table in Google Sheets

What you'll need: The only things you'll need for this are a valid Google account and a web browser. One thing to keep in mind: the pre-built tables feature cannot be used on the mobile version of Google Sheets, so the only way to access it is via a desktop web browser. 

1. Create a new spreadsheet

To start, log into either Google Drive or Google Docs and create a new spreadsheet. The pre-built tables feature only appears in new spreadsheets, so if you open a previously existing document, you won't see the pre-built tables sidebar.

2. Find the type of pre-built table you want

From the Tables sidebar, you can search through the listing of table types to find the one that best fits your needs. Make sure to expand the categories, so you can see the different options available. For example, the Marketing category includes "Content tracker," "Campaign tracker," and "Campaign results." The "Travel planner" category includes "Trip itinerary," "Trip budget," and "Trip transportation." 

Also: Your Android phone is getting an anti-theft upgrade, thanks to AI

There is no search feature here, so you'll have to scan through the options manually. You can hover over one of the entries to see a sample of how it looks displayed on the spreadsheet.

There are several pre-built tables to choose from.

Jack Wallen

3. Insert the desired table

Once you've found the type of table you want to use, hover your cursor over the entry again and click Insert. If the table you've added doesn't work, you can go back to the sidebar and select a different pre-built table to replace it. 

Also: How to add conditional formatting to a Google Sheets drop-down list

If you've already closed the sidebar, you can re-open it by clicking the Insert menu and selecting Tables.

You'll see both the Insert button on a cursor hover and a demonstration of how the table will look.

Jack Wallen

4. Customize the table

Not every pre-built table will perfectly fit your needs. Because of that, you can customize things like column titles, views, and more. You can also easily add more rows at the bottom, as well as priorities and statuses, change ownership, and more. Once your new table is customized, you can start entering data as needed.

The pre-built tables are very well designed.

Jack Wallen

That's all there is to using the Google Sheets pre-built tables feature. This handy option allows you to create helpful, well-designed spreadsheets in minutes.

Featured

Labor Day weekend and sales are here. Here's what to know, and the best deals of the weekendStill have a Windows 10 PC? You have 5 options before support ends next yearThis Samsung phone is the one I recommend to most people (and it's not a flagship)Which programming languages are most popular now (and what does that even mean)?
  • Labor Day weekend and sales are here. Here's what to know, and the best deals of the weekend
  • Still have a Windows 10 PC? You have 5 options before support ends next year
  • This Samsung phone is the one I recommend to most people (and it's not a flagship)
  • Which programming languages are most popular now (and what does that even mean)?

tag-icon Hot Tags : Home & Office Work Life Productivity

Copyright © 2014-2024 Hi-Network.com | HAILIAN TECHNOLOGY CO., LIMITED | All Rights Reserved.