What's New

Color Scales in Zoho Sheet.

Choose a range of cells and select 'Color Scales' from 'Conditional Formatting' under 'Format'. Select the color for minimum and maximum values (in case of 2-Color Scales) and midpoint (for 3-Color Scales). Watch your data transform into colors. In for some quick colors? Choose from the predefined styles. Get to see the preview of the style you choose.

Color Scales in Zoho Sheet comes with two interesting features to improve your formatting experience.

• Hide cell content - If colors can completely visualize your data, choose this option and let go of numbers.
• Automatic text color - In case you hold on to numbers, choosing this option makes sure that you see them irrespective of the background color you choose for 'Color Scale'.

What's changed with the 'Classic' Conditional Formatting?

• Predefined styles to let you choose 'formats' straightaway.
• More number of rules - Apply up to '10' rules at a time and any number, in multiple attempts.
• Add a rule to multiple ranges now. Separate ranges using "," or ";".
• All the formats applied in a rule can be cleared with the click of a single button.

Manage Rules:

Manage your Conditional Formatting rules, both 'Classic' and 'Color Scales' from the 'Manage Rules' dialog box.

• Filter rules based on sheet, cell range or whole document as well as based on the type of rule - Classic/Color Scales.
• Reorder rules with ease. Just drag and drop to reorder and set priorities. First rule is applied first.
• Edit rules simply by double clicking on them. Edit ranges too along with condition and styles.
• The info icon lets you know what's inside a 'Color Scales'.

Want to remove all Conditional Formatting? Just select the area and click on 'Clear rules'.

Your helpmate for effective evaluation.

Often it's hard to decide on the chart type that works best for a set of data. Zoho Sheet makes it easy for you by recommending suitable charts for your data.

Creating 'same' and 'similar' charts.

Clone charts and tweak them to create different chart types that represent the same data. Struggling to reprise the perfect chart style you had achieved in another spreadsheet? Strain no more. Just copy-paste the styles to any chart and make it reflect your best style. Repeat the same within spreadsheets for a consistent style.

Find the right place for your charts.

Put an end to recreating or repeating charts with the same data range. It takes just one 'move' to relocate your chart within a spreadsheet. In case you want the same chart in two different sheets, clone and move it, swiftly.

Get charts done, even before you know it.

Copy cell/range/sheet across spreadsheets

Copy a sheet and paste it in different spreadsheets. In the source spreadsheet, right click on the sheet you wish to copy and choose 'Copy $sheet_name$' option in the 'Copy' menu. Time to copy and organize sheets with ease.

You can also copy cells/ranges across spreadsheets by using the context menu or through keyboard shortcuts i.e. Ctrl+C for copy and Ctrl+V for paste. 'Paste' functions without any limitation as formulas and formats are preserved during the process.

Note:

• Creating a copy of a sheet within the spreadsheet has now been retained as "Duplicate".
• Zoho Sheet provides option to copy sheet along with reference sheets*.

*References include formulas, charts, data validations, named ranges etc.

Let's have a look at how the new update can be useful to you:

• Make your charts, plots, series and grids more colorful than before.
• Apply a range of fonts, colors, and size to chart titles, subtitles, legends, axis labels and titles.
• Edit the axis' minimum, maximum and interval values in a jiffy.
• Add transparency to create charts with multiple shades of any color. Transparent charts allow you to view and change data without moving them.
• Now, group mutilevel axis labels for better data visualization and evaluation.

With the 'View' and 'Edit' modes prevent unintended changes in your chart. Not happy with your editing? Right click on the chart and choose 'Reset styles' to get back to the original.

Start a discussion by selecting a cell or a range of cells and choose "Comment" under the review tab.

Feature highlights:

• Comments can be made on a single cell or on a range of cells.
• Start any number of comments from a particular cell/range.
• @mention collaborators to address and notify them directly.
• Emojis, links, email-ids, cell references and named ranges are automatically recognized.
• Resolve comments and make sure that a particular case has been addressed.
• Track comments through filtered views and highlight comment options.
• Track comments directly through comment specific links.
• Shortcuts and navigation keys
  • Add comment - Cmd/Ctrl+Alt+M or choose "Add comment" from context menu
  • Reply - Select comment and press 'R'
  • Ctrl/Cmd+Enter - to submit comment
  • Right & left arrow keys to toggle between comments
  • Up & down arrow keys to scroll.
