The New Google Sheets

There's a new version of Google Sheets. "It's faster, supports larger spreadsheets, has a number of new features, and works offline," informs Google.

Just in case you're wondering how to enable it, you should go to Google Drive's settings page, enable "Try the new Google Sheets" in the Editing tab and click "Save". You'll get the new version of the application only for the files you create from now on. The existing files will still open in the old Google Sheets.

There are some missing features in the new Google Sheets (protected sheets, spell check, publishing) and this shows that this is an early release.

So what's new? You can create and edit spreadsheets offline in Chrome, just like in Docs and Slides. The new Sheets is designed with performance in mind and handles huge spreadsheets: it supports 2 million cells of data and all of the other limitations have been removed. You're no longer limited to 256 columns per sheet. Other improvements: spreadsheets load faster and scrolling is smoother.

There are some new formula editing tools. "In the new Google Sheets, we've made it easier to build complex formulas in your spreadsheets. For example, you'll now see syntax highlighting, which shows you the argument in your function that you are working on, and you'll get more details on how to fix errors in your formula by hovering over them." Google also added 24 new functions, including SUMIFS, COUNTIFS, and AVERAGEIF.

Another new feature is called filter views and it lets you create, save and share filters, so you can get different views of your data without disrupting how others are viewing your spreadsheet.

"In the new Google Sheets, you can apply conditional formatting using a custom formula. This allows you to apply formatting to a cell or range of cells based on the contents of other cells."

You can also add a color to each of your sheet tabs, paste a rotated version of the copied cells from a column to a row or from a row to a column, restrict find and replace to a range of cells and apply custom formatting for currencies, dates, and numbers.

Read More

Faster Spell Checking in Google Docs

Now it's easier to check the spelling of a Google Docs document or a Google Slides presentation. Just click the Tools menu, select Spelling and review each spelling suggestion. You can click "change", "change all", "ignore" or "add to dictionary". After performing an action, Google locates the next spelling mistake, so you don't have to manually find it.

Until now, you had to right-click each spelling mistake and select one of the options. Google Docs flags the mistakes with red underlines, so you can still fix them manually.

"The updated spell check lets you check the spelling of your entire document or presentation at once, instead of having to resolve misspellings individually," explains Google.

Read More

Google Docs Shows Link Suggestions

I've always wanted a tool that lets you highlight a text and quickly link to the top search results for that text. Now this feature is available in Google Docs and Google Slides: select some text, right-click and select "Link". Then you can pick one of top Google search results, one of your other documents or the headings/bookmarks that match the text selection.

Type something in the "link" box and Google will show results for the new text:

You can also use the keyboard shortcut (Ctrl+K) or use the link button from the toolbar.

{ via Google Drive's Google+ page }

Read More