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.
    • Sticky Posts

    • 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
    • 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
    • Recent Topics

    • WhatsApp Business Calling API

      Dear Zoho SalesIQ Team, I would like to request a feature that allows users to call WhatsApp numbers directly via Zoho SalesIQ. This integration would enable sending and receiving calls to and from WhatsApp numbers over the internet, without the need
    • Calendar Reminders unavailable

      For some received meeting invitations, Zoho Calendar’s web interface provides no option to add or edit a reminder. However, I can add a reminder to the same event through the phone app. That reminder then appears in the browser, but still cannot be edited
    • Zoho Desk MCP doesn't expose all functions

      Hello, I'd like to be able to draft (rather than send) ticket replies using Claude Cowork. However, the Zoho Desk MCP doesn't currently offer that, despite it being available in the API (https://desk.zoho.com/DeskAPIDocument#Threads#Threads_DraftEmailReply).
    • Email-Data Synchronization with Zoho Analytics

      Hello, Enterprise Support Community! We're excited to announce the availability of Email Data Synchronization with Zoho Analytics! This highly requested enhancement allows you to sync email data from Zoho CRM into Zoho Analytics, making it easier to analyze
    • Keeping phone number text format exporting from Books to Sheet

      We have a custom function that copies data from our customers in Books to Sheets. In the process the customers' phone numbers (unless they contain a space) get treated as numeric values, so leading zeros get stripped off, and in some cases scientific
    • #22 I Sent It to the Wrong Person

      Meera was sending an invoice to a client when she mistyped the email address. She noticed the mistake a week later, when the payment had not come in. She corrected the email address on the customer record and waited for the payment to arrive. But nothing
    • Build a historical inventory snapshot in Google BigQuery using Zoho DataPrep

      Businesses using Zoho Inventory may want to transfer their inventory data to Google BigQuery to maintain an up-to-date data warehouse. While scheduled pipelines help keep BigQuery updated with the latest inventory data, businesses that also need to track
    • Zoho writer tabs

      I'm trying to post a list of actions for my team to share online. For this I need to set tabs -- can't find a way of setting tabs anywhere. Would prefer not to go to the formality of a table. Can anyone tell me how to set tabs? greigg
    • 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
    • Keep Zoho Books data in sync with Google BigQuery

      Businesses using Zoho Books may need to transfer their financial data to a data warehouse like Google BigQuery for reporting and analysis. Zoho DataPrep helps automate this process by preparing Zoho Books data and syncing it with BigQuery at scheduled
    • What's New - October 2026 | Zoho Backstage

      Hello everyone, The last few months of the year are usually the busiest for events, with more people to reach and more details to manage. This month, we’ve made a few changes that should save you some time and back-and-forth along the way. Here’s what’s
    • Introducing user-based authentication across Zoho CRM

      We have introduced two enhancements to simplify authentication and enable user-specific access when working with Connections and executing CRM operations across different developer tools. 1. Enable user-based authentication for Connections Connections
    • 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()
    • Allow Multiple usage units to items while adding them to sales/purchase transactions

      The usage unit of items added in zoho books are static right now and can not be changed. But certain items are received or sold in multiple usage units. One example is fabric. It can be bought in Meters, inches, kgs or other units. Another example would
    • Zoho Inventory – Stock Allocation and Warehouse ManagementAs we implement Zoho One in our organization, we are currently facing a challenge with stock allocation and warehouse management. While the wa

      As we implement Zoho One in our organization, we are currently facing a challenge with stock allocation and warehouse management. While the warehouse management part can be handled in Zoho Inventory, our main requirement is the customer-wise stock allocation
    • How to restore deleted campaigns?

      I accidentally deleted my first campaign that went out today (08/21/18). How do I restore it?
    • Using IMAP configuration for shared email inboxes

      Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure
    • New in Cadences: Option to Resume or Restart follow-ups when re-enrolling records into a Cadence, and specify custom un-enrollment criteria

      Managing follow-ups effectively involves understanding the appropriate timing for reaching out, as well as knowing when to take a break and resume later, or deciding if it's necessary to start the follow-up process anew. With two significant enhancements
    • Automatic Invoice Number generation for createRecord

      Hello, while testing some custom Buttons in my Zoho Books application, I noticed that I get an error that previously did not occur. After some further digging I found that the automatic transaction numbering of invoices no longer work in my organization.
    • 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
    • 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
    • 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,
    • 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
    • Next Page