• Like comments to show your support.
• A new share privilege - Read/Comment only, to allow users collaborate in the spreadsheet without altering its content.

The collaborators are notified of the changes when they open the spreadsheet. They also receive notifications in mail based on their notification settings. Set your notification preference from 'Notification settings' under comment tab.

The versatile 'Checkbox'

Once the Checkbox is clicked, the information can be captured and used, allowing formulas and functions to be built around it. This flexibility makes it a cool feature which can be employed from creating a checklist to performing complex functions, based on True/False parameters.

Add Checkbox to your spreadsheet

Adding a Checkbox in Zoho Sheet is easy unlike other spreadsheet software. Just select the cell/range where you would like to insert a Checkbox and find the option under Input Controls in Format tab.

Checkbox is the first of Input Controls. So, keep watching this space, we have more Input controls to follow.

Trendlines

Most business analyses are built on the assumption of "data trends". Trendlines serve as an important tool for identifying these trends and to analyze the problems associated with prediction (regression analysis). In order to help you with your analysis, Zoho Sheet has come up with trendlines in Bar, Column, Line, Spline, Area, Scatter and Time Series Charts. The enhancement offers new trendline types as well. Now you can analyze your data better with Power or Moving Average trendlines, in addition to Linear, Exponential, Logarithmic or Polynomial trendlines.

Auto-detect data ranges

Creating a Chart in Zoho Sheet is easier than ever. You no longer have to deal with problems from selecting large data ranges for creating Charts. Just click a cell in the data range from which you want to create a Chart and Zoho Sheet accurately detects the range. The data range can also be manually changed from the resulting "Add Chart" dialog box.

Auto-expansion of data range

The product's sophistication does not end with detecting data ranges; Zoho Sheet makes sure that you don't have to create a new Chart every time you append data to the previous range. Now, Zoho Sheet expands your chart automatically with further addition of data to its data range.

Go ahead and try these features on the web with Zoho Sheet and make the most out of your data.

Zoho Sheet supports the following File formats: .xls, .xlsx, .xlsm, .sxc, .ods, .csv, .tsv

You can write to support@zohosheet.com with your feedback.

The simple "Drag and Drop Builder" allows you to create a form quickly.

Entering data spanning a long range of cells can be time consuming. Forms in Zoho Sheet helps you hop through this error-prone zone with ease. Just supply the form with values and watch it get populated into the sheet in real time.

The Form feature also enables you to perform sophisticated actions, such as configuring Rules for fields or changing the Field properties of your Form elements. While ‘Forms’ caters to data in simpler formats, its integration into spreadsheet gives you the advantage of performing complex calculations on your data, thanks to the processing capabilities of 'Zoho Sheet’.

Last but not least, the most intriguing feature of Forms in Zoho Sheet is that it can be published. Share it inside your organization, or with the public via a link, or as an embed on your website. Present it to a larger audience!

In a nutshell, the integration not only makes data capturing easy, but makes sure all your data stays in a single place so it is ready to use anywhere, anytime.

Here is what you get with the new Pivot Table in addition to what was already available:

• Sleek and intuitive user interface
• Apply different styles to suit your theme
• Support for more than one column field
• A Pivot Table can be in a new worksheet or can reside in an existing worksheet
• A worksheet can contain multiple pivot tables.
• Sort and Filter the Pivot Table based on the row/column fields
• Refer to cells of a Pivot Table in a formula
• Draw charts on top of a Pivot Table
• Print Pivot Tables as part of the spreadsheet

Important Note:

If you have the old Pivot Tables on your existing spreadsheets, then do migrate to the new Pivot Tables by October 15th 2015.

Try the new Pivot Tables that is available under the Data tab and share your feedback by writing to us at support@zohosheet.com.

We have also introduced trendlines within scatter charts. These are lines that are capable of predicting the trends or changes of datapoints over the x-axis variable. The trendlines could be linear, exponential, logarithmic or polynomial. They help you create a prediction as to how your data will fit under these mathematical models.

Threshold features for line charts have also been updated. Once you set the threshold value for a specific line chart, the portion of the chart below the threshold gets highlighted and that helps in distinguishing the part of the chart that is to be analyzed specifically.

Please write to us at support@zohosheet.com to let us know of your feedback.

