Printing using Zoho Sheet, current sheet.
Hi all, i have just downloaded Zoho Sheet. It's good i can edit and all, but how do i use it to print out the current work i'm doing??? Thanks!page setup
hallo everyone: is there a way to have a print preview on spread sheet and change/set page margins etc.? ...and how does one ge rid of page info on the print?Spreadsheet Offline
I read about writer offline but I couldn't find anything about spreadsheet. Right now I'm using google account to have such function. Is there any possible to see something soon ?Send mail from Spreedsheet using vba
Hello, Is it possible to send mails using vba. The examples I found sends the workbook together with the mail but am looking for a solution that sends only the message without the excel sheet. I tried using the CDO object but kept getting error messages Any and/or all assistance would be greatly appreciatedPublic Publish of Zoho Sheets (Spreadsheet)
I want to publish my zoho sheet so others can view the spreadsheet without having to sign in like zoho docs. When I go to share the only options I have are to add collaborators email by email ( no thank you) or to allow check in/check out. I see no publishHow do I reference/interact with data in a linked sheet
Hello, I've linked another Zoho worksheet to my project by using the Data > Link Spreadsheet function. The sheet appears to have been successfully linked, but I have no idea how to reference or interact with the data. I've tried unsuccessfully using theTip #12: What is Version History and how is it useful? | Revise, revisit, and restore.
Online spreadsheets spare you the hassle of creating a new spreadsheet file each time you edit your data set. Collaboration, revision, discussion, and iterations all happen in the same space—so there's no real need to save data as a separate file. Here'sExtremely laggy add new row on mobile.
Anyone else experiencing this?Zoho Sheets no longer available
How come I cannot open my zoho sheets from the workdrive anymore and I have it bookmarked and it keeps saying This link is no longer valid. Please contact the owner for a new URL. I am the owner LOLmise en forme conditionnelle en VBA
Bonjour a tous et toutes, Pour commencer un grand merci car l'application est vraiment au top. Cependant je rencontre un problèmes avec la mise en forme conditionnelle classique mes règle saute très (trop) souvent. j'avais pense a les mettre en VBA,Sheets row/column size unit
I had attempted to manually change the row/column sizes. But I had clicked the [Row-Row_Hight-Custom] and the unit size was 19, I want the size of the grid to be about 11/32 inches or 8.9mm when printed. What size should i put it to do so, roughly.Add updated records of Forms in Sheet
Hi, I have integrated Zoho Form to Zoho Sheet. All the data filled in Zoho Form is automatically captured in Zoho Sheet as I click submit button. But when I update the data from all entries in Zoho form, the data is not updated in Zoho Sheet. I have toIs it possible to link to the form (with filled data) from the sheet that it populates with data?
I am using a form built from the sheet interface and using that form to save data in the sheet. I would like to be able to edit (update) a row of data and be able to clck a link to be taken to the form that was used to populate the initial data versusAdding new data to the sheet with most recent data being added to top row.
I am using a form that I built from within sheets. When the form is submitted, is it possible to have the data entered in (for example) row 2 (since row 1 is the heading) instead of being added into the next available row which should be hundreds ofusing sum not working on one sheet to add numbers from different page.
Hi. I was looking after any help what I'm doing wrong, One way what I found =070622.C35+080622.C35+090622.C35+100622.C35 Not working =SUM(C35;070622.C35;080622.C35;100622.C35) Unfortunately this also didn't add the numbers together. Any idea pleasHow to share Workbook with External user, but prohibit "Unhide" sheet
I need to programmatically create an External share link, which allows a user to enter data in cell(s) but not unhide hidden sheets. I was hoping that role_id 33 (View and Share) would do this but it's not working that way. Are the structural permissionsTip #11: Building spreadsheet dashboards 101
If skimming is the new reading, then dashboards are the new data set. People want to zero in on small slices of information, rather than pouring over a vast set of data. Provide key insights using a carefully crafted dashboard for your spreadsheet. HereHow to Save a Sheets File on Mobile Device
Just as the Title says, I can't find anywhere on the mobile app for Sheets to save a document. It doesn't seem to Autosave. Pls Advise George LeaGrouping rows and columns: Structure, summarize and simplify your spreadsheets
Sometimes, the bottom line is all that matters. With the Zoho Sheet's new grouping feature, you can create crisp summaries of voluminous data sets with cascading, multi-layered data chunks that are much easier to comprehend than a plain table. How doesAdd logo to Charts
I created this race chart https://sheet.zoho.com/sheet/publicgraphs/12037a4f0914468fafabee603ebfe3ee1651764903102143 and wanted to know if it is possible to add a logo or link on the chart so if I share it with other sites we get attribution. Thanksconditional formatting not working when applied to range of cells
I am having a problem applying a conditional formatting to a range of cells. I have 3 conditional formats. They are all Classic - Formula. The formula is one of: b3<today() b3=today() b3>today() When I apply these conditional formats to a single cellsharing with a group
I have created a group and added members to it, but I do not see where/how I can share a sheet with that group. I only get the option to share using email addresses and that has limited me to 20 users. I need to share with more than 20 users, so I wasMigrate particular row to another workbook
I need help with migrating a particular row, when the particular task is assigned to certain person within department, the task is auto added to the department HOD Ex. Task A is assigned to X, and I want the whole row to be reflected in X workbook.Kindly need a macro to lock cell after a data entry
Hi, I am not very used to Zoho VBA and actually I am not good enough to write a macro from scratch. I'm wondering if anyone would be so VERY kind as to show me the code needed for this problem : I'm trying to lock the cells automatically when data is entered. The code for Excel VBA should be like this : ActiveSheet.Unprotect ' Password:="secret" For Each cel In Target If cel.Value <> "" Then cel.Locked = True End If Next cel ActiveSheet.Protect ' Password:="secret"Conditional Formatting for cells containing duplicate values not working
Hi, I noticed today that the conditional formatting that is supposed to highlight cells containing duplicate values does not work anymore. It now highlights all cells even if there are no duplicates. This behavior changed today as far as I can tell. SeeHow to Collect minutes of various meeting into single thread
I need tips and help on how to automatically add data from various minutes of meetings, to a common single thread having all the department minutes in one place.Offline Work
I see how to work offline with Zoho writer how do I do the same with Zoho Sheet? mark18Sheet Default Font
Is is possible to set the default font and font size in Zoho Sheet ?Share a particular sheet with someone with daily changes update
I want to share particular sheet with someone, so that after a change is made, it will be auto-updated in main sheet. Yes I know I can publish it and give the link to update them, but I want that after they do changes in the shared sheet, it should alsoRegarding Automation
I need to understand, how to automate deadlines in zoho sheets so that the tab color changes as soon as deadline is passed into red, while before time makes it green and on the way keeps it yellow. Please help in this regards.Do we have auto mailer like outlook in Zoho also by using vba ? or any other option.
I want to automate mis by using auto mail from excel, do we have this facility in zoho like outlook?Inconsistent Autocomplete
Throughout my Zoho Sheet document, it seems that most of the cells will not autocomplete. If I enter information in a cell and want to add that same information to information in a cell below it, most times I will have to type the entire string of wordsNeed Deluge access rows and columns in a pivot table
Can you provide some sample code to access the rows and columns of a pivot table? I can rely on using a named range but where does one name / change name of the pivot table? Just need a little sample code to get me going in the correct direction. ThankDocs Sheets very slow?
Are Sheets always this slow? We have been testing ZOHO Sheets as a replacement to Google Docs, but we keep hitting patches of the day where it grinds to a halt. It is either really slow or it will load only a few lines from a sheet and just hang and we have to log out and back in again to get it working,.... We are experiencing it on several computers on various OS and Browsers. We are in Spain, but on 100Mbps Fibre so I don't think it is an issue on our end. Any advice or solutions? Thanks AlexConvert Hijri to Georgian Dates in Sheets
Hi, Is there a way to convert the Hijri (Islamic) dates into Georgian dates (formula, VBA ..or any)? Thanksdoesn't have shared sheet
Due to System error shared sheet doesn't show me.Retrieving user ID through VBA
Hi, is there a way to retrieve User ID who did entry on a specific cell and put it on other columns using VBA? eg. if cell A1 changed, User ID to be added in cell B1 Thanks,Tip #9: 5 common spreadsheet errors and how to solve them
Functions can help you automate your calculations and pull important insights from your data set. However, if something goes wrong with these functions, errors occur and make your spreadsheet less reliable. These errors usually have a cascading effect,Retrieve Username in VBA
In Excel I can utilize the username of the individual logged into the computer with Environ("Username"), is there any similar function in Zoho sheets so I can retrieve the name of the individual logged into Zoho? Thanks JonUse of Combobox in worksheet.
Combo box is very useful for set cell value from some choice. So, please Give some solution.. and thanks for your replay.Next Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfCopy across spreadsheets in Zoho Sheet
Now, you can copy your sheets to other spreadsheets or create a new spreadsheet with them. Not just sheets, copy a cell/range and paste it on any spreadsheet with formats and formulas unchanged. Copy cells/ranges Copy cells/ranges to same/different spreadsheets using Copy & Paste options, or Ctrl+C and Ctrl+V shortcuts. Copy sheet To the same spreadsheet The feature for creating a copy of a sheet in the same spreadsheet is now available as 'Duplicate'. Into a new spreadsheet Want to start a new spreadsheetRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #19 - Create checkbox tracker in your spreadsheet
Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sampleTip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
Most Discussed Topics
Does Zoho Sheet "Save as PDF" support Thai font?
Hi I want to download Zoho sheet as PDF Document. In the preview it looking good but when I dowload it the font is look different. I use "Cordia New" but the result look like it swtich to "calibri". I try to use "Print" then select printing destination
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Create and save user-specific filter views with Zoho Sheet
The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file. Collaborate with user specific filters Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. IfRevamped Print in Zoho Sheet—customized for paper
The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper. Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements thatSlicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format