如何在多个EXCEL表页中查找文字
我有一个EXCEL表格,里面有40多张sheet表页 每张表面里都有不同的文字和金额,如果我想找例如651660这个金额 怎样做可以在整个EXCEL表格里一次完成查找,而不用每一张表页单独翻一篇一篇查找呀???
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
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 Bigin?
Topic Participants
ericlin168
Sticky Posts
Slicers 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 FormatFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,Introducing Data Bars: Graphically represent changes in data within the cells
Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient methodZia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes
Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Custom Button in Shipments
Custom buttons feature is very much needed in shipments. Please work on this feature request!Zoho mail is logging me out almost every day ?
Yes I have clicked the Remember Me option. Yet I need to login again every 1 - 2 days, sometimes multiple times per day. The saved credential does not persist. Using fairly clean Chrome.Asap Widget 2.0
Where's the documentation for the new ASAP widget? https://www.zoho.com/desk/developers/asap/#introduction this one is outdated How can we dynamically navigate between different views? How can we prefill ticket forms using ASAP 2.0?DataPrep Bigquery Connection failed
Hello everybody, I want to create a connnection beetwen Bigquery and Dataprep but when I try to connect my project I got this error Loading tables has failed. Table list fetched from the data source expired.Can I add Conditional merge tags on my Templates?
Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letterOrganization-Tiered Support in Zoho Corp Help Center
Dear Zoho Team, Greetings! As the focal point for all Zoho-related matters in our organization, we would like to request the implementation of an organization-tiered support structure in the Zoho Corp Help Center (Zoho's internal Zoho Desk). This featureHTTP Error 500 when creating E-Mail Draft with API
Hi, I tried to create an email draft for a ticket using the Zoho Desk API (v1); however, I continuously receive HTTP Error 500: An internal server error occurred while performing this operation. I've tried both curl and Python implementations, but neitherRecording overpayment?
So a customer just overpaid me and how do I record this? I can't enter an amount that is higher than the invoice amount. Eg. Invoice is $195 and he sent $200. He's a reccuring customer so is there a way to record so that he has a $5 advance for future invoice?Function #10: Update item prices automatically based on the last transaction created
In businesses, item prices are not always fixed and can fluctuate due to various factors. If you find yourself manually adjusting the item rates every time they change, we have the ideal time-saving solution for you. In today's post, we bring you customCalculate BMI
Hello, Could you please help me with the following calculation: Height registration is in feet & inches. Weight registration is in pounds & LBS. I want to calculate the BMI for example: //Calculate pounds dec = row.Today_s_Weight_st_lbs.toDecimal() * 100; num = row.Today_s_Weight_st_lbs.toLong() * 14; pounds = (dec + num); //Calculate inches dec1 = X.Height_ft_ins.toDecimal() * 100; num1 = X.Height_ft_ins.toLong() * 12; inches = (num1 + dec1); //BMI Calculation row.BMI = (pounds * 0.45) / ((inchesZoho Recruit - Blueprint and ZIA
If I activate the Blueprint for Jobs in Zoho Recruit, Zia disappears for matching canddiates, why is that?E-mails duplicados
Ao enviar e-mails, uma das contas de nossos usuários, mostra dois e-mails enviados iguais. Como faço para exibir somente um e-mail enviado? Obrigado,Zoho email setup in office365
When i am trying to setup zoho mail setup using my domain in office365 and it is not working and it says that we couldn't log on to the incoming (IMAP) server and please check your email address and password and try again. I was able to login using myZoho Creator - Install app from Gallery takes too long
I'm trying to install the 'Volunteer Portal' from the app Gallery of Zoho Creator. It has been busy installing the app for over 2 hours now. It might be okay, but how long is something like that supposed to take? I never installed anything from that GalleryWhy Trident?
Maybe a strange question, but I was wondering why Trident is being developed. It looks fine and is working better and better, but I can't see what you want to achieve what isn't already in Zoho Mail? Zoho mail is already an (webbased I suppose) app thatEmail não baixa nem anexa arquivos
Boa tarde. Não consigo baixar, visualizar nem anexar arquivos no e-mail Zoho. Já baixei a permissão para o Chrome, mas não adiantou. Tentamos no Windows 7 e 10, e mesmo assim não baixa nada. Somente pelo app do celular consigo baixar. O que posso fazer?Email zoho não baixa nem anexa arquivos
Não consigo baixar, visualizar nem anexar arquivos no e-mail Zoho. Já baixei a permissão para o Chrome, mas não adiantou. Não baixa nada. Somente pelo app do celular consigo baixar. :(Problem adding emails to my account / Email Address already exists or associated in another Organisation
Hello, I am trying to create 3 emails that I previously deleted, but it gives me the message that you see on the screen below, I tried to write to support but I still have no response, what else can I do?"Processing"
Hi, All emails outgoing are showing "processing", any issues? ThanksFor each loop with available time slots
I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:Auto forward after moving email from spam to inbox
Auto forward is generally working fine, however it does not forward mails landed in the spam folder. I can move important mails from spam back to inbox, is it possible to automatically forward them once they are in inbox? Obviously I can manually forwardSelect CRM Custom Module in Zoho Creator
I have a custom module added in Zoho CRM that I would like to link in Zoho creator. When I add the Zoho CRM field it does not show the new module. Is this possible? Do i need to change something in CRM to make it accesible in Creator?Projects Task List Bars not Showing
Im in my Projects template and the grey bar for the Task Lists is not showing and the tasks cannot join to it. I have it open in a job and it works. Anyone know why its not showing in the template?Restriction in assigning signer fields for the "Approver" role in APIs and internal integrations
Hi, Zoho Sign's intended design is offering two actions to the recipient - Needs to sign (if you wish your recipient to add information to the document; signature, for instance) or Approver (someone who has to approve the content of the document and mustSearching Notes & Attachments
Is it possible to have the search in CRM search the Notes and Attachments for key wordsno me llegan los correos a Zoho mail
No puedo recibir correos pero sí enviarlos, ya hice la modificación de MX y la verificación de teléfonos, qué es lo que ocurre? gracias553 Relaying disallowed SMTP Error: data not accepted
I am configuring my website to use my zoho mail for my contact form. I am using phpmailer but this exits with the following error: SMTP ERROR: DATA END command failed: 553 Relaying disallowed SMTP Error: data not accepted. Mailer Error: SMTP Error: dataRebrand your CRM with the all-new custom domain mapping setup
UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elated'Find duplicates using :'
I just discovered (and thought I would share) that you can import candidates to Zoho Recruit and define the field you want to use to find duplicates. I have used the email address all this time. But I think a better field to find duplicates is a contact'sChart View group X-axis values above a value
I have a data set with X values ranging from 0 up to 300-400, the Y values are an AVG of the values for the given X. I am interested in the values at the low end of the scale, say 0-10 and want the X values 10 and greater to be grouped into a single categoryTerritory management and roles hierarchy
Hi everyone, we are facing a problem with territory management. Our roles hierarchy is quite simple: - Area sales managers - Sales executives (reporting to Area sales managers) - Backoffice "Sales executives" can see only accounts/contacts/etc based onDataPrep Bigquery Connection failed
Hello everybody, I want to create a connnection beetwen Bigquery and Dataprep but when I try to connect my project I got this error Loading tables has failed. Table list fetched from the data source expired.Can Send Emails But I am not Receiving emails in Zoho Account
Hello, I have configured a Zoho email account for the domain pentexqatar.com and I can send emails but am not receiving any emails in Zoho account. can I please let me know what could be the issues? Thank YouDisable Multiple Submissions by same Employee
Dear All, I am creating a form to be filled by employees. Is it possible to restrict submission of the form if that employee has already submitted it once?Whatsapp Notification For Cliq
We have integrated WhatsApp Business into Zoho CRM, and messages are coming through to the CRM. However, I want a notification message to be sent to the data owner in Cliq when a new message arrives. This doesn't seem possible through rules. Is thereZoho Books Sandbox environment
Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need aPrefill Zoho Bookings form fields when using 'Email Booking URL' button in Zoho CRM
I'm utilizing the 'Email Booking URL' button in Zoho CRM, linked to the 'Contacts' module. After the contact sets the meeting details and receives the email, I want the Zoho Bookings form to automatically pre-fill with their information (name, email,Call Counter
For context, our Leads Page is configured with three separate phone number fields. This allows us to store multiple contact numbers for each lead. We've also integrated a click-to-dial feature in our CRM system, which enables us to make calls directlyPower of Automation :: Incorporate your desired tasklist into a new project automatically
Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automateHow to delete Inactive users?
We want to delete inactive users from our system, but went you deactivate still the names are shown at the inactive section. How to get really rid off these names? Thanks for your response! Fabian van den BarselaarNext Page