Submit a Help Request (804) 828-2227 |

What's New In Hangouts and Sheets

March 10, 2017

Redesigned unread messages indicators in Hangouts

In Google Hangouts on desktop and Android, when you enter a conversation where there has been a lot of activity, you’ll see a "Jump to Last Read" button. This will take you to the last unread message in your chat denoted by # new messages indicator. Additionally, the "# new messages" button has been redesigned to match the new UI. Check out the screenshot below to see how this works:

Google Sheets Supports rotated text, accounting number formats, more Border styles, and Insert and delete groups of cells.

Google is introducing several enterprise-friendly features 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 want to fit more text on a single screen.

Accounting number formats

It it easier to read spreadsheets containing monetary amounts by aligning the currency symbols within them (Format > Number > Accounting). As well as improvements to the way numbers, decimal points, and repeated characters line up to make them simpler to scan and analyze.

More border styles

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

  • 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

Insert and delete groups of cells in Google Sheets

Google is making it easier to insert cells into these sheets without disturbing that content. Going forward, you can add a rectangular block of cells to any spreadsheet on the web, and it will simply shift the surrounding cells down or to the right. You can delete chunks of cells in the same way.


You can insert cells from Insert menu and delete cells from the Edit menu. Both features are also accessible when you right-click on a cell. For more information, check out the Help Center.