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

• 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

• 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

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

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

• Recent Topics

• Host not found?

  Howdy! So i'm trying to add my custom domain for with the mail server. I have 100% control of my DNS and have tried every single option (TXT, CNAME, and even HTML) multiple times, ensuring i did it properly, to no luck. I get the same error message every

• Auto End Chats After Customer Inactivity

  Hello Everyone, I may be missing something, but is there a way to auto-end chats when a customer has been inactive for an amount of time? I have several operators (we use a shared set of account with schedules for people... that's another story) but at

• Report on opportunities showing only the last note added.

  Hi I need to create a report that shows the most recent note added to each opportunity. This is so management can see what the latest update is according to the assigned salesperson. One workaround is to use the status field but this implies added manual work and mistakes as the salesperson would have to copy the existing status to a note before adding the latest status... otherwise the activity history would be lost. My current workaround is a report on Notes with Opportunities as the related module.

• Please add Zelle as an online payment option

  Hello, I would like to request Zelle be added to the online payment service providers for Zoho Invoice. Considering how ubiquitous Zelle has become as a way to pay people via the major banking institutions, I feel like many freelancers would benefit from

• Getting Project Template List using the REST API

  I am trying to confirm that I can use the REST API to create a project using a project template. The API documentation indicates this is possible by providing the Template ID, but it is not clear at all how to get a list of available Project Templates

• How to display the CONTACT ID in the Contact page

  Hi, I've seen this conversation below and it is exactly the same question I'm raising now, but unfortunately the last message is not solved https://help.zoho.com/portal/community/topic/show-contact-id-while-editing-contact-form I need to show the ContactId and I don't know how to do this. The last message included in the conversaton shows the way but not it is not completed. "I am sorry by default we do not have the option to show the record ID for the contacts in the field in a record. When you

• How to change margins in templates

  Hi, I'm new to Zoho Campaigns, and am trying to figure out how to adjust the margins within an email template.  The default margins make the text go all the way to the edges of the page.  Please advise.

• Create Canvas list view templates from images powered by Zia

  Currently available for all paid editions of Zoho CRM in the US, EU, IN, JP & CN DCs. Designing a personalized CRM interface just got even easier. In today’s fast-evolving digital landscape, AI is transforming the way we work by automating complex tasks

• Painfully Slow Zoho mail

  Since yesterday Zoho Mail seems to have starting functioning very slowly and having a few bugs. It's slow to open mails, slow to send, slow to change between email accounts. Sometimes clicking on a particular folder (eg Sent folder) stops working and

• "Wrong password or login" Problem to configure Zoho on MAIL App on my Macbook

  Hi, I'm having problems to configure my e-mail on my MAIL App(Macbook pro). My e-mail is hari@trespontoum.net Actually was working perfectly, and still working on my Iphone. My MAIL App prompt me that my login or password is wrong. I tried to change 3

• "User already exist in your org"

  Hello, I've just read a discussion about this issue, which didn't solve my problem. I'm trying to add the following emails: sales@kiss-my-boutique.co.uk returns@kiss-my-boutique.co.uk orders@kiss-my-boutique.co.uk I'm getting an error message each time I try and add them. None of them are primary or secondary emails and none of them have been created as users before. I know this as when I try and login and do 'forgot my password' all I get is an error message saying 'user invalid'. Please advise.

• Operation Not Permitted

  Hi, I have problem in adding user after verifying the domain but it seems like error appeared which is "operation not permitted". For your information, I had delete other domain before did it.

• Email forwarding setup fails

  I'm trying to set up email forwarding from my Zoho email to my gmail address. I followed the directions to set up email forwarding here: https://www.zoho.com/mail/help/email-forwarding.html. I did only steps 1-6. After doing this, rather than setting

• Shopify store email issues- Not getting emails

  Hi We have migrated from Microsoft outlook to Zoho back in March, we have a shopify store, the domain is hosted on namesilo, not shopify, I have seen some people here complaining about not getting emails from customers who fill out the contact form on

• Invoice Discount Account

  Is there a way to change the account used for Discounts applied to an invoice? The current Discount account (ZB native account) type is an "Income" type. I would like to change it to "Other Income", but that is not possible, I am assuming because it contains

• Need Inactive accounts to be visible in Reports in Zoho Books

  I N=need Inactive accounts to be visible in Reports in Zoho Books to do recons of the accounts but when i see the same they are not visible in the Accountant - Account Transactions report

• javax.mail.authenticationfailedexception 535 authentication failed

  Hi, I am facing 535 authentication failed error when trying to send email from zoho desktop as well as in webmail. Can you suggest to fix this issue,. Regards, Rekha

• Phantom Opening Balance

  While experimenting w/ creating a composite item, Zoho added funds to Petty Cash and added Bank Account equal to previous day's balance. I'm unable to undo the adding of funds. Attaching screenshots of both bank account and petty cash transactions.

• Importing customer comments and multiple shipto addresses

  I am evaluating Zoho Books and have most of my data imported with two exceptions: (1) Import customer comments - in my current system I have several comments of different types, and I need to bring these into Zoho. Preferably Books customer records, but

• Detailed Account Reports - Add Running Balance

  When one clicks into an account from a report (say P/L or Balance Sheet), the default reports have the Debit, Credit, and then the Amount. The Amount column (last one) is duplicate information. It would be far better and fit more peoples' use cases if

• How to Billed from two different GST Numbers

  How to Billed from two different GST Numbers. Suppose ABC & Co had GST registration in Delhi and Haryana and Zoho account is created with Delhi GST Registration number. Now i also want to issue invoice from Haryana GST Registration number. How can i proceed ?

• Zoho IP blocked by SpamHaus

  ERROR CODE :550 - 5.7.0 Your server IP address is in the SpamHaus SBL-XBL database, bye

• IMAP Communication Problems - IMAP Down Again

  We are experiencing the same problems over the last week or so that were supposedly 'solved' according to this thread. Zoho Imap Down Again This is affecting attempts to use IMAP on multiple ISPs and users so is definitely narrowed down to Zoho problems.

• Can't login to Zoho mail

  I'm logged into Zoho but when I try to go in zoho mail I get: Invalid request! The input passed is invalid or the URL is invoked without valid parameters. Please check your input and try again. I just set up my mx records and stuff with namecheap a few

• Hotmail is STILL blocking the zoho mail IP

  Greetings, as I already mentioned in my last message, my Zoho IP has been blocked by Hotmail for more than 15 days. Although someone said that the issue was "solved," it still isn't, and this amount of time seems neither normal for a "serious" company,

• Keyboard shortcut M key

  I'm trying to customize my keyboard shortcuts and assign the "m" key. But it says the key is already assigned. I've looked through all my shortcuts and can't see any assigned "m". When I select an email and press the M key, nothing happens. What is the

• Manage customer access across multi-brand help centers

  Hello everyone! Managing customer's access across multiple brands has been streamlined with the ability to invite, reinvite, approve, reject, and deactivate contacts individually for each help center brand . This enhancement gives administrators precise

• White Label certificate

  Hi all, About 72 hours ago, we fulfilled all steps for white labeling (CNAME to point to mail.cs.zohohost.eu), but since then the configuration page is now stuck at "generating certificate" since 3 days. When I execute an NSLOOKUP mail.webfoundry.be it

• Unusual activity detected from this IP. Please try again after some time

  When i try to create new addresses on my account i am getting this error, it has been 24 hours now and i am still getting this error can anyone help

• How to add a new domain in my account?

  Probably zoho has the worst UI in the market. Cannot add a new domain to manage a new email address.

• Report sorting not working

  I make extensive use of Summary reports and Pivot Tables. Most of these reports are structured such that I have several columns of "information" data that I want displayed, followed by one or more "Data" summarizations. For example, I have the following

• New Enhancements in Wizards

  Dear All, Wizards help you break a long form into a series of smaller forms on different screens, making it less overwhelming. We are thrilled to introduce a couple of enhancements to wizards in Zoho CRM: Enhancements for conditional rules in Wizards

• Find and Merge Duplicates to trigger webhook

  My sales team uses the Find and Merge Duplicates feature often to cleanup records in the CRM. We use webhooks to signal to our internal tools database when new Contacts are created, updated, or deleted, in order to keep our DB in sync with Zoho CRM. However,

• Charting the 2025 Voyage: Zoho Invoice's Year in Review

  2025 has been a year of progress, productivity, and purposeful growth for Zoho Invoice. From expanding into new regions to refining everyday workflows, each update was designed to help businesses stay compliant, get paid faster, and work with confidence.

• How to Hide System-DefinedTemplates in Service Report

  Is there any option available to hide system-defined templates? these templates are causing confusion for field users.

• WhatsApp Report in Bigin CRM

  Reporting feature for Bigin CRM’s integrated WhatsApp that provides insights such as: Number of WhatsApp conversations closed Number of messages sent and received Number of conversations replied to Response and closure metrics for WhatsApp chats More

• Issue with Azure DevOps Integration in Zoho Flow

  Hello, All workflows between Zoho Flow and Azure DevOps have stopped working for several days now. Upon further investigation, it seems that the connection to Azure DevOps is no longer directly supported. Indeed, Microsoft has deprecated the Azure DevOps

• Narrative 16: Simplify with workflows

  Behind the scenes of a successful ticketing system: BTS Series Narrative 16: Simplify with workflows What is a workflow? A workflow organizes business tasks in a defined sequence that makes each step clear to all participants. This ensures work is completed

• Zoho Invoice Customer Login Portal

  Are there any plans for a customer portal to Zoho Invoice, ala Freshbooks?  I would like customers that I invoice to be able to login to review invoices and invoice history.  I have not switched from Freshbooks for this very reason.

• Random Leads are being created

  Hi, Every few days I am getting random leads that are being created with no form interactions at all. The email addresses are from obvious spam, such as 'Easymerchantsx'. When I look at the timeline, there is a Visit record and then a Lead Created record,

• Next Page