Google has updated its spreadsheets in Google Drive.
In a >blog post, Zach Lloyd, Software Engineer, said in the new version of Sheets, “scrolling, loading and calculation are all snappier, even in more complex spreadsheets.”
The new Filter views feature in the new sheets allows users to quickly name, save and share different views of the data. This is especially useful when a team is collaborating. This feature enables the user to sort a spreadsheet without affecting how others see it.
The new version also makes it easier to set up and perform calculations. According to Zach Lloyd, “the new function help and examples guide you as you type, and error highlighting and colouring make it easy to spot and fix mistakes”.
He says the new version allows text to automatically flow into empty adjacent cells doing away with the need for manual merge.
The improved conditional formatting allows users to add rules to change the colours and styles of cells based on custom formulas.
One important update is to make the Sheets work offline. “So just like Google Docs and Slides, you can now make edits to Sheets offline. When you reconnect to the Internet, your edits will automatically sync. If you've edited Docs or Slides offline in the past, then you’re already set up to edit Sheets offline,” says Zach Lloyd.