You might have noticed the
constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently:
- F4 - Repeat Last Action
- Insert Cut/Copied Rows and Columns
- Insert Hyperlink
Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features.
F4 - Repeat Last Action:
You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your work done quickly. For example, let us assume you select a cell range and apply a fill color. You can then select another cell range (not necessarily of the same size) and press F4 to repeat the last action, i.e., apply the fill color on the selected range.
You can repeat the following actions:
- Cell Styles
- Cell Formats
- Insert Row/Column
- Delete Row/Column
- Clear Contents
- Clear Formatting
There are multiple shortcuts for this Repeat last action functionality:
- F4
- Ctrl+Y
- Alt+Enter
F4 and Ctrl+Y work the same way. It will normally repeat the last action. However, if you do an Undo, these shortcuts will trigger a Redo action. On the other hand, Alt+Enter will always trigger a Repeat action, even if you just performed an Undo.
Insert Cut/Copied Rows and Columns:
You can now cut / copy a row or column and insert it at a different place in the same spreadsheet. This is useful when you want to move/copy columns and rows within your spreadsheet. This option is available in the right click context menu as well as the insert menu, whenever you have rows/columns cut or copied and a row/column is selected. Refer the screenshot below.
Insert Hyperlink:
We have enhanced our 'Insert Hyperlink' functionality. You can now create a hyperlink to the various parts of a spreadsheet such as a cell / a cell range / a named range / a worksheet within the same spreadsheet in addition to creating hyperlinks to web pages and email addresses.
You can insert an hyperlink into a cell in 2 ways:
1. Right click on a cell and click on the 'Hyperlink' menu item or use the shortcut Ctrl+K.
Refer the image below.
You can use the
HYPERLINK() formula to construct a dynamic hyperlink which could change itself based on data in the spreadsheet. Here is a spreadsheet with two worksheets.
The first sheet has a dynamic hyperlink pointing to the end of the spreadsheet. Check the formula in C2 to know more about how functions have been used to point to the last row in the table.
The second sheet has a dynamic link pointing to google search results of the data you enter in cell B2. Check the formula in D2 of that sheet to know more about how the HYPERLINK function has been used.
We hope you find these features useful and we believe it will help you get your work done faster. Feel free to leave your feedback and comments on this topic.
Recent Topics
Stop completed task lists from disappearing?
Is there any way to stop projects from making tasks lists disappear when all the tasks in the list are completed? That's one of those little things where we're constantly fighting the product. For instance we have some projects which are ongoing - no start and end date. We use Kanban view to show the various task lists. We don't want the kanban list to disappear every time the items on it happen to be closed out. Thanks
Set connection link name from variable in invokeurl
Hi, guys. How to set in parameter "connection" a variable, instead of a string. connectionLinkName = manager.get('connectionLinkName').toString(); response = invokeurl [ url :"https://www.googleapis.com/calendar/v3/freeBusy" type :POST parameters:requestParams.toString()
Approval Processes, Now in Standard and Professional
We encourage existing Approval Process users to switch to the new UI to access enhanced capabilities, including naming each rule and stage, setting stage-specific field updates and tasks, sending email notifications upon rejection, and tracking progress
How to restore deleted campaigns?
I accidentally deleted my first campaign that went out today (08/21/18). How do I restore it?
Zoho Inventory - Backorder Report
I am requesting a backorder report in Zoho Inventory to show all backorders by Sales Order and/or Customer, including the quantity of each line item ordered and quantity fulfilled. This is important for businesses who operate a lean business model and
Can we do Image swatches for color variants?
We want to do something like the attached screenshot on our new zoho store. We need image swatches instead of normal text selection. We want to user to select an image as color option. Is this doable? I don't see any option on zoho backend. Please h
Email-Data Synchronization with Zoho Analytics
Hello everyone, Thanks to Chad and everyone who shared their feedback. We're excited to announce support for email data synchronization with Zoho Analytics. We have been working hard to bring this highly requested feature to life, and we'd like to walk
Update on Using Extensions in Custom Modules
Extensions in Zoho Projects now support custom modules. You can add extensions to custom module records and configure where each extension appears and who can access it during installation. Supported Extensions: Checklist, Google Drive, SharePoint Configure
【初開催】Zoho Mail / Workplace 活用勉強会 |11/27オンライン・無料
ユーザーの皆さま、こんにちは。 ゾーホージャパンの中野です。 11月27日(金)、Zohoコミュニティでは初めてとなる「Zoho Mail / Workplace 活用勉強会」をオンラインで開催します! すでにZoho Mail / Workplaceをご利用中の方はもちろん、Zoho Oneをご利用中で、Zoho Mailの利用を検討している方も歓迎です。 Zoho社員が製品の概要に触れながら、具体的な利用場面に沿って活用方法をご紹介します。 ■ メール対応のミスや手間を減らす 添付忘れや誤送信の対策など、日々のメール業務に役立つ便利機能を取り上げます。
Trigger a Workflow Function if an Attachment (Related List) has been added
Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no trigger
Breaking Change Announcement: Users API Response Restricted for Client Portal Users
Hi all, We are introducing a breaking change to the Users API when it is accessed by Client Portal users. Status: Live This change is now live in production. Please review your integrations and make the necessary updates. Affected endpoints: GET /users
automatic email reminder
in need of an email reminder to participants having trained for a course but have not paid
Sharedmail box access via an api
Hi, I am trying to access a sharedmailbox via an API. I am the moderator and creator of this shared mailbox. I have created a self client but when when i try to get list of all emails, it does not list the sharedmailbox. Help me to resolve this or provide
Duplicate Record Creation
Hello Team, I would like to check whether there are any options available in Zoho FSM to prevent duplicate record creation in the following modules: Assets Companies Contacts Ideally, we would like the system to check for existing records before allowing
Hiding old CRM Contacts in Desk
I have an issue with contacts in Desk. We sync contacts from CRM with DESK and we have old contacts, eg staff members that have left businesses. The issue is when adding a ticket (most of our tickets are raised over the phone), staff sometimes pick
CC'd User Receiving Both Regular Email Chain Response & Reply Notification
Hi, I am trying to set up the notifications for users and I'm a bit confused. I'm testing with personal accounts and my Desk agent, and I'm noticing that CC'd users are receiving both the regular email chain that the requester (contact) receives, but
Default View for Email Sent
Hi, can the default view for email sent to candidates be "ALL" instead of the current user? I have to click the dropdown menu every time so that I can see if other recruiters have already sent an email to a candidate. Thanks!
KB Articles - Can't See Content or Trigger Immediate Sync
Once a file has been submitted to the KB, there's no way to check what it actually contains. There's also no way to force an immediate sync with the source document. These are issues when one is developing and testing an agent. It makes troubleshooting
Enable Screen Recording in Zoho WorkDrive Mobile Apps (Android & iOS)
Hi Zoho WorkDrive Team, How are you? We are enthusiastic Zoho One users and rely heavily on Zoho WorkDrive for internal collaboration and content sharing. The screen-recording feature in the WorkDrive web app (similar to Loom) is extremely useful- however,
Ability to Set Text Direction for Individual Cells in Zoho Sheet
Dear Zoho Sheet Team, We hope you are doing well. We would like to request an enhancement in Zoho Sheet that allows users to set the text direction (right-to-left or left-to-right) for individual cells, similar to what is available in Google Sheets. Use
Add Comprehensive Accessibility Features to Zoho Writer
Hello Zoho Writer Team, We hope you are doing well. We would like to submit a feature request to enhance Zoho Writer with a full set of accessibility tools, similar to the accessibility options already available in the Zoho Desk agent interface. 🚧 Current
Problem with currency field in Zoho CRM
Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration
Ability to Attach Images When Reporting Issues to Zoho Projects from Zoho Desk
Hi Zoho Desk Team, Hope you’re doing well. We’re using the Zoho Desk–Zoho Projects integration to report bugs directly from support tickets into the Zoho Projects issue tracker. This integration is extremely useful and helps us maintain smooth coordination
Is it possible to convert regular pick-list to multi-select pick list?
I have a regular drop-down pick-list and we realized that we need this info as a multi-select pick-list. I don't think there is a way to convert from one type to the other, but what is the simplest way of moving the data over? Meaning, whatever value
Make Camera Overlay & Recording Controls Visible in All Screen-Sharing Options
Hi Zoho WorkDrive Team, Hope you are doing well. We would like to request an improvement to the screen-recording experience in Zoho WorkDrive. Current Limitation: At the moment the recording controls are visible only inside the Zoho WorkDrive tab. When
VENDORS ARE NOT SYNCHED WITH CONTACTS IN CRM
Hello, While the ACCOUNTS and CONTACTS (Including the primary contact) are synced with the CONTACTS module in CRM, the vendor's CONTACTS are not synced with CRM - which basically forces the users to re-enter all vendor's contacts twice and then update
Properly Capture Dropdowns & Hover Elements When Recording a Window/Tab
Hi Zoho WorkDrive Team, Hope you are doing great. We encountered a limitation when recording a selected window or browser tab: Certain UI elements, such as dropdown lists, hover menus, and overlays, are not captured unless we record the entire screen.
Add Camera Background Blur During Recording
Hi Zoho WorkDrive Team, Hope everything is well. We would like to request an enhancement to the video recording feature in Zoho WorkDrive. Currently, the camera preview displayed during a recording does not support background blur. This is an essential
WorkDrive Desktop Sync Is Being Deprecated: Move to WorkDrive TrueSync for a Smarter Experience
Hi everyone, We are excited to share a better, smarter way to access and manage your files directly from your computer! We’re transitioning from our legacy Desktop Sync app to WorkDrive TrueSync, designed to give you faster performance,greater flexibility,
Support Uploading YouTube Videos Longer Than 60 Minutes
Hi Zoho Social Team, How are you? We would like to request support for uploading YouTube videos longer than 60 minutes directly through Zoho Social. Your support team informed us that Zoho Social currently cannot upload videos over 60 minutes due to “API
Caso de Éxito: ACKstorm transforma la gestión de personas con Zoho People
"Con Zoho People hemos centralizado la gestión de personas y facilitado la autonomía de la plantilla." Equipo de ACKstorm ACKstorm es una empresa especializada en consultoría y servicios cloud que trabaja con el ecosistema de Zoho para optimizar sus procesos
Zoho 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 a
Action required: Authenticate your sender domain in Zoho Marketing Automation before December 14, 2026
Starting December 14, 2026, Zoho Marketing Automation will enforce a daily sending cap for unauthenticated custom sender domains. If you're sending email campaigns from your own domain but haven't authenticated it yet, you'll only be able to send up to
Ask the Expert: Unlock the Power of AI and Zia Agents in Zoho CRM
Are you using Zoho CRM to manage your sales processes and customer relationships, and wondering how AI can help you work smarter, automate more, and take your CRM capabilities to the next level? We have great news: the “Ask the Expert” session is coming
What's new in Zoho Desk 2026 - A decade of ideas brought to life
Hello everyone, 2026 marks a special milestone for us as we celebrate 10 years of Zoho Desk. A decade into business, there is always something new to keep up with, new expectations to meet, and new ways to make customer support better. Zoho Desk continues
Manual categorisation of bank transactions
Good Day I am hoping someone here can assist me. I have a lot of catching up to do with some bank transactions. I imported all my bank statements manually. Where possible i created a rule to have the transactions auto categorised. However there are some
Idea: Upload your own letterhead and design PDF templates freely (like Lexware Office and sevDesk)
Your own letterhead on every invoice and quote, uploaded in two clicks, no HTML, no public image links. Tools like Lexware Office (formerly lexoffice) and sevDesk already offer this. Zoho Books is more powerful in almost every other way, so let's close
Sorting of invoices keeps changing
Hi there, I log into Zoho invoice around 2-3 times a week. Usually I sort my invoice list by "Date created". Every now and again when I log in, this sorting criteria has changed. It's not clear to what criteria it is changing and how/why, but I find it a little annoying not seeing the latest invoices at the top. Can you please look into this and make sure the sorting function is stored in a cookie or on the server? Thanks, Kai
Feature Request: Add Sort by Cell Color and Text Color functionality
Hello Zoho Sheet Development Team, I am writing to suggest a feature enhancement for Zoho Sheet. Currently, the platform supports "Filter by Color," which is incredibly useful. However, there is no native option to "Sort by Color" (by cell fill or text
Multi-Day Installations
We schedule technicians on multi-day installations. A single appointment from Monday 8 AM through Friday 5 PM counts as 105 working hours, causing false overbooking. We need one appointment spanning five days but only 40 hours counted toward technician
Next Page