📜 ⬆️ ⬇️

New Spreadsheets Features

Google Docs & Spreadsheets logo
Recently, Google introduced several new interface elements for its tabular processor - Google Spreadsheets, which make it easier to lock rows and sort the columns. The new sorting panel is located between the column heading and the data; dragging the panel between the first 10 lines allows you to lock them as a heading.

Google Spreadsheets - sortbar
New panel sorting columns. © Google.

Google Spreadsheets - sortbar
The sorting panel can be dragged from 1 to 11 lines, thus blocking the lines above. © Google.
')
Another new feature is the automatic calculation of the amount when allocating several cells with digital data. The result of the calculations is located in the lower right corner and avoids the tedious input of formulas like "= SUM (A5: A8)" when analyzing data. It is worth noting that this feature brings Google product closer to the desktop Microsoft Excel.

Google Spreadsheets - sortbar
When allocating digital cells, the data is summarized. © ZDNet.

In addition, the Google Spreadsheets development team has implemented the ability to work with tables using all common browsers. Unfortunately, compatibility is not complete, but at least you can view your tables, and this is no longer a bad thing.

More details can be found here .

Source: https://habr.com/ru/post/31183/


All Articles