Filter Google Sheets Data without Changing What Collaborators See

Google Sheets Logo

Filters in Google Sheets let you analyze data in your document by showing only the things you want. However, it changes how others see the document, too. Here’s how to use filter views to leave each collaborator’s view unchanged.

Fire up Google Sheets and open up a spreadsheet to get started.

Example of a dataset in Google Sheets.

Click Data > Filter Views > Create New Filter View.

Click Data > Filter Views > Create New Filter view.

The row numbers and column letters will turn a dark gray color when activated. At this time, you should give your filter view a name to distinguish it from any other views you make in the future and check the range is correct. You can always edit both of these later if needed.

Rename the view to something memorable and make sure the range is correct.

For this guide, we want to filter anything in the table that has a price per unit greater than $10. Click the filter icon in the field for “Price Per Unit.”

Read the remaining 21 paragraphs

How to Assign Tasks in Google Drive

Google Drive Logo

When collaborating on files in Google Drive (Docs, Sheets, and Slides), it’s easy to lose sight of who’s working on specific parts of a project. With Google Drive, you can assign tasks to another collaborator on your team.

Fire up Google Drive and open a file you currently collaborate on with other people.

Fire up Google Drive and open a file that you collaborate on with others.

For this guide, we’ll use a Google Docs file, but the process is virtually the same for either a Sheets or Slides file.

Highlight some text, an image, cells, or slides, and then click the Add a Comment icon, located on the right of the page. Alternatively, press Ctrl+Alt+M (Windows/Chrome OS) or Cmd+Option+M (macOS) to insert a comment using the keyboard shortcut.

Select a portion of the document and click on the Add Comment icon on the right of the page.

RELATED: How to Add Comments in Google Docs

To add a comment to an image, it needs to be aligned “In line.” “Wrap Text” and “Break Text” disable the ability to add a comment.

Read the remaining 13 paragraphs

How to Share a Google Docs, Sheets, or Slides File as a Web Page

The Google Drive Logo

With Google Drive, you can share any Google file (from Docs, Sheets, or Slides) online as a web page for anyone to see. You can even share simple HTML files to act as your site’s landing page. Here’s how to do it.

Sharing a Google file as a web page is a great way to publish information to the Internet for a large audience. Anything you share is entirely public, and—if you use the right search string—it can be found via any search engine as a lightweight page on the web.

When you share a file to the web, Drive creates a copy of it with a unique URL. This allows you to make edits and publish changes when you want to, and it also prevents viewers from seeing any source material.

Remember: anything you publish to the web is available for anyone to see, so you should never include sensitive or private information in your files.

How to Share a Google Docs File

Fire up your browser, head to Google Docs, and then open the file you want to share. Click File > Publish to the Web.

Click "File," and then select "Publish to the Web."

Next, click “Publish” to make your file visible on the Internet.

Click "Publish."

Read the remaining 60 paragraphs

How to Share “Make a Copy” Links to Your Google Files

Docs, Sheets, Slides logo

Google Drive lets you send a file to others with a link to “Make a Copy” while maintaining the original. The copy is then saved into the recipient’s Drive where they can edit it however they want.

This guide works for Google Docs, Sheets, Slides, and Drawing files. We’ll be using Docs, but the procedure for each service is essentially the same.

RELATED: How to Copy Google Drive Folders

Fire up the Google Docs homepage and open a file you want to share with someone to make a copy. Right-click the URL in the address bar and click “Copy.”

Right-click the URL in the address bar and click "Copy."

Next, open Gmail and compose a new message to the recipient. Paste the URL into the body of the message with Ctrl+V (Windows/Chrome OS) or Cmd+V (macOS), click on it to bring up the More menu, and then click on “Change.”

Paste the URL into the body, click oin it, and then click on "Change."

At the very end of the URL, change “Edit” to “Copy” and then click “OK” to save the web address.

Read the remaining 9 paragraphs

How to Add Flowcharts and Diagrams to Google Docs or Slides

The Google Drive Logo.

Flowcharts and diagrams can help people understand confusing data. If you need one for your Google Docs or Slides file, you can create it without leaving your document. We’ll show you how.

Insert a Flowchart In Google Docs

Fire up your browser, open a Docs file, and then click Insert > Drawing > + New.

Click "Insert," select "Drawing," and then click "+ New."

RELATED: The Beginner’s Guide to Google Docs

From the Google Drawing window, click the icon that looks like a circle on top of a square. Hover over “Shapes,” and then click the shape you want to use. Note that all the shapes at the bottom of the Shapes selector are for flowcharts.

Click the icon with a circle over the square, hover over "Shapes," and then click the shape you want.

Google Drawing is an extremely simple flowchart creator. It relies heavily on your drawing and organizational skills. After you select a shape, drag your mouse cursor to create it on the canvas.

Click and drag to create a shape.

Read the remaining 53 paragraphs