Format Cells in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng, Anonymous

...More

Ad

Formatting Font

Welcome to VisiHow. This is the beginning of a 5 part series on how to format cells in Microsoft Excel 2013. In this tutorial, we are going to learn how to format the font. If you haven't used Microsoft Excel 2013 before and this is your first time, we strongly recommend that you check out some of the other Microsoft Excel tutorials, such as this article on how to navigate Microsoft Excel: Navigate Microsoft Excel 2013, as well as this article on how to create a workbook: Create Project from a Blank Microsoft Excel 2013 Workbook. Once you're done checking those out, come back and join us for this one.

Was this helpful? Yes | No | I need help

Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas0.jpg

Steps

  1. 1
    We already have an existing workbook open with a basic layout that we would like to format.
    We can choose the format of the text ahead of time, but normally it's wise to go ahead and get the basic layout with the information, then start to deal with formatting. Let's say we want to change the font in the title. We have a cell that is merged and centered as a title, and it is 11 pt Calibri. We can see that in "HOME" tab, in the font menu.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas59 60572.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    Let's say we want to change the size.
    We can do this 2 different ways. We can click on the "A" with the up arrow to increase it, or the "A" with the down arrow to decrease it.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas89 298937.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    Alternatively, we can left-click on the arrow beside the number and choose from that list.
    We will select "16". We will see the font size increase.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas98 194035.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Now let's say we want to change the font to have it stand out.
    We can select the arrow next to the font name and hover over the different fonts to see a preview of what it will look like. We will select "Algerian". Now the text in that cell has changed to that font.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas128 264178.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We can bold it by clicking on the "B".
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas145 916411.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We can italicize it by clicking on the "I".
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas148 564265.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We can underline it by clicking on the "You".
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas150 997497.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Another thing we can do is change the font color.
    We can tap on the "A" with a color bar underneath of it to change the title color if we'd like. We could also do it with individual cells, columns, or rows.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas160 311103.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    For example, if we wanted the names of the employees to be a different color, we could click on column A to select it.
    The cell that is merged won't be affected because it's considered a different cell. First we will change the font style, bold it, then choose the font color.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas174 358228.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    We're going to click on the arrow next to the "A" to select the color.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas204 991989.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    We'll click on red.
    Now all of the names in this column have the font, are in bold, and are red. That also means that anything typed in that column in the future will be the same.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas208 971377.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    We can also do that with rows as well by selecting the row.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas234 561804.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    Alternatively, to only change the format for certain cells, we can click on a cell.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas246 99782.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    Then, we can click on the box in the bottom left corner of that cell and drag to the area that we wish to have formatted.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas249 374487.jpg
    Was this step helpful? Yes | No | I need help

  15. 15
    We're going to select row 2 to change the style and color of the weeks.
    Now it is starting to take shape and look more presentable for the work sales figures. That's pretty much it.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas274 034966.jpg
    Was this step helpful? Yes | No | I need help

  16. 16
    We should always remember to save any changes we make to our workbooks by selecting the save icon which is the floppy disk icon in the upper left-hand corner.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas300 827961.jpg
    Was this step helpful? Yes | No | I need help

  17. 17
    We can also click on "FILE".
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas306 459609.jpg
    Was this step helpful? Yes | No | I need help

  18. 18
    Then click on "Save".
    Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.
    Format Cells in MS Excel 2013 pt 1 of 5.mp4-canvas308 603475.jpg
    Was this step helpful? Yes | No | I need help

  19. 19
    That is how to format the font in Microsoft Excel 2013.
    Thank you for watching VisiHow. If you have any questions or comments regarding this video, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No | I need help

Video: Format Cells in Microsoft Excel 2013 Formatting Font

Text Alignment

Hello and welcome to VisiHow. We are going to continue our 5 part series on formatting cells in Microsoft Excel 2013. In this tutorial, we are going to look at how to align the text.

How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas0.jpg

