Filipin.eu

Željko Filipin's blog.
Home Blog Tags Now License

View on GitHub
15 March 2007

Repeat Feature of Microsoft Excel

by Željko Filipin

While I am in "tip mode"... :)

I found out something very useful in Microsoft Excel. There is feature called repeat (Ctrl+Y). It is not only the opposite of undo. With it you can repeat action you have just performed.

Time for an example. I will not go into detail. I had a lot of data in one row, a few hundred cells (if I remember correctly, maybe even over thousand), and I wanted to move some cells to the right.

dog
cat
elephant
...

I had to visually look at that data and some of it move to the right column. In this example, I would move elephant. (I leave it to you, dear reader, to figure out why.) I could cut elephant and paste it in the cell to the right. Let's count keyboard actions. (Remember, I had to do it a lot, so every keyboard or mouse click counts.)

  1. Ctrl+X
  2. Right Cursor
  3. Ctrl+V

Three actions. Now table looks like this.

dog
cat
elephant
... ...

I could get the same result with inserting cell and moving original cell to the right. Right click "elephant" cell, from context menu select Insert... > Shift cells right > OK. (I used mouse to do that, but there is also "right click" key on your keyboard. It is just to the right of "any" key. Just kidding. It is to the left of right "Ctrl" key on my keyboard. Really.) A lot of clicking. But, after you do it once, Excel remembers that you have just inserted cell and moved previous content to the right. And you can repeat that action on another cell with Ctrl+Y.

So, when you have to repeat some action that requires a lot of clicking (mouse or keyboard), you can do it just once, and that repeat that action with Ctrl+Y. It saved me a lot of time.

tags: TODO