Enhance your Excel proficiency by mastering essential productivity tips, from repeating commands seamlessly to embedding dynamic screenshots. Streamline your workflow with simple yet powerful techniques such as Format Painter, comments, and hyperlinks.
Key Insights
- The F4 keyboard shortcut efficiently repeats formatting commands like font size changes and cell indentation, significantly speeding up repetitive Excel tasks.
- Format Painter allows users to quickly copy multiple cell formats (such as color fills, borders, and font styles) to other cells, and double-clicking the tool enables continuous application across multiple cells until deactivated.
- Excel provides built-in functions for inserting clickable hyperlinks and screenshots directly into spreadsheets, making it easier to create interactive documents without additional software.
Note: These materials offer prospective students a preview of how our classes are structured. Students enrolled in this course will receive access to the full set of materials, including video lectures, project-based assignments, and instructor feedback.
Excel tricks. In this section, we're going to take a look at several different Excel tricks that you can perform to speed up the work that you do and become a lot more efficient as you're performing operations in Excel. We'll take a look at a way that you can repeat a command that you just applied, how you can copy multiple formats over to other cells, inserting comments into your spreadsheet.
These will show up as little post-it notes when you hover your mouse over the cell, inserting links. Perhaps I want to link to a website. All I have to do is enter the text, create a link to the site I want to go to, and people will be able to click that link and go directly to the website.
Finally, we'll take a look at how to insert screenshots in your spreadsheet without using a third-party application. So let's get started. I'm going to go over to this cell that contains some text.
I want to be able to format the text in such a way that there's a yellow background fill to it. So on the Home tab, I'll head over to the Font group, and if my color is not already selected, I will click the drop down and choose the color that I want. Now my color is already there.
I'll simply click on the yellow fill, and that applies the format. Now I need to do this as well for the text underneath, but I'm not going to need to go back up to the font group in the ribbon. All I will need to do is simply press the keyboard shortcut F4.
That repeats the last action that I just took. Now I want to change this font size to 14. I'll just use the Increase Font Size command.
Now I want to be able to repeat that action with the cell underneath. I'll simply press F4. Now I want to increase the indent for this cell.
I'll go over to the Alignment group and increase the indent by pressing the Increase Indent button. Next time I need to do this, I'm not going to maneuver my mouse back up to the Alignment group. I'll simply press F4, and that repeats the last action.
So that's how you can use that keyboard shortcut to repeat some very common formatting options. This may not work with all the commands that you perform in Excel, but most of the formatting options will work. Format Painter.
This is a little different. This cell has multiple formats that have already been applied. I'm not going to be able to press F4 and apply all of them.
So as an alternative, I'll select this cell. I'll head over to the Home tab, and over in the Clipboard group, I will see Format Painter. What Format Painter will do is it'll copy all the formats that have already been applied to a cell.
When I bring my mouse back into the spreadsheet, the cursor is going to look different. I'm going to see a little paintbrush there, and so the analogy is imagining that you took a paintbrush and you put it into a paint bucket, and now you're going to paint over other cells with that same color. Here it's multiple formats, and with one click, I've applied all three formats to this cell.
That's the border that's a little dashed. Also the purple formatting for the text and the peach background color. Now I would like to apply that same format to this cell.
Now I could potentially click F4, but let me show you something else. If I double click on Format Painter, that locks it into position. This allows me, I double clicked more than two times, so I'll do it again.
Double click. When I see that that is shaded in, now I'm able to go and click on multiple cells and apply that same format multiple times. When I'm done and I want the cursor to go back to the way that it was, all I have to do is either press Escape or go back and click on Format Painter, and then notice it's not gray anymore.
Now I have my regular cursor. Inserting comments. I might want to insert a comment in a cell.
Now I have the latest version of Excel, which is 2019, so when I head over to the Review tab, comments are different in 2019. If you have a version of either 2013 or 2016, then your version of comments is actually notes in 2019. If you're using 2013,2016, I would choose New Comment, and you will get something that looks like this.
Then here, you can go in and depending on your username, you can go in and type in a new comment. I'm going to say, this is a comment. When I click outside of the cell, I don't see the comment, but I will see it when I hover my mouse over that cell.
So this is a great way to leave notes for yourself for certain formulas that you create without having to worry about those notes taking up space. The keyboard shortcut to also do the same thing is Shift F2. Inserting links.
I want to create a link to Microsoft's website. So what I'm going to do is type Microsoft, Microsoft's website. Press ENTER, and now for that text, I would like to insert a hyperlink.
I can do this by going to Insert, heading over to the Links group, and choosing Link. This opens up a dialog box where I can now enter an address, a website address, that I'm going to be able to go to when I click on the text, Microsoft's website. The keyboard shortcut to do the same thing is CTRL K, and you'll just think of the last letter in the word hyperlink.
Now what I'm going to do here is type in www dot. As soon as I hit the dot, I'm able to see that the dialog box automatically puts in http colon slash for me. Now I'm going to type in Microsoft's website, Microsoft dot com, and then I'll click OK.
Now the text to display is not www. Microsoft.com. It's actually Microsoft's website, so I'll keep that text intact unless I change text to display. Now I can maneuver my mouse over that cell, and it says click once, and then I will be able to go to Microsoft's website. I'm going to click here.
Now my browser has opened up on my second monitor. I'll bring that page back into here, and this is the site that shows up when I click on that link. I'm going to close this, and now let's take a look at our last tip, inserting screenshots.
I would like to insert a screenshot of another webpage or another application. Maybe I'm doing a tutorial. So let me go to the Microsoft website actually, and I'm going to bring this back in to view, and I'm going to go and search for Bing image search, and I'm going to go to images, and I'm going to actually that's perfect.
Now I'm going to go back to my spreadsheet, and what I would like to do is take a screenshot of the page I was just on. So I'll go to insert. I'll head over to screenshot, then I want to choose the option called screen clipping.
Once I click that link, I will just have to be a little patient, and now this is what I'm looking for. The screen has ghosted over, and I have crosshairs. I can take that crosshairs and shape and frame the image I would like to take a snapshot of.
As soon as I let go of my mouse after clicking and dragging, I snap a picture and it brings that picture directly into my spreadsheet. So those are a couple of tips and tricks you can use when you're working inside of your Excel spreadsheet.