Steps

  1. 1
    As we can see, we already have a workbook open that we've been working on.
    What we would like to do, is start dealing with the text alignment. There are a couple of ways we can do this.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas24 934565.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    The first way is to select the column, row, or cell that we wish to change the alignment of.
    If we select a column or a row, the entire thing will change, so any future information being put into the workbook will have that same alignment. We can also select certain cells by clicking and dragging over the area we wish to format.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas58 709772.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    Let's say we want to select our numbers.
    Right now, it's set to be on the right side. If, for example, we wanted to align it to be centered, we would simply go up to the "HOME" tab, in the "Alignment" menu.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas87 796626.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    If we hover over the options, we can see that there's "Alight Left", "Align Right" and "Center" for horizontal alignment.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas97 834.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    At the top, there's "Middle Align", "Top Align" and "Bottom Align" for vertical alignment.
    We will click on "Center" for the horizontal alignment.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas99 844561.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    Once we click that, we will notice that the numbers have moved to the center of each cell.
    We've only formatted those cells, so if we put any numbers around it in the future, we will have to format them as well. If we wanted to format everything with the same alignment, we could select a column, a row, or everything by clicking on the arrow in the corner, the Select All button.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas136 584235.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We can also increase and decrease the indent.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas145 543678.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Another way to align the text is to right-click on a cell and click on "Format Cells".
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas156 114687.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    Then, we can click on the "Alignment" tab.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas159 521335.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Here, we can change the horizontal and vertical text alignment, we can wrap the text, shrink to fit, merge cells, change the text direction, and change the text orientation to make the text appear on an angle.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas179 787483.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    We can click and drag to select what angle we want the text to be.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas182 520502.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    Then we would simply click on "OK".
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas189 612876.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    We can also go to that menu by clicking the expand icon in the bottom right-hand corner of the "Alignment" section.
    How To Format Cells In Ms Excel 2013 Part 2 Of 5 Text Alignment.mp4-canvas200 583054.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    That is how you can change the text alignment in a workbook, in a cell or selection of cells in Microsoft Excel 2013.
    Thank you for watching VisiHow. If you have any questions or comments regarding this video, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No | I need help

Video: Format Cells in Microsoft Excel 2013 Text Alignment

Borders and Fill Colors

Hello and welcome to VisiHow. We are going to continue with our series on how to format cells in Microsoft Excel 2013. In this tutorial, we will learn how to add borders and fills.

How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas0.jpg

Steps

  1. 1
    We already have a workbook open, so we will start to put borders and fills in the table to make it stand out.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas31 726807.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Let's say we would like to put a border around the title.
    It's been merged and centered, so it spans across 5 cells. We're going to go to the "HOME" tab and look for the border icon in the "Font" section.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas53 218803.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    If we click on the arrow, we will see the many options for the border.
    We can also choose the color of the border. For tutorial purposes, we're just going to pick a top & bottom border and leave it black.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas65 389712.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    We can now see that there is a top and bottom border.
    We can't see the top border very well because it's at the top of the page.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas97 072362.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    Now, let's say we want to fill this.
    We have the black border and the black text, and we're still thinking that it doesn't stand out enough. We're going to select the cell or cells that we want to apply the fill to first.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas121 589484.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    Now we will click on the arrow next to the "Fill Color" icon.
    It's a paint bucket with some paint pouring out. Right now it's set to yellow.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas125 781225.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We can hover over the different colors to preview what it will look like.
    We will select a gray fill. There is now a fill applied to the title.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas139 434711.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    We can also apply that to a column if we wish.
    Let's select the column and click on the fill color arrow. We can see that it changes the entire column.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas180 465819.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    If we don't want the entire row or column to change, we simply select the cells that we're intending on applying the border or fill to and it will only change that particular area.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas190 915314.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Another easy way to do this is to select the cell(s) and right-click.
    Select "Format Cells". A new window is going to pop up.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas201 591983.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    We can click on the "Border" or "Fill" tab and choose the borders or fill.
    How To Format Cells In Ms Excel 2013 Part 3 Of 5 Borders And Fill Colors.mp4-canvas210 839109.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    That is how you change the border or fill of a cell or selection of cells in Microsoft Excel 2013.
    Thank you for watching VisiHow. If you have any questions or comments regarding this video, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No | I need help

Video: Format Cells in Microsoft Excel 2013 Borders and Fill Colors

Formatting Numbers

Hello and welcome to VisiHow. We are going to continue with our series on how to format cells in Microsoft Excel 2013. In this tutorial, we will learn how to format numbers in cells or a group of cells.

Was this helpful? Yes | No | I need help

How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas0.jpg

