Exciting new functionality in Google Sheets

February 24, 2017

Google has introduced several new business-friendly functions this month that users have been asking for on the web and under 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 narrow columns, or when you simply want to fit more text on a single screen.


Accounting number formats
It’s now easier to read budgets, expense reports, and other spreadsheets containing monetary amounts by aligning the currency symbols within them (Format > Number > Accounting). Numbers, decimal points, and repeated characters also now line up in such a way that they are easier to scan and analyze.
 

More border styles
Choose from several new border styles, including varying thicknesses and the double borders that 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

For more details, check out the following Help Center articles:

Help Center: Edit and format a spreadsheet
Help Center: Format numbers in a spreadsheet
Help Center: Edit rows, columns & cells in a spreadsheet
Help Center: See and use suggested charts and analysis in a spreadsheet