You can zoom in and zoom out of charts, scaling up and down as you please to get a clear picture of your data. You can preview your chart before creating it ensuring that you get exactly what you want. The number of types that are supported have been increased including charting in 3D, Spline Charts, Timeline Charts, Combination Charts and Waterfall Charts. You can make use of the different types of charts available to visualize data as you wish. Charts can now be created in an intricately detailed manner using additions like Sub Titles, Slant, Stagger and Gridlines.

We hope you enjoy using our latest revamp to charts and interacting with data.

Refer our forums for more help with Lock Cells. Write to us at support@zohosheet.com to let us know your feedback.      

Formula Reference Toggling

To satisfy the advanced user in you, we have released toggling features that will let you work with your formulas and functions as you please. When you use cell addresses or ranges in your functions and formulas, toggle between absolute and relative references to them at your ease using the function key F4. Use Command and the corresponding number (Command+1) for that range to navigate to that respective range. Use Option+Tab to move forward and Option+Shift+Tab to move back within ranges. These features will help you calculate and compute instantaneously while working with numbers and accounts.

Do write back to us at support@zohosheet.com to let us know what you think of the recent features released. You can also read more about our features on our forums.

Collaborator Presence

We have also revamped our Collaborator Panel to help you discuss and share your work better. The Collaborator Panel now displays the activities of users present in the sheet. You can check on which cell your collaborator is present in or which cell he is editing right from the panel. You can share links within the group chat window to your collaborators to get your work done quickly. Clicking on the name of the collaborator also lets you know where he is currently present in the spreadsheet.

We hope you enjoy using these features while collaborating.

You can avail Data Validation from Data tab in the toolbar. It lets you set conditions to restrict the range of your input data, thereby helping you weed out incorrect entries. If your entries are numbers, then you can use data validation in such a way that numbers are greater than or lesser than a particular number. Your entry could be text based, in which case you can set up a list from which the required text can be chosen.

Data Validation is also capable of validating the date and time being entered into the sheet. If you choose a date range that's not within the specified period of time, then data validation rejects the particular entry. It also lets you set a message box in which you can display the limit that has been set to be validated within that particular cell. That way, the user is alerted that he has to enter data that is correct. We believe that the feature is a great addition to the already existing features and it'll help you collaborate better with your mates.

Refer our forums for more help with this feature.

Copy to Clipboard

Cells copied from Zoho Sheet will now retain its format when pasted elsewhere.

The feature "Copy to Clipboard" lets you copy the cells in their original format to a mail that you're about to send or a document that needs it as a table. There will be no change to the formatting you had done in the original Zoho Sheet page, saving you the trouble of formatting your content all over again. Any kind of formatting that has been done in Zoho Sheet including cell color, background color and font style will be copied. We hope this feature that has been released helps you in sharing your tables from Zoho Sheet to other applications with ease.

Filter Improvements

Auto Filter functionality has been enhanced. You can now additionally filter by cell color or text color. Because of these additional options, we have also redesigned the Filter interface and have made it more compact. You could now right click on a cell and then add/apply a Filter based on the cell value, cell color or text color. You could also reapply the filter after making edits or clear the filter. These options are also available in the Filter submenu on the toolbar as well.

Range Selector Component

Ranges can now be selected easily in our dialogs. You would see an icon placed next to the text field that asks for a cell / range. Clicking on that icon will collapse the dialog to a small size with just the input for the range. You could select the desired range in your spreadsheet and then press the icon again or hit enter to return to the dialog.

Refer our forums for more help with these features.

Save to Folder

To save a file to an existing folder, hover your mouse over the file name field at the top and click on the Folder icon that appears. This will open a pop-up that lists your folder tree. Select the target folder and hit Done. You can now rename the file inline by directly clicking on the name of the file displayed at the top. This feature makes use of the folder management capabilities of Zoho Docs and lets you avail that within the spreadsheet editor.

Audit Trail

'Audit Trail' functionality has been introduced. It is available from the 'Review' tab. Using Audit Trail, you can view the recent 1000 edits that have been done on the spreadsheet. You can see what was changed and by whom. Each edit in this listing has a link to the affected range and clicking on it will take you to that range in that particular version. You can filter these edits by user or by date or by worksheet/range giving you more control of your spreadsheet.

These features help you to know how the spreadsheet was edited since it was created, thereby helping you to track down all the changes made to the spreadsheet.

Refer our forums for more help with these features.

Tab Colors

You can now add color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. To use this functionality, right click on a worksheet tab, choose 'Tab Color' and set a color of your choice.

To learn more about other features from Zoho Sheet released earlier, follow this link.