U-M Google Updates

Create Custom Headers and Footers in Google Sheets

10/9/2017

Google is rolling out a new feature that allows you to customize the headers and footers in your Google Sheets with whatever text you choose. In addition, you can choose from pre-defined options (date, time, etc.) and move those elements around within your header and footer. To add custom headers and footers, choose EDIT CUSTOM FIELDS from the Print settings menu to get started.

Google is also introducing saved print settings with this feature. Modify your settings once, and they will be retained the next time you—or a collaborator—opens the spreadsheet.

The Collaboration Services Team

Tip: Did you know? You can update files on the go.
Learn more about Google at the G Suite Learning Center.

U-M Google September Summary

9/29/2017

The monthly U-M Google Summaries inform campus of Google releases for Core Apps as well as the Non-Core Apps (those that are not part of the G Suite for Education agreement). We communicate important information on Core Apps throughout the month. Core and Non-Core Apps are listed on the G Suite website.

Core Apps:

Previously Communicated:

Note: Keep in mind that even when non-core apps are found in a core app (like Google Drive), they are not covered by the G Suite for Education agreement.

The Collaboration Services Team

Tip: Did you know? You can automate responses to common messages.
Learn more about Google at the G Suite Learning Center.

 

Google Docs Newest Features Help Team Collaboration

9/27/2017

Working collaboratively on Docs, Sheets, and Slides can be difficult sometimes. Keeping track of all the changes and suggestions that your teammates make can become overwhelming. That’s why Google has created powerful real-time editing tools to help you work together better.

New Ways To Track Changes:

  • Name versions of a Doc, Sheet, or Slide on the web.
    You can organize and track your team’s changes in one place under “Version history” (formerly known as “Revision history”) on the web. Select File > Version history > Name current version. For even quicker recall, there’s an option to select “Only show named versions” in Docs, Sheets, or Slides..
  • Preview “clean versions” of Docs on the web to see what your Doc looks like without comments or suggested edits.
    Select Tools > Review suggested edits > Preview accept all or Preview reject all.
  • Accept or reject all edit suggestions at once in your Doc so your team doesn’t have to review every single punctuation mark or formatting update.
    Select Tools > Review suggested edits > Accept all or Reject all.
  • Suggest changes in a Doc from an Android, iPhone, or iPad device.
    Click the menu in the top right of your Doc screen to suggest edits on the go. Turn on the “Suggest changes” toggle and start typing.

New Ways To Use Templates:

Google has introduced new templates with built-in add-ons and the ability to create your own, so templates not only look good—but they make sure the work gets done. You can find five examples of these new templates in the general template gallery. In addition, you can create your own template with built-in add-on customized to your needs.

The Collaboration Services Team

Tip: Did you know you can restrict distribution options on sensitive Docs?
Learn more about Google at the G Suite Learning Center.

Embed Websites into the New Google Sites

9/21/2017

Google continues to add features to the new Sites app. One that was available in Classic Sites is the ability to embed another website in a Google Site. Based on feedback, Google has now added the ability to embed an entire webpage as an iframe in a new Google Site. This allows you to pull in content from other websites and Google tools like Apps Script and Data Studio. Select Embed URL from the Insert menu.

Note: This only works if that webpage allows it to be embedded. Otherwise, only a link to the webpage is inserted.

Coming Soon! Google Drive File Stream

9/13/2017

Google Drive File Stream is an upcoming desktop application that allows you to access your Google Drive directly from your computer and uses almost none of your hard disk space. With this launch, the Google Drive for Mac/PC app is officially deprecated. It will no longer be supported starting on December 11, 2017, and it will shut down completely on March 12, 2018. Accessing Drive with a web browser is not affected.

With Google Drive File Stream, you stream your Google Drive files directly from the cloud to your Mac or PC, freeing up disk space and network bandwidth. Because the Drive files are stored in the cloud, any changes you or your collaborators make are automatically updated everywhere. You’ll always have the latest version.

You can also make Drive files available for offline access. These cached files sync back to the cloud when you're online, so the latest version is available on all your devices.

  • With Drive File Stream, you can:
  • See your Google Drive files in Mac OS Finder/Windows Explorer (including Team Drives).
  • Browse and organize Google Drive files without downloading them to your computer.
  • Choose which files or folders you'd like to make available offline.
  • Open files in common apps like Microsoft Office and Adobe Photoshop.

 
After testing and evaluation by the ITS Collaboration team, Google Drive File Stream will be available in the settings  drop-down menu and will gradually roll out to campus in early October.

A couple of important things to note:

  • In October, you may start seeing messages notifying you that the Drive for Mac/PC app is going away.
  • Team Drive editors won’t be able to edit their Team Drive files when they’re opened in Drive File Stream; they’ll only be able to view them. To edit these files, you will need to open them in Drive on the web.