Publish Sheet, Specific sheet sharing and Merge cells

We made an update just now in Zoho Sheet with support for the following:

- Publish sheet to enable embedding of spreadsheets in webpages
– Specific sheet sharing enables you to share individual sheets to a set of users
– Horizontal merging of cells
– Vertical alignment of cells

and some enhancements.

Publish Sheets:
This enables you to embed your interactive spreadsheets to your blog or a website page or a Zoho Writer document or a Zoho Show slide. These are up-to-date spreadsheets. Any changes in the original spreadsheet in Zoho are reflected in the published spreadsheets. Right now, the spreadsheet has to be made public to avail this feature and the public sheet will also be listed in zohosheet.com. This is subject to change on a later update.

More on embedding your spreadsheet into Zoho Writer and Zoho Show on a later post.

Share Specific Sheets:
You can now share specific sheets to specific users with specific access too. So now you can have everything related in one workbook / document and share it with your users giving appropriate permissions. You can even hide sheets you do not want to share. The default is however sharing the whole document. We have also added auto completion of email address. If you are trying to share a document to an email address to which you have already shared, it will prompt the email address as you begin to type the first few letters.

Merge cells and Vertical alignment:
We have now supported horizontal merging of cells. You can span your cell content across multiple cells horizontally. Vertical merging of cells will follow in the coming updates. And no more overlapping of cell content.

Vertical alignment is another thing that we have added in this update. Use the icons in the extended toolbar for this.

We have also made some enhancements like copying cell(s) to a bigger target range will paste the content in the whole range. Very useful if you need to copy a formula to multiple cells, in the absence of fill series. Have a look at our What’s New page for more information.

As usual, keep sending us your valuable feedback and suggestions.

Ramesh

P.S: This wordpress installation removes the iframes and hence I am currently unable to post the spreadsheet directly in our blog. I think we need to customize it.

About Ramesh

4 thoughts on “Publish Sheet, Specific sheet sharing and Merge cells”

Hi,For this, you need to make your spreadsheet public. Here is how you do it:1. After signing in, upload your spreadsheet to Zoho Sheet using the Import button or Create an online spreadsheet from scratch.2. Click on Embed to Blog/Website under the Publish menu. Note: This will make your spreadsheet public and can be viewed by anyone.3. Copy the HTML code snippet shown.4. Now go to Zoho Writer and in your document, use the Insert HTML icon to paste the embed code. Refer http://blogs.zoho.com/general/…Ramesh

Hi,For this, you need to make your spreadsheet public. Here is how you do it:1. After signing in, upload your spreadsheet to Zoho Sheet using the Import button or Create an online spreadsheet from scratch.2. Click on Embed to Blog/Website under the Publish menu. Note: This will make your spreadsheet public and can be viewed by anyone.3. Copy the HTML code snippet shown.4. Now go to Zoho Writer and in your document, use the Insert HTML icon to paste the embed code. Refer http://blogs.zoho.com/general/…Ramesh

I honestly find it a bit maddening to see posts like this, which tell us all about all the whiz-bang features, WITHOUT SHOWING US HOW TO USE THEM!!! It’s great that you can put that sheet into the Writer document. Now, how do I do that?!

I honestly find it a bit maddening to see posts like this, which tell us all about all the whiz-bang features, WITHOUT SHOWING US HOW TO USE THEM!!! It’s great that you can put that sheet into the Writer document. Now, how do I do that?!