New Google Sheets: Faster, More Powerful and Work Offline

Google offers everyone to switch to the new version of Google Sheets, it adds several useful features that users have been asking for a long time.



First, the maximum size of documents is increased to several million lines. Loading tables, scrolling and computing speed - all this has become faster.



In addition, the tables now work in offline mode ( in Chrome ), many calculations, including calculations in formulas, are transferred to the client side.

')

New features

1. Filters . Information can be sorted by some parameter, and all unnecessary temporarily out of sight. In this form, the document is shown only to a specific user. All others who watch the document will continue to work with him as usual.







Filters can be saved for future reuse.







2. Hint for formulas with syntax highlighting and information when you hover the mouse.







3. Simplified merging cells and text alignment . If the text does not fit in the cell during typing, it is automatically transferred to the next cell. The feature is enabled by default, but you can disable it.







In addition, color tabs for documents, custom formats for dates, currencies, numbers , copy-paste tables into rows and rows into tables (paste transpose), cell formatting depending on conditions , search with replacement, and much more, appeared in the new tables.