Category: Google Sheets (page 2 of 3)

It’s Here! Checkboxes for Google Sheets!

Google recently launched this new feature in April 2018 which makes it very easy to insert checkboxes in Google Sheets, and allow us to use Google sheets as tasks lists. Use checkboxes for many purposes like to take attendance, track a project, and check off your to-do list.

Let’s take a look:

Open a spreadsheet in Google Sheets.  If you are using a spreadsheet from a Google Form you will need to insert a column for your checkboxes.  Click Insert > Column left

Highlight the range of cells or the column for where you want the checkboxes. In the top menu, click Insert > Checkbox read more

Google Photos in Slides

Some of you may have noticed that the image options for inserting images in G-Suite has undergone a refresh. When you go to add a picture from the insert menu it now has a sub-menu.

New insert menu

The Photos option is what we are sharing in this tip.

Selecting photos will open a sidebar on the right side of your document which then loads pictures from your google photos. Select a photo and then click the add button to add it to your document.

Photos screen

What I find this really useful for is to put pictures that I have taken with my phone into a presentation or document or even a google drawing. read more

Copy Comments and Suggestions in Google Docs, Sheets and Slides

I love collaborating with my team (and educators all over NW Ohio!) with Google Docs, Sheets, and Slides. One of my biggest frustrations is that the comments and suggestions don’t transfer when you make a copy. This means you lose your history of all your collaboration when you duplicate a document, spreadsheet, or presentation.. Now Google is making it possible to copy comments and suggestions any time you make a copy of a Docs, Sheets, or Slides file.

To copy your comments and suggestions, simply select “Make a copy” from the File menu as your normally do. Now you’ll see an option for “Copy comments and suggestions” or “Copy comments.” read more

Comments… comments everywhere!

One of the things we might lose when moving to digital tools is communicating with our students. Just like we can leave notes on physical assignments, we can also do this with our digital assignments in Google Classroom.

There are three basic kinds of comments you can leave students in Classroom.

Class Comments: These are comments that you add to your class stream on the “outside” of an assignment or announcement. This type of comment is visible to the entire class, and can be used to answer questions that anyone might have. read more

What the SHEETS?!?

When creating a new Google Sheet, by default, it will have one sheet tab at the bottom of the page. The program is designed so that you can have a maximum of 200 sheets.

To add additional sheets, you can click on the plus sign in the sheets toolbar.

One sheet will be added. To rename the sheet, click on the dropdown arrow next to the Sheet, read more

Older posts Newer posts

© 2019 Tech Tuesday Tips

Theme by Anders NorenUp ↑