zoho sheet
Send Show feebacks from Slack
You can give feedback to the Show team using slash commands in Slack. Enter the slash command in the channel and you can send opinions to the team. To give feedback about Show from Slack channels: Open app Message in your Slack workspace. ...
Control a presentation from your android wear
Your android watch can be a remote for your Show slides on Tv. Quickly, pair your android phone or tablet with an android wear/smartwatch to control slides from your wrist. Swipe through your watch screen to control the slides on Tv. As you control ...
Apply a Stroke, Shadow and Reflection Effect
Make text, shapes, charts, and other objects in your presentation look more realistic and fun by applying effects such as a reflection, shadow, and stroke on Zoho Show. Further, customize and experiment with each effect to bring out the look you want ...
Delete a form from Sheet
To delete a form: 1. In the result sheet, click Tools > Manage Form > Delete Form. 2. Select OK in the dialog box that opens.
View my live form from Sheet
To view the live form:In the respective result sheet, click Tools > Manage Form > Go To Live Form.
Publish a form
To publish a form: 1. In the respective result sheet, click Tools > Manage Form > Publish > Within Organization or Publish To External. *image* 2. Click OK in the dialog box that appears. 3. You can use the given link for distributing the form.
Edit a form
To edit a form: 1. In the result sheet, click Tools > Manage Form > Edit Form. 2. Your form opens in a new tab where you can make the changes and save the form.
Create a form in Zoho Sheet
To create a form: 1. Click Tools > Create Form. 2. Enter the Form Title and Description in the Create Form window and click Create. 3. A new sheet for the form results opens. 4. In the success notification that appears, select 'Click Here'. 5. The ...
Delete Sparklines
1. Click on the Sparkline 2. Click on the Sparline icon on the contextual side panel. 3. Under the Manage heading, click on the delete icon. 4. You can choose to delete either the entire Sparkline group, or the selected one alone.
Edit Sparklines
1. Click on the Sparkline 2. Click on the Sparkline icon on the contextual side panel. 3. Alternatively, you can go to Insert, hover over Sparkline and select Edit Sparkline.
Create Sparklines
To create a sparkline - 1. Select the range of cells you want to create a Sparkline for. 2. Go to the Insert menu and select Sparkline. 3. From there, click Create Sparkline and specify the cell in which you want the Sparkline to be in the ...
What are sparklines?
Sparklines are in-cell graphs that represent a range of data. These sparklines help you quickly perceive the trend in the data. Sparklines can be further customized, on type of graph, color schemes and axes levels.
Delete a chart
To delete a chart: Click Delete found in the menu when you select a chart. Alternatively, you can select the chart and hit the Delete key.
Publish a chart
To publish a chart: Right click on the chart you want to publish, and choose Publish from the drop down. Use the code snippet you get to embed or publish your chart. You can also choose to remove the public view of the chart by ...
Save a chart as an image
To save a chart as an image: Click Advance Options > Save As Image present in the menu. The chart is saved as a Portable Network Graphics (.png) image to your device.
Aggregate elements of a chart
To aggregate elements of a chart: 1. Click on the chart. 2. Click on the Chart icon in the side panel. 3. While on the "General" tab of the side panel, click on the "Aggregation" drop down menu. 4. You can choose one of the six functions listed, ...
Change the transparency of a chart
To edit a chart: 1. Click on the chart. 2. Click on the Chart icon in the side panel. 3. Move to the "Custom" tab on the side pane. 4. Click on the "Styles" drop down menu. 5. Now change the transparency using the slider.
Change color scheme of a chart
To edit a chart: 1. Click on the chart. 2. Click on the Chart icon in the side panel. 3. Move to the "Custom" tab on the side pane. 4. Click on the "Styles" drop down menu. 5. Choose from the colour schemes provided, or create a custom style that ...
Change the title of a chart
To edit a chart's title: 1. Click on the chart. 2. Click on the Chart icon in the side panel. 3. Go to the "Customize" tab on the side panel. 4. Select "Chart Title" from the drop down menu. 5. Key-in the title you want to be displayed on the space ...
Create charts
To create a chart: Select the range for which you need a chart. Click Insert > Chart. A chart is generated to best represent the data. Click the chart to open the contextual side panel. Edit or modify the chart type, design, title, legend and color ...
Delete a pivot table
To delete a pivot table: Right click on the pivot table and click Delete, or select the table and go to Custom > Delete in the Pivot Table context menu on the right.
View the subtotal of the data in a pivot table
To view the total: 1. Click on the pivot table. 2. Go to Custom in the contextual menu on the right. 3. Turn on/off the Subtotal, Column Grand Total and Row Grand Total as per your necessity.
Change the style of a pivot table
To change the style of a pivot table: 1. Click on the pivot table. 2. The Pivot Table context menu opens on the right. 3. Select the desired Table Styles, Color Schemes and click Generate.
Move a pivot table across sheets
To move a pivot table: 1. Right click on the pivot table to be moved. 2. Select Move from the contextual menu. 3. Choose the destination sheet i.e. new sheet or an existing sheet and click OK. You can also use the side panel context menu, Custom > ...
Edit an existing pivot table
To edit a pivot table: 1. Right click on the pivot table to be edited. 2. Select Builder. 3. Make the desired changes and click Generate. Alternatively, move your selection to the Pivot table. Click on the contextual pivot table side pane, and edit ...
Create a pivot table in sheet
To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created. Drag and drop the fields into the desired positions in the Pivot Table Builder and click ...
Separate text to different columns
To change text to columns: Select the required cell or column which consists of the text you want to move to separate columns. Click Data > Text to Columns. The Text to Columns dialog box appears. 3. Choose the delimiters such as comma, space, ...
Ask questions to Zia about your data
1. Open Zia. 2. Enter your queries on the space labelled "Ask Zia" 3. In the answer, you will find the result, along with a chart or a pivot table to represent it, or the formula Zia used to get to the result. 4. You can click and drag these ...
Add the charts and pivots recommended by Zia to the spreadsheet
1. Open Zia. 2. Hover over the chart or table you want to add to your spreadsheet. 3. Click on the "+" symbol that appears near the chart or table. 4. Alternatively, you can simply click, drag and drop the charts from the side panel to your ...
Look for Zia's suggestions
1. Click on the Zia icon on the bottom right corner of the side panel 2. Edit the range to get contextually suggested charts and tables.3. Alternatively, after selecting the range, you can click on the Tools menu and select Zia
Sync live data from webpages to the spreadsheet
To link external data: Click Data > Link External Data. From the dialogue box, choose the type of data you want to link the spreadsheet to. Set the location where the external data is to be placed in the spreadsheet. By default, it is set to the ...
Correct an error in a complex data or formula
To solve faulty results and values: Click Data > Goal Seek. Enter required target cell and the cell that gives you a varying result and not the result you were expecting. 3. Both the target and variant cells should be formula cells for Goal ...
Use the solver tool
To use the solver tool, Click on the Tools menu. Select the Solver option. In the dialogue box that opens, choose the Target cell and the Variant cell. Choose to fit what condition should the answer be optimised for– To maximise or to minimise the ...
Create a data validation for cells
To create data validation: Click Data > Data Validation. You can choose the required range to apply data validation from the dialog shown below. 3. The options that are available include the following: Decimal number, ...
Recalculate values in Zoho Sheet
Click Edit > Recalculate or use the F9 key, all changes in data will be accounted for and formula cells will be updated.
Apply array formulas
To apply array formulas: Select the cells in which you want the resultant array (the result of the output formula) to be present. Type the array formula you wish to apply over the array. Like other formulas, an array formula is preceded by an ...
What are Array Formulas
Array formulas are used when a set or group of numbers are to be considered as input or output data for operators. These formulas are generally applied when the data is used in a group together.
Name a formula
To name a formula: Select the range of cells that contain the formula. Select Insert > Define Name. Enter a new name for your formula in the Add New Name data field. Click Add. You can also view the other user generated formulas that have been named ...
Use auto sum
To use auto sum: 1. Select the range of cells to be added. 2. Click the Auto Sum icon from the tool bar or use the shortcut Alt+= .
Insert a function
To insert a formula 1. Click Insert > Function. 2. Alternatively, you can select a cell, click on the Function icon on the side panel, and choose the function you'd like to add in the selected cell.3. Enter the addresses of the required cells to be ...
Next page