Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Formatting a spreadsheet is very similar to formatting a word processing document. You first just select the text or cell you want to format and then apply your changes. I am working with a very simple spreadsheet I previously created. So let's take a look at some formatting things we can do. First of all, we've already seen that you can use the Number section of the Home tab to specify the appearance of numbers like Currency or Percentages or Date or Time and so on. The Home tab also contains many of the same options you'll find for formatting text under the Font and Alignment areas.
For example, I'll select the cells for Job A and Job B by dragging through them. Now I can make them, say Bold and I can center them. I can also change the color and outline of selected cells. I'll select the Annual Income cells right here, and I'll make them a light green. Excel even has several built-in formatting options under the Style section, under Format as Table. First I'll select all the cells currently in use for this particular worksheet just by dragging through and selecting, and then under Format as Table, I can pick any one of these particular designs.
Now Excel asks me to verify which cells contain my data. Since I selected all the relevant cells before I chose my Style format, this is correctly showing cells A1 through C6. There's A1, there's C6. I am also going to check My table has headers, which tells Excel to keep my Job A and Job B headers where they are. I'll click OK so you can see my selected areas have been formatted and I now have a nicer looking table. Also notice the arrows that have been added next to the headers in the first row. Clicking them allows you to sort your columns in several different ways.
None of these are particularly relevant for this worksheet, but if you had a column of, say, annual income sources or something like that, it might be useful to sort them from largest to smallest or smallest to largest or using any one of these other type of filtering options here. Since I didn't have any text in Column A1, it just says Column1. If I don't want that there, I can just select the text and maybe type a space to make that cell look empty. Now I am not going to get into the details of formatting with Excel exclusively here, but this should give you an idea of how formatting in a spreadsheet works, no matter what spreadsheet program you are using.
Again, it's very similar to formatting in a word processing document. Just select what you want to change first and then change it.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74539 Viewers
80 Video lessons · 129748 Viewers
52 Video lessons · 63980 Viewers
59 Video lessons · 49751 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.