Updated:
Original:

Essential Formatting Shortcuts in Excel

Learn essential formatting shortcuts in this Excel tutorial with expert Shir Moscovitz.

Transcript

Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.

So now let's talk about some essential Formatting shortcuts in Microsoft EXCEL. There are three ways to Format the CELLS. The first method is using the RIBBON up top here. Especially of use to us is going to be here in the CELL Styles or Format as Table or Conditional Formatting and even more options here in the Format of CELLS. Another option is to choose the CELL that you want to right click and then choose Format CELLS. The best option in my opinion is to click the CELL you want, hit CTRL+1 which brings you to this window which is the most commonly used spot in EXCEL in my opinion. Here we have the Number for the data type, the Alignment - which We can do Horizontal, Vertical alignment - we can change the Orientation of the Text so that it reads vertically if we choose 90 degrees. We can also - I'm going to undo that - we can also do things like change the Font, have any effect that we want with Subscript, Superscript, or Strikethrough. We can choose different Borders. There's a lot of choices here. And Fill to shade the color anything we want as well as additional protection. So this is the best place to go for anything Formatting.

Let's go through the most commonly used Formatting that we'll need to do. So if we select the CELLS we want to Format, we'll hit CTRL+1. Let's choose the basic Font Formatting. In fact, we can do that through here. Let's choose the CELLS we want and let's do either CTRL+B for Bold, CTRL+U for Underline, CTRL+I for Italics. If I press it again, it undoes it. Alignment is a big, most commonly used Formatting tool. So I want to change the Alignment so instead it goes Centered or Left but since it's Currency I'm going to do Right. I can also choose the vertical Alignment so it shows up differently as well. Other common things are Borders. If I want to make this entire Table have a Border, I'm going to select it, hit CTRL+1, go to the Border tab, choose first the Style of the Border that I want. I'm going to choose a thicker line over here and then simply use this as a way, use this area as a way of applying that Formatting. So I'm going to apply it to the Left, to the Right, Top and Bottom. A quicker way is to simply hit the Outline button. If I want to undo it, I can click again or I can simply hit the None. So I can use these options to make it quicker or I can use these to select one at a time. So let's choose an Outline and hit Ok. Now we have an Outline. If we want to go one step further and make everything inside with a grid, let's choose a very faint line and let's choose inside like that. Now everything is with a grid. If we want to Wrap Text - this is something that we actually did already over here. So I'm going to select the entire ROW and I'm going to do CTRL+1 and go to the Alignment tab and I'm going to uncheck it. So what that does is - it makes it - all the text appears on one line and if it doesn't show then it appears Hidden. SO the best way to make it show is to select it, CTRL+1, Alignment tab, and hit Wrap Text so now it appears on the next line according to the space that it needs.

We can additionally INSERT a new ROW here and put a title here for the data table. If we wanted to center that in the middle we could guess where to put it or we can do a Merge of all of these CELLS - CTRL+1, Alignment tab, Merge Cells. Then we can hit CENTER. THe other option is to use the RIBBON to simply do that in one click. We can add a CELL shading by selecting the CELLS we want and then clicking on the Fill color tool. We can even choose down and choose what color we want. We get a little preview on the side as we hover over it. It doesn't take effect until we click. We can even change the color of the TEXT and again it shows us a preview before we actually choose it. We can also do Borders from here by clicking on this down triangle to get more options. Here are some quick ones. Sometimes a useful one if you want to do a total, if this was the total line, you can select it all, a quick way of doing it is to just do top and double bottom border like that. Pretty useful. We can also increase the TEXT size like that or decrease it like that. And those are some essential Formatting shortcuts for Microsoft EXCEL.

Popular Categories