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

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.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


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

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ





                                ご検討中の方

                                  • Recent Topics

                                  • 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 / letter
                                  • You cannot send this email campaign as it doesn't have any eligible contacts in the selected mailing list. You can try adding contacts or choose other mailing lists.

                                    please help
                                  • Add Days In Stage to Filter Options for Pipeline

                                    We use the days in stage to see how long a ticket has been in a certain stage. But there is no option to see this via filters. eg if i wanted to see how many tickets over 5 days in a stage, there no way to do this. Currently we have to export a report
                                  • Integration problem between zoho crm and zoho forms for an update in zcrm, with two mapped custom fields

                                    Hello everyone, I need to correct an existing integration between Zoho CRM and Zoho Forms: the use case is that a user needs to send an email to a contact, who will click on a button in this email, redirecting to a Zoho Forms. The contact can update or
                                  • Purchase Order Quantity Validation Not Enforced During Bill Approval

                                    Hello Team, I would like to report a potential issue in the Purchase Order to Bill workflow. Steps to reproduce: Create a Purchase Order for an item with Quantity = 100. Approve/sign the Purchase Order. Convert the Purchase Order into a Bill. Change the
                                  • How do I add multiple contacts in a deal

                                    How do I add multiple contacts in a deal
                                  • Blueprint Not Triggering When Lead Status Is Updated by Workflow (IndiaMART Integration)

                                    I have set up a blueprint that triggers when a lead’s status is “New Lead.” Our CRM is integrated with IndiaMART, and when leads are created from IndiaMART, their Lead Status is initially set to None. To handle this, I created a workflow that automatically
                                  • Add multiple users to a task

                                    When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesman
                                  • The 3.1 biggest problems with Kiosk right now

                                    I can see a lot of promise in Kiosk, but it currently has limited functionality that makes it a bit of an ugly duckling. It's great at some things, but woeful at others, meaning people must rely on multiple tools within CRM for their business processes.
                                  • Zoho Webinar not sending calendar entry into Outlook or other calendars

                                    Dear All, I am using Zoho Webinar for last few months and noted that when a attendee registers at the webinar link he gets an email will intimating his registration and link to webinar. He also get few file ( for Outlook, Google calendar etc) which he
                                  • Deleted User Emails

                                    I need to delete a user as I need to re-use their license, but I'd like to keep all their emails that are attached to various contacts in the CRM. Their emails are hosted externally on an M365 license. Anyone any idea how best to engineer this? TIA
                                  • Ticket Status

                                    HI, Any idea on how to create other options for this header??? I want to add an "Ordered" status. Its under "tickets" in Overview, I need a new status created (see second picture)
                                  • Turning off the recorded welcome in Zoho Webinar

                                    Is there a way to turn off the recorded voice that comes up at the beginning of every webinar session? It devalues the experience for attendees from feedback, interrupting their connection with our brand and delaying webinar start unnecessarily.
                                  • Client Script | Update - Client Script Support For Custom Buttons

                                    Hello everyone! We are excited to announce one of the most requested features - Client Script support for Custom Buttons. This enhancement lets you run custom logic on button actions, giving you greater flexibility and control over your user interactions.
                                  • Save embed widget personalizations

                                    Ok, Zoho, Great work on providing PRICING TABLES via the embed widget. Thanks so much. This changed the game for me Only one slight problem....I can't seem to save my widget settings. I'm still building my products and plans but I'm testing how they look
                                  • Problem with UTM Parameters: Zoho Forms - Zoho Desk Integration

                                    Hi Zoho Support Team, I want to automatically capture UTM Parameters from my website URLs and pass it from Zoho Forms into Zoho Desk. I have activated the UTM tracking feature. I've integrated the UTM Tracking code in my website footer on all pages. I've
                                  • Team folder not created when creating project using zoho flow

                                    When I try to automate project creation using zoho flow, and I have enabled workdrive integration to automatically create team folders to attach to the project, this only works when I create a new project through the UI. But I am trying to automate project
                                  • Zoho CRM upload files error

                                    Since today, we have been experiencing issues with uploading photos to opportunities. The message indicates that the storage is full, but as far as I can see, there is still plenty of space available. Could there be an issue or a bug?
                                  • Add an option to deactivate Zoho Meeting "Welcome" message

                                    My request is to provide an option to deactivate the annoying Zoho Meeting "Welcome" voice when participants join meetings... or remove it all together. First impressions count, especially with new clients. This notification reminds me of the AOL "You've
                                  • Service line items

                                    Hello Latha, Could you please let me know the maximum number of service line items that can be added to a single work order? Thanks, Chethiya.
                                  • SalesIQ > My Chat sort by Unread or Follow-up

                                    Hi Zoho SalesIQ Team, I would like to submit a feature request regarding the My Chat > Sorting in the SalesIQ UnRead Follow-up Conversation tags Thank you for considering. Best regards, CJ
                                  • Record sharing for Activities modules in CRM

                                    Hello everyone, We've got a few quick enhancements to what we covered in this previous announcement: record sharing is now available for Activities modules. 1. Sharing Tasks, Meetings, and Calls Until now, activity records could only be shared indirectly
                                  • SalesIQ : How to disable "Idle chat handling" ?

                                    Hello SalesIQ Team. SalesIQ, How to disable "Idle chat handling" ? I would like to disable the option “Automatically close chats that have been idle for a specified amount of time.”
                                  • How do I create an update to the Cost Price from landed costs?

                                    Hi fellow Zoho Inventory battlers, I am new to Zoho inventory and was completely baffled to find that the cost price of products does not update when a new purchase order is received. The cost price is just made up numbers I start with when the product
                                  • Function and workflow to create customer payment and send receipt

                                     I am attempting to set up a workflow/custom function for the automatic creation of a customer payment and sending the email receipt, but am receiving the error "Improper Statement Error might be due to missing ';' at end of the line or incomplete expression" I've been over everything several times and cannot see where the error is (code is copied into the attached document).  I haven't used custom functions before with Deluge, so it's very likely something very simple, or I've completely mucked
                                  • Smart Alerts: Protect users with configurable email alerts

                                    Email-based threats are becoming harder to identify and manage. Administrators need proactive ways to protect users from phishing, fraud, and policy violations. Standard filters can block emails, but blocking alone isn't always the most effective response.
                                  • Facturation électronique 2026 - obligation dès le 1er septembre 2026

                                    Bonjour, Je me permets de réagir à divers posts publiés ici et là concernant le projet de E-Invoicing, dans le cadre de la facturation électronique prévue très prochainement. Dans le cadre du passage à la facturation électronique pour les entreprises,
                                  • Power up Zoho CRM with project intelligence

                                    Dear user, You're probably one of those businesses using your CRM as a single source of truth. It's where sales, project execution, and finance teams go to analyze past decisions and formulate future strategies. But what happens when project data is either
                                  • Print multiple uploaded images in an HTML snippet in a Page

                                    I have a Form: Job_Preparation It stores details of each new item that must be built by the fabricators in our workshop. The form has a field: Documents I upload 4 image files to the Documents field. I want to print a sheet for our workshop staff with
                                  • "Track Inventory for this item" is forced checked by default for goods items (eTims issue?)

                                    Hello, Since connecting our Zoho books to eTims (Kenya) the "Track Inventory for this item" is forced checked by default (eTims issue?) in the Item creation page for any type of goods. So when purchasing anything that the company does not intend to sale,
                                  • Its 2022, can our customers log into CRM on their mobiles? Zoho Response: Maybe Later

                                    I am a long time Zoho CRM user. I have just started using the client portal feature. On the plus side I have found it very fast and very easy (for someone used to the CRM config) to set up a subset of module views that make a potentially extremely useful
                                  • Why can't we choose Fixed Asset account for Purchased Items? (eTims issue?)

                                    Hello, When the company purchase items not for sale and not supposed to be in the inventory stock, like equipment for operational use, there is no way to access the Fixed Asset accounts in the drop down list. Is that an eTims limitation again? Or something
                                  • Zoho Team Inbox - roadmap

                                    Hi, would be good to understand the Teaminbox roadmap, in particular: 1. API / Zoho Deluge connections. We have a process where the each email needs to be either tagged or assigned daily. It would be great if we could automate a 5pm alert for any exemptions
                                  • SalesIQ Integration with LINE: API Rate Limit Issue and Pre-Chat Flow Concerns

                                    Hello SalesIQ Developer Team. I have investigated the issue and found that the LINE Rate Limit is being consumed unusually quickly. LINE API free usage limit: 300 messages per month per brand. This limit will be reached within the first few days. 1. LINE
                                  • Free webinar! Sign documents across borders: AES, QES, ID verification

                                    Hello all, Signing paperwork across geographies sounds simple, until critical questions around legality, security, and compliance pop up. Join our upcoming webinar to see how Zoho Sign helps businesses worldwide sign documents with confidence. Agenda:
                                  • Add field "Expected Availability Date" to Purchase Orders

                                    Hi there. We drop ship and 'make to order' whereby we backorder sales order items directly with factories for manufacturing. One of the leading questions from Customers is "when is the order ready". Currently there is an 'Expected Delivery Date', which
                                  • Related list view for Assets

                                    We first set up all our parent assets in FSM and now we are adding child assets which are the parts for the parent assets. When under the customer related list, since it only displays 5 rows of data, I have to click through many assets to locate the parent
                                  • How To Invoice Immediately for Future Subscription

                                    Hi, When a new subscription is created that has a future start date, Zoho Subscriptions does not invoice the customer until the start date of the subscription. Is there a way to immediately invoice the customer as soon as the subscription is created,
                                  • Problem with the blueprint flow.

                                    Scenario: 3 departments in a single environment: A-B-C agents from department 1 D-E-F agents from department 2 G-H agents from department 3 Since we've been using Zohodesk (2023), agents can assign tickets to the correct department using the blueprint
                                  • Create Tasklist with Tasklist Template using API v3

                                    In the old API, we could mention the parameter 'task_template_id' when creating a tasklist via API to apply a tasklist template: https://www.zoho.com/projects/help/rest-api/tasklists-api.html#create-tasklist In API v3 there does not seem to be a way to
                                  • Next Page