Steps

  1. 1
    The first thing we are going to do is select the numbers be want to format.
    We can either select only a group of cells or format the entire column or row.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas34 346561.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Click on the arrow below "Format" in the "HOME" tab.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas45 790185.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    Click on "Format Cells" at the bottom.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas49 864913.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Now we're going to stay in the "Number" tab and select what we would like.
    We can make it show a percentage, scientific, special, custom, text, whatever we wish. In this particular case, we are going to select "Currency" because these are sales numbers in a dollar value.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas62 749441.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We are going to set it to 2 decimal places because we generally use 2 decimal places.
    The symbol, for this purpose, is a dollar. Use the currency symbol for your location.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas86 416636.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We can also decide what we want to do with negative numbers.
    We can set it to put a negative symbol in front of it, we can choose to have it displayed in red, or we can choose to have it displayed in red with a negative symbol. Click on "OK".
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas108 940583.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We can see there are now hashtag symbols showing in column E, row 4, that just simply means that the cell is not wide enough.
    Click on the edge of the column and drag to extend it.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas115 500158.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Now we can see that it is formatted as a currency display in this particular area.
    If we wanted the entire row or column to display future information like that, we would click on a column or row and apply that formatting to it.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas135 864241.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    The other way we can do it is to select the area we wish to format and right-click it.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas155 289696.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Click on "Format Cells".
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas156 71894.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    It opens the same window as before.
    How to Format Cells in MS Excel 2013 part 4 of 5 Formatting Numbers.mp4-canvas161 742626.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    That is how you format numbers in Microsoft Excel 2013.
    Thank you for watching VisiHow. If you have any questions or comments regarding this video, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No | I need help

Video: Format Cells in Microsoft Excel 2013 Formatting Numbers

Cell Styles

Hello and welcome to VisiHow. We are going to continue with our series on how to format cells in Microsoft Excel 2013. In this tutorial, we will learn how to format the cell styles. If you haven't used Microsoft Excel 2013 before and this is your first time, we strongly recommend that you check out some of the other Microsoft Excel tutorials, such as this article on how to navigate Microsoft Excel: http://visihow.com/Navigate_Microsoft_Excel_2013, as well as this article on how to create a workbook: http://visihow.com/Create_Project_from_a_Blank_Microsoft_Excel_2013_Workbook. Once you're done checking those out, come back and join us for this one.

Was this helpful? Yes | No | I need help

How to Format Cells in MS Excel 2013 part 5 of 5 Cell Styles.mp4-canvas0.jpg

Steps

  1. 1
    The first thing we are going to do is select the numbers be want to format.
    We can either select only a group of cells or format an entire column or row. We will select a column.
    How to Format Cells in MS Excel 2013 part 5 of 5 Cell Styles.mp4-canvas47 725623.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Once the area is selected, we need to click on the arrow below "Cell Styles" in the "HOME" tab.
    How to Format Cells in MS Excel 2013 part 5 of 5 Cell Styles.mp4-canvas67 340397.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    Here we can select the style that we wish to have.
    This is not necessary, it's just an option that's available. As we hover over them, it shows a preview of what it will look like. We can also choose how we want it to behave. For example, a linked cell, a note, warning text, output, etc. At the bottom, we can merge styles as well as create a new cell style.
    How to Format Cells in MS Excel 2013 part 5 of 5 Cell Styles.mp4-canvas77 68542.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    If we select a row, we can click on "Cell Styles" again and hover over the different styles.
    The row will change accordingly to show a preview.
    How to Format Cells in MS Excel 2013 part 5 of 5 Cell Styles.mp4-canvas134 940514.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We can also select the entire table and click on "Cell Styles".
    It will change the entire table. This is just a way to quickly find preset styles.
    How to Format Cells in MS Excel 2013 part 5 of 5 Cell Styles.mp4-canvas146 908772.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    That is how you format the cell styles in Microsoft Excel 2013.
    Thank you for watching VisiHow. If you have any questions or comments regarding this video, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No | I need help

    Advertisement

Video: Format Cells in Microsoft Excel 2013 Cell Styles

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Creachhigher
Featured Author
34 Articles Started
1,088 Article Edits
6,075 Points
Creachhigher is a featured author with VisiHow. Creachhigher has achieved the level of "Sergeant" with 6,075 points. Creachhigher has started 34 articles (including this one) and has also made 1,088 article edits. 17,200 people have read Creachhigher's article contributions.
Creachhigher's Message Board
Creachhigher: Hi, my name is Creachhigher.
Creachhigher: Can I help you with your problem about "Format Cells in Microsoft Excel 2013"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Eng, Crystal, Colette Cole

Share this Article:

Thanks to all authors for creating a page that has been read 261 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No