We’re working hard to ensure that Google Sheets meets your business needs. As part of that effort, today we’re introducing several enterprise-friendly features that you’ve been asking for in Sheets on the web, Android, and iOS:
Rotated text You can now rotate the text in a cell in Sheets (Format > Text rotation). This is especially useful when you need to fit long header names into thin columns, or when you simply want to fit more text on a single screen.
Accounting number formats We’re making it easier to read your budgets, expense reports, and other spreadsheets containing monetary amounts by aligning the currency symbols within them (Format > Number > Accounting). We’re also making improvements to the way numbers, decimal points, and repeated characters line up to make them simpler to scan and analyze.
More border styles You can now choose from several new border styles in Sheets, including various thicknesses and double borders, which are commonly used in financial statements like balance sheets (Toolbar > Borders > Border styles).
Additional improvements on mobile In addition to the features described above, we’re also launching the following improvements to our mobile apps:
Support for using a mouse with the Sheets Android app
Ability to view and select existing custom colors in the Sheets Android app
Ability to drag and drop rows and columns in the Sheets Android and iOS apps
Formatting suggestions in Explore in the Sheets iOS app
For more details, check out the Help Center articles below.
Launch Details Release track: Launching to both Rapid release and Scheduled release
All mobile features
Additional border styles on the web
Launching to Rapid release, with Scheduled release coming on March 6, 2017
Rotated text on the web
Accounting number formats on the web
Editions: Available to all G Suite editions
Rollout pace: Gradual rollout (potentially longer than 3 days for feature visibility)
Because it can be difficult to navigate large and complex spreadsheets, we’re introducing the ability to link to specific cell ranges in Google Sheets on the web.
With this new functionality, you can create a “table of contents” for your spreadsheet, direct others to specific content within your spreadsheet, and retain links to cells when you import spreadsheets from other applications.
To link to cells in your spreadsheet, simply go to "Insert link" > "Select a range of cells to link" and type or highlight the desired range. For more details, visit the Help Center.
Launch Details Release track: Launching to Rapid release, with Scheduled release coming on February 21st, 2017
Starting today, you can insert and play your Google Drive videos in Google Slides, in addition to videos from YouTube.
Once you’ve added a Drive video to your presentation, you can choose when to start and end it, whether it should autoplay when presenting, and whether it should be muted or play with audio. Simply right-click on the video and select Video options.
If a person viewing your presentation doesn’t have permission to view a video embedded within it, they’ll be prompted to request access.
Note that while you can play Drive videos in Slides on the web and mobile, you can only insert them from the web application. For more details, visit the Help Center.
Today, we’re making it easier for users to create files from templates by granting access to templates directly from Drive. Instead of navigating to the Docs, Sheets, Slides, or Forms home pages, you can simply go to Drive > New > Google Docs/Sheets/Slides/Forms > From a template. From there, you’ll be directed to the applicable template gallery, where you can select the template of your choice.
Last year, we made scheduling meetings smarter in Google Calendar for Androidand iPhoneby enabling them to find time for meetings and book rooms. Today, we're happy to announce that room suggestions and showing guests' time zones are coming to Google Calendar on the web. Room suggestions When you create meetings, Calendar will suggest rooms based on your and your guests' previously used rooms. You can continue to browse or search for rooms as you do today.
Guest time zones Finding time to collaborate across time zones is now easier with Google Calendar. The "Find a time" tab shows the time of the meeting in the time zone of each guest – if they are different. You can can learn more about sharing calendars and time zones here.
We have more scheduling improvements planned for 2017 including better ways to help you manage calendar resources. Stay tuned!
Launch Details Release track: Launching to Rapid release, with Scheduled release coming in 2 weeks Editions: Available to all G Suite editions Rollout pace: Gradual rollout (potentially longer than 3 days for feature visibility) Impact: All end users Action: Change management suggested/FYI
Saving YouTube Videos as a file
0k - Oct 6, 2010, 1:54 PM by James Hatz (v1)
Sometimes you may wish to save a youtube video for use in another program or at a computer without Internet access. This document explains how.
30k - Oct 6, 2010, 9:00 AM by James Hatz (v1)
Template to import students into Moodle