Hi, this is Wayne again with a topic “Excel Quick Tip: Repeat Last Action”.
In this microsoft, excel quick tip, i want to show you how to easily and quickly format your data using the f4 key. So here i have a monthly family budget and, let’s say i’d like to make some changes in the formatting. Maybe i’d like this total projected cost to be in blue instead of black, so i can make that change now. What if i want to make total actual cost, also be blue and total difference be blue. I could just make that change manually or i could use the format painter or i could just click on d4 in this case and tap the f4 key, and it applies whatever format change i just made whatever the previous format change was.
It applies it to the current cell. I can also click on total difference and do the same thing. Let’S look at another example here in the projected monthly income source area, i could click and drag to highlight a range of text. Maybe i want to make these bold they’re now bolded and maybe i’ll make these also bolded. So i select the range that i want to make bold and then tap the f4 key and because my previous formatting change was to make the selected area bold. It does the same thing with the currently selected area, and this works with much more than just color and bold or not bold.
It would work with italics, underline the fill color, the font type, the font size and more. You can also use the f4 key to repeat other things besides formatting, so, for example, let’s say i want to insert a row here, i could right click on row 44 and choose insert that gives me another row. I could do that again and i could even click and drag to select 44 and 45. Let’S say right. Click insert now: i’m inserting two rows at a time, but once you’ve done that one time it’s better to just tap f4 and notice what it’s doing.
Every time i tap f4, it’s adding another two rows in this case to this part of my spreadsheet. So the f4 key is really about repeating whatever your last action was. It doesn’t work for everything, but try it out.
It’Ll! Save you a lot of time thanks for watching. I hope you found this tutorial to be helpful. If you did please like follow and subscribe, and when you do click the bell so you’ll be notified.
When i post another video, if you’d like to support my channel, you can do that by clicking the thanks button below the video or by supporting me on patreon or buying channel merch and you’ll see information about those options in the description below the video. Speaking of patreon, i want to give a quick shout out to my five dollar patreon supporters. Thank you.
So much for all you do to support the channel. .