Format Cells in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng

...More

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

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.
    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.
    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.
    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.
    Was this step helpful? Yes | No| I need help
  5. 5
    We can bold it by clicking on the "B"
    .
    Was this step helpful? Yes | No| I need help
  6. 6
    We can italicize it by clicking on the "I"
    .
    Was this step helpful? Yes | No| I need help
  7. 7
    We can underline it by clicking on the "You"
    .
    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.
    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.
    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
    .
    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.
    Was this step helpful? Yes | No| I need help
  12. 12
    We can also do that with rows as well by selecting the row
    .
    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
    .
    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
    .
    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.
    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
    .
    Was this step helpful? Yes | No| I need help
  17. 17
    We can also click on "FILE"
    .
    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.
    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.

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.
    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.
    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.
    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
    .
    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.
    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.
    Was this step helpful? Yes | No| I need help
  7. 7
    We can also increase and decrease the indent
    .
    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"
    .
    Was this step helpful? Yes | No| I need help
  9. 9
    Then, we can click on the "Alignment" tab
    .
    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
    .
    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
    .
    Was this step helpful? Yes | No| I need help
  12. 12
    Then we would simply click on "OK"
    .
    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
    .
    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.

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
    .
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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
    .
    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.
    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
    .
    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

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.
    Was this step helpful? Yes | No| I need help
  2. 2
    Click on the arrow below "Format" in the "HOME" tab
    .
    Was this step helpful? Yes | No| I need help
  3. 3
    Click on "Format Cells" at the bottom
    .
    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.
    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.
    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".
    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.
    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.
    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
    .
    Was this step helpful? Yes | No| I need help
  10. 10
    Click on "Format Cells"
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    It opens the same window as before
    .
    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

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.
    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
    .
    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.
    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.
    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.
    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

Video: Format Cells in Microsoft Excel 2013 Cell Styles

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

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

Article Info

Categories : Microsoft Suites

Recent edits by: Crystal, Colette Cole

Share this Article:

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

x

Thank Our Volunteer Authors.

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