New Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink

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:

1. F4 - Repeat Last Action
2. Insert Cut/Copied Rows and Columns
3. 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.

2. Use the HYPERLINK() formula.

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.

• Topic Participants

• Ramesh Sripathy

  

• MADHUSUDAN SHARMA

• Sticky Posts

• Introducing a smarter, faster, and more flexible charting experience

  Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you to

• What's new in Zoho Sheet: Simplify data entry and collaboration

  Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally

• New Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink

  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

• Introducing Forms in Zoho Sheet

  We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you

• 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,

• Recent Topics

• Stock Based Sort-by option in Category Pages

  In a category page product with In-Stock should come in the top of the categories product list rather than out-of-stock products. No having this option is extremely disappointing, I made the initial request about 7 months ago but still not even an update

• Stock based sort-by option

  I have more than 300 products in a category with out of stock items count of 150. The out of stock items are coming on top of the category product page list, is there a way to show the in-stock items on top of the list & move the out -of stock items in

• Out of Stock items showing in Commerce

  I have over 6000 items and most are not in stock, but all items are showing up in Commerce whether they are inventory or not. What option or feature can you use to hide items in Commerce at zero or negative quantities? I currently am using Commerce for

• Creating Email template that attaches file uploaded in specific field.

  If there's a way to do this using Zoho CRM's built-in features, then this has eluded me! I'm looking to create a workflow that automatically sends an email upon execution, and that email includes an attachment uploaded in a specific field. Email templates

• What's New in Zoho Billing | July 2026

  July brings a new set of updates to Zoho Billing to make your billing operations more efficient. These include a redesigned checkout experience, expanded Hosted Payment Page capabilities, compliance improvements, enhanced reporting, and more. Enhancements

