The Mighty F4. One of the most useful shortcuts I've learned is the F4. How is it used? Well, it is basically a keyboard shortcut for redo. Here's how it works, or at least the way I use it.
When you want to do something repetitive but does not warrant a creation of a macro, then use the F4. Example, you want to color different non-contiguous cells to blue. You could click the cell, format it to blue, click another cell, format it again and so on. Another way,quicker in my own opinion is to click a cell, format it, then click all other cells and press F4. This will definitely save some time.
This is specially true for tasks that require a lot of "mouse work" or clicks. You only do the "dirty work" once and then just F4 all the rest.
Try it out, you may like it! Hope it helps you well and make your work a little easier and quicker!
Happy computing!
0 comments:
Post a Comment