Zoho Sheet Update - New sidebar, Themes, Autofill, Duplicate sheet and more

Zoho Sheet just had an update with some nice features. Here are the highlights:

Enhanced Sidebar and Batch Operations:

If you are a regular user, the immediate thing you will notice is that the sidebar, which lists your spreadsheets, has undergone some changes. It now displays an icon next to the name representing whether it is shared or public or private. There are different filtered views like “Shared by Me”, “My Public Documents”, “Last Created (10)” and “Last Modified (10)”. You can also sort the spreadsheets by Name / Created Time / Modified Time. It will remember the last selected view the next time you login.

There are various batch operations too which are quite useful – Batch export, Batch share, Batch delete, etc. Just select multiple sheets and perform actions on them using the Actions menu at the bottom.

New Theme:

Tired of the green look of Zoho Sheet? We have now added an alternative Grey Theme which can be set using the “Themes” menu at the top.

Auto-fill / Auto-suggest:

We now support Autofill in spreadsheet. Zoho Sheet will try to suggest matching words available in the same column as you type the first few characters. This is pretty useful when a column will have the same set of values repeated. It also reduces human errors during data entry. You can also right click and use the “Pick from list” menu to pick and insert values available in the current column.

Duplicate Sheet:

Duplicating a sheet in a workbook has been supported. To do so, you can right click on the sheet tab at the bottom and select “Copy This Sheet”. You can use this when you want to duplicate a sheet in a workbook keeping all the formatting and data intact. You will also notice that we have added a “Move This Sheet” option too. Previously, you can move a sheet only by dragging it.

Goto:

You can now use Ctrl+G to go to a particular cell in the current sheet. Entering the cell reference such as A32 will take you to the corresponding cell.

Enhanced Color Picker:

The color picker for the cell foreground and background color has been enhanced. Now it will remember the last applied color, so that you can reapply the same color in one click. To apply a different color, you would need to click on the drop down next to the color icon.

And many more

Two more shortcuts, Shift+Enter to go to the previous cell in the same column and Ctrl+K to insert a hyperlink, have been added. A new date format “D MMM YYYY”, which is quite useful for Genealogists, has been added upon request from our user.

We have also improved the performance of the application – mainly in loading of spreadsheets and applying formatting (like font styles) on a cell range.

Apart from this, we have fixed few issues too. Refer our What’s New page for more info.

Let us know your feedback as always.