• Zoho CRM Community Digest - July 2026 | Part 1

  Hello everyone, July is here! The first two weeks brought six CRM updates ranging from privacy-ready webforms to a significantly more powerful Layout Rules engine, two community wins worth a look (a dashboard workaround for spotting leads with no activities,

• Zoho CRM - Email/Message icon for Deal List View

  Hi Team, My idea is to include a message icon at the start of the row of Deals when an unread message has been received. This would really help highlight the Deals where urgent action is required. Thanks for considering this request. Regards, Ashley

• Email notification for followers

  Is there a way to enable email notification for followers of a support ticket? ie: Ticket #123 is owned by Agent#1, Agent#2 adds themselves as a follower. Whenever ticket #123 receives an email from the customer, Agent#1 receives an email. Agent#2 would

• Introducing parent-child ticketing in Zoho Desk [Early access]

  Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child

• Desk Contact Name > split to First and Last name

  I am new to Zoho and while setting up the Desk and Help Center, I saw that new tickets created or submitted from the Help Center used the Contact Name field. This would create a new Contact but put the person's name in the Last Name field only. The First

• Vendor payment unexpectedly routed through Prepaid Expenses instead of Accounts Payable

  Hello, We are investigating an unexpected accounting behavior in Zoho Books. We created vendor bills and vendor payments for two suppliers using what appears to be the same workflow, but the journal entries are different. Vendor 1 – UZ Store (works correctly)

• Dashboard Metric Drill-Down Shows Stale Data

  Summary: When clicking between different metric components on a custom dashboard, the drill-down list shows data from the previously opened metric instead of the one just clicked. Steps to Reproduce: Create a custom dashboard with multiple pre-defined/templatized

• Managing Shopify Payout Balances in Zoho Books

  I am recording my Shopify orders as Invoices and once Shopify credits my bank account I reconcile the payout to the specific invoices and create a new transaction to account for the Shopify Merchant Fee. That is fairly straightforward to me. How should

• Charging for WhatsApp replies starting in October 2026

  Meta has announced that it will charge for reply messages on WhatsApp starting October 1, 2026, and the free 24-hour window will no longer exist. How will Zoho SalesIQ handle this billing? https://developers.facebook.com/documentation/business-messa

• Upcoming Change: Increased character limits for module and field labels

  To provide greater flexibility in customizing your CRM, we are increasing the maximum character limits for module labels and field labels in Zoho CRM. What's changing? Label Current Limit New Limit Module Label 25 characters 50 characters Subform Module

• Change of Blog Author

  Hi, I am creating the blog post on behalf of my colleague. When I publish the post, it is showing my name as author of the post which is not intended and needs to be changed to my colleague's name. How can I change the name of the author in the blogs?? Thanks, Ramanan

• Q3 USA ZUG Meetups - Build AI Agents with Zoho

  Hi everyone! What if you could build your own AI agent from scratch in just one session? That's exactly what we're going to do at the upcoming ZUG Meetups across the United States, where you'll get hands-on experience with Zia Agents and explore how AI

• SPAM (and some other) folders missing on three of my Zoho Mail accounts

  I have four email accounts with Zoho Mail. Three days ago, the Spam folder on three of these accounts vanished. It is gone on the Windows and Linux desktops as well as the web-based and Android versions, and I have tried it on multiple machines. The only

• Using data from multiple sheets

  I am looking for a way to automate the process of taking multiple Zoho sheets and collating the data into one combined sheet (such that no duplicates occur). Currently I can only think of importing all the sheets into Excel and then running a macro to perform the task. Is there a simpler way offered by Zoho?

• Error 1011 saving website personalisation — blocking all changes (corrupted "home_page.content" field)

  When trying to save changes under Settings → Brands → MY COMPANY → Website → Personalisation → Messenger, I receive the following error: "Either the request parameters are invalid or absent" upon checking on the developer console of the browser I get

• Tip #7 - Siri shortcuts in Zoho CRM

  Hello Everyone, Here is a tip about the 'Siri Shortcuts' feature and how it works in the iOS version of the Zoho CRM mobile app. What are Siri shortcuts? Siri Shortcuts are quick actions across your apps on iOS. They can perform an action automatically

• Delete Field that is used in a Zoho Flow connection

  I'm trying to delete a Field used in a Webhook created by Zoho Flow with CRM Connection and i get the following alert: When going to the alert i get to the following issue, can't edit it since its been deployed by a pluggin But yes i have here the prompted

• Automatic Department and Employee Sync Between Zoho One and Zoho People

  Dear Zoho Support, I'm writing to propose a valuable feature request that would streamline data management and improve user experience within the Zoho ecosystem: automatic synchronization between departments and employees in Zoho One and Zoho People.

• Nothing triggers a Journey

  I have been on the phone with Zoho support and they claim their development team needs to investigate more. However, I've found this is a pretty standard answer after a call takes any amount of time. After that, it's days and even weeks before it actually

• Manually Backorder Sales Order and/or Change Sales Order Status

  Is there an option to manually 'backorder' a sales order, or otherwise change it's status?  In some cases, we receive orders for products that are out of stock, but we already have issued POs to our suppliers for replenishment.   Ex- we created a PO on

• Backorder process review - Automating Removal of Sales Order from "On Hold" When PO is Received

  Hello Zoho Inventory Team, Currently, sales orders in On Hold status are released only when the bill for the purchase order is created. In our workflow, it would be much more efficient if the sales order could automatically move out of On Hold as soon

• Kaizen #254 - Building a Temporal Lead Score Decay System in Zoho CRM

  Hello, CRM Wizards! Welcome to a fresh week of Kaizen. In this post, we will build a temporal lead score decay system that works alongside your existing scoring rules by introducing percentage-based score decay driven solely by customer inactivity. By

• Metadata API Access to Functions

  I think it would be incredibly helpful to have api access to every function's code. Our team primarily uses deluge functions to update fields across modules according to business logic. I would like to create a visual dependancy model for our CRM, but

• API actions/approvals endpoint returns UNAPPROVABLE despite user having full permissions and being the assigned approver

  Hi Team, We are trying to programmatically approve a record via the CRM API but consistently receive an UNAPPROVABLE error, even though the same user can approve the record without issue from the UI. Endpoint called: POST https://www.zohoapis.com/crm/v6/{module}/{record_id}/actions/approvals

• Get a realistic picture of your revenue with Forecast Adjustments in Zoho CRM

  #crm25q1 Dear Customers, We hope you're doing well! Today, we're here with an important enhancement for business decision makers: forecast adjustments. Let's get straight to it! With technology on the rise and CX at its core, businesses are constantly

• I am not able to check in and checkout in zoho people even location access allowed

  This issue i am facing in mackbook air m1, I allowed location in chrome browser and i also tried in safari but getting similar issue. Please have a look ASAP.

• WhatsApp Vendors Module

  Hello, so WhatsApp works with the below, mainly with the customer side modules. Can we get functionality on the vendor side modules, i.e., PO, Bills, Vendor Credits, Payments Made, Purchase Received? WhatsApp is often the preferred method of communication

• Upload ticket attachments via Drag-&-Drop

  Hello, if you want to upload a file to the ticket attachment you need to click the button and use the file browser to select and upload the desired file. In many cases, it would be much more efficient if you could simply drag the file to the browser window...

• Elevate your Radar experience: Best practices part 3

  In the Spotlight: Zoho Desk's Radar app Customer support requires human intelligence combined with emotional intelligence. How about these coupled with contextual intelligence? These elevate the customer support experience. When providing support through

• Migrating my email from GMAIL to ZOHO MAIL..........

  I am a long time GMAIL user and I really only understand how they operate, but after reviewing your tutorials and forums online, it is quite unbelievable how much more and how much more streamlined ZOHO mail is, not to mention ZOHO's wonderful, more advanced capabilities. I do have several questions about transitioning over to ZOHO.  Primarily, where is the best place to start, what do I do first? And how hard is it actually to move all my business and personal accounts over here?  When I sign up

• Unable to send message;Reason:553 Relaying disallowed. Invalid Domain

  Hi, Now when I try to reply to an email, I see the Unable to send message;Reason:553 Relaying disallowed. Invalid Domain voicemessagedownloader.com error. I tested sending an email when I set it up in the past and it worked. I have checked the Zoho Organization

• Set Custom Icon for Custom Modules in new Zoho CRM UI

• RFID Scanner/Adapter Solution for barcode scanning

  Hello, We will be trialing using barcode scanning for item verification during our picking process. Using a phone or a tablet is awkward and uncomfortable. Are there any Zoho compatible RFID scanners, or an RFID device/adapter that will connect with a

• Approval Process not retriggering after rejection when stage is manually changed back

  We have an Approval Process on the Opportunities module that triggers when Stage is changed to Negotiation (Execute on: Edit Only). On rejection, a field update action reverts Stage back to Proposal. The issue: after rejection, AE can manually changes

• Data Guardian for Zoho CRM – Auto-validate Emails, Phones, and Addresses. Get a 0-100% Health Score & automated tasks.

  I totally understand your frustration. Zoho CRM doesn't have a native way to auto-validate phone numbers or addresses, which leaves sales reps wasting time on bad data. I actually ran into this exact problem and ended up building a free extension called

• Next Page