How to Repeat Last Action in Google Sheets

Google Sheets, as we know it, is one of the most convenient data-processing platforms out there, and knowing your way around it, can make everything even better.

So for this article, I am going to explain how you can repeat the last action that you had performed in Google Sheets.

Hello and welcome to another one of TeqTog’s articles on using Google Sheets!

Let’s get started, then!

Fortunately for all of us, there are lot of keyboard shortcuts for performing the preceding task again. Here are a few of them I will show you:

Keyboard Shortcuts for Repeating the Last Action

1. F4

The key combination of “F” and “4” is a very common shortcut and it is used most of the time. All you need to do is select the cell, or, the range of cells on which you have done a certain command.

Then, you click on another cell, or, a range of cells and just press F4. The last command you made will also be valid for this new location in the spreadsheet.

You should know that the size of the cells does not need to be of the same size. Isn’t it easy?

2. Control + Y

The same can be done with the key combination of Control + Y. If you apply this feature in the same way, you will get the same results.

With Paste, Cut and Copied Cells Repeat Last Action

There is also the old classic of cutting or copying a row or a column, or, rows and columns.

Once you cut or copy the row/s and column/s you need, you just place your cursor on the place where you want those cells to be repeated and, right-click on your mouse to get the right-click menu. The right/click menu will give you all of the options for how you want to insert the cut or copied rows/ columns.

Entering Hyperlinks To Repeat Your Last Action in Sheets

Moreover, there is also the option of creating a hyperlink for cells and ranges of cells, or, worksheets in the same spreadsheet.

There are two possible ways you can insert a hyperlink in a cell:

  1. Firstly, you can open the Hyperlink menu for the message box. There is a shortcut do to this; just press Ctrl+K.
  2. You can use the Hyperlink formula.

Firstly, click on the cell in which you want to insert the hyperlink and click on the “Insert” tab from the top menu. Select the “Link” option from the menu and a message box will pop up. In the empty field, insert the URL of the relevant link and just select “Apply”.

Closing Words

Well, I hope my small tutorial on how you can repeat the last action done in Google Sheets will help you the next time you need it.

Best of luck!

Read More Related Google Sheets Guide On:

How to Format Zip Codes in Google Sheets

How to Use the MOD Function in Google Sheets

Greater Than or Equal To in Google Sheets

AVERAGEIF in Google Sheets

Was this article helpful?
YesNo

Leave a Comment