Modify Columns and Rows in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng, Inukshuk

...More

Modify Column Width

Welcome to VisiHow, I'm so pleased you could join us. In this video, we are going to begin the series of 8 videos on how to modify columns and rows in Microsoft Excel 2013. This first video is going to deal with modifying the column width.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    To begin, open Microsoft Excel 2013
    .
    If you've never used Microsoft Excel and this is your first time, I would strongly suggest taking a look at this article on how to navigate Microsoft Excel 2013: http://visihow.com/Navigate_Microsoft_Excel_2013, then come back and join us. My Excel is pinned to the taskbar at the bottom, it is the green book icon with the white "X", so I will click it to open it.
    Advertisement
    Was this step helpful? Yes | No| I need help
  2. 2
    If you do not know where Excel is located on your computer, simply use the Search function
    .
    For Windows 8, move the mouse to the right and click "Search". Type in Excel and you should see it in the list. For Windows 7 and earlier, press the start menu and there will be a search bar there.
    Advertisement
    Was this step helpful? Yes | No| I need help
  3. 3
    Now we are in the main page of Excel and there are options to open a blank workbook or use a template, but in this case, I'm going to work on something that I've already started
    .
    On the left side, there is a "Recent" list, which displays the most recently worked on workbook. There are a couple of workbooks there, and I can also click on "Open other Workbooks" to find a workbook that way. For this tutorial, I'm going to use the "Monthly Sales Figures" document, so I will click on that to open it.
    Was this step helpful? Yes | No| I need help
  4. 4
    As you can see, I've already started my workbook
    .
    You'll notice that there are some issues because one of the weeks is cut off and the number is not visible. There are some hashtag symbols, which means that there is data in that cell, but we can't see it since the cell isn't wide enough. To fix this, the column width needs to be adjusted. There are a few ways to adjust the column width.
    Was this step helpful? Yes | No| I need help
  5. 5
    The first way is one of the most commonly used and convenient ways of doing it
    .
    The cursor is currently a white cross, but when I move it up to the columns it changes to a black double arrow. Make sure that the cursor is at the end of the column that you want to adjust, then left-click and hold the mouse button down. Now, it says "Width" with some numbers beside it.
    Was this step helpful? Yes | No| I need help
  6. 6
    As I move the cursor over, the number increases and the column gets bigger
    .
    The same thing will happen if the cursor is moved the other way; the number gets smaller and the column gets narrower. Moving the cursor to the right increases the column width, and moving to the left decreases it. That is one simple way to adjust the column width.
    Was this step helpful? Yes | No| I need help
  7. 7
    Another way to adjust the column width is by selecting the column you want to adjust by left-clicking on the letter
    .
    When the column is highlighted, it is selected.
    Was this step helpful? Yes | No| I need help
  8. 8
    Go up to the ribbon and click on the "Home" tab
    .
    Was this step helpful? Yes | No| I need help
  9. 9
    Find the section that says "Cells" and click on "Format"
    .
    A little menu will pop up, where you can select "Column Width". This will open up a new window.
    Was this step helpful? Yes | No| I need help
  10. 10
    In the new window, there is a number in the text box
    .
    This is the same number Excel shows when you adjusted the column by clicking and dragging. For example, we can type in "7.5" and click OK.
    Was this step helpful? Yes | No| I need help
  11. 11
    The column has been extended
    .
    You can also decrease the width by going back to "Format" then "Column Width" and typing in a smaller number.
    Was this step helpful? Yes | No| I need help
  12. 12
    Another way to modify the column width is to go back to "Format" and click "AutoFit Column Width"
    .
    AutoFit adjusts the column to an appropriate size so that whenever you input information and the size gets bigger, it will adjust the width to fit that particular section.
    Was this step helpful? Yes | No| I need help
  13. 13
    Another way to modify the column is to select the column again by clicking the letter, right-click, and in the menu that pops up you can select "Column Width"
    .
    Was this step helpful? Yes | No| I need help
  14. 14
    The same box will come up, where you can enter the size or number you would like to adjust it to
    .
    Was this step helpful? Yes | No| I need help
  15. 15
    Just a reminder, if you make any little change in Microsoft Excel 2013, remember to save it, especially when you're pleased with what you've done and it looks good
    .
    Click on Save, which is in the upper left corner, which looks like an old-fashioned floppy disk. You can also press Ctrl + S simultaneously, which will do the exact same thing.
    Was this step helpful? Yes | No| I need help
  16. 16
    You can also go to "File" in the top left and then click "Save" or "Save As"
    .
    Was this step helpful? Yes | No| I need help
  17. 17
    This concludes our tutorial on how to adjust the column width when using Microsoft Excel 2013
    .
    If you have any questions or comments on this video, please leave them in the section below. Thank you for watching VisiHow.
    Was this step helpful? Yes | No| I need help

Video: Modify Columns and Rows in Microsoft Excel 2013 Modifying Column Width

Modify Row Height

Welcome to VisiHow. We're going to continue with our series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we are focusing on how to modify the row height. If you haven't used Microsoft Excel 2013 before and this is your first time, we strongly recommend that you check out this article on how to navigate Microsoft Excel: http://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well: http://visihow.com/Create_Project_from_a_Blank_Microsoft_Excel_2013_Workbook. Then, come back for this one. Let's begin.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first thing we want to do is open Microsoft Excel 2013
    .
    We have it pinned to the taskbar, so we will click it. It's the green book icon with a white 'x' on it. If yours is not pinned to your taskbar, find it in the start menu. If you're not sure where it is, simply go to the search function and type in "Excel", and it should bring it up.
    Was this step helpful? Yes | No| I need help
  2. 2
    Let it load
    .
    Was this step helpful? Yes | No| I need help
  3. 3
    When we get to the starting page of Excel 2013, we're going to see the landing page
    .
    This page shows the templates and the option for a blank workbook. In this particular case, we're going to open an existing workbook. On the left, it shows the most recent workbooks that have been worked on, so we're going to open up one of those.
    Was this step helpful? Yes | No| I need help
  4. 4
    Once we have the workbook open, we're going to move the cursor between the rows that we want to modify
    .
    Was this step helpful? Yes | No| I need help
  5. 5
    We are going to left-click, and it will show the height
    .
    Was this step helpful? Yes | No| I need help
  6. 6
    We can left-click, hold it, and drag it up or down
    .
    The numbers will change with the row height.
    Was this step helpful? Yes | No| I need help
  7. 7
    Once we're satisfied with the row height, we simply release the mouse button and the row height will be changed
    .
    Was this step helpful? Yes | No| I need help
  8. 8
    The other way is to click on "Format" at the top, and click on "Row Height" in the "Cell Size" section
    .
    This is in the "Home" tab.
    Was this step helpful? Yes | No| I need help
  9. 9
    We can change the number and hit "Enter" or click "OK" to change the row height
    .
    Was this step helpful? Yes | No| I need help
  10. 10
    Another way to change the row height is to select the row by clicking on the number, right-click, and click "Row Height"
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    That will open up the same window where we can change the number and hit "Enter" or click "OK" to change the row height
    .
    Was this step helpful? Yes | No| I need help
  12. 12
    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
  13. 13
    We can also click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  14. 14
    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
  15. 15
    That is how you modify the row height in Microsoft Excel 2013
    .
    Thank you for watching VisiHow. If you have any questions or comments, please feel free to leave them in the comment section below. Take care.
    Was this step helpful? Yes | No| I need help

Video: Modify Columns and Rows in Microsoft Excel 2013 Modify Row Height

Modify Column Width and Row Height Simultaneously

Hello, welcome to VisiHow. We are going to continue the series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we're going to focus on modifying columns and rows simultaneously.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first thing we want to do is open Microsoft Excel 2013
    .
    We have it pinned to the taskbar, so we will click it. It's the green book icon with a white 'x' on it. If you're not sure where it is, simply go to the search function and type in "Excel", and it should bring it up. If you haven't used Microsoft Excel 2013 before and this is your first time, we strongly recommend that you check out this article on how to navigate Microsoft Excel: http://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well: http://visihow.com/Create_Project_from_a_Blank_Microsoft_Excel_2013_Workbook.
    Was this step helpful? Yes | No| I need help
  2. 2
    Once Excel opens, we're going to see the landing page
    .
    This page shows the templates and the option for a blank workbook. In this particular case, we're going to open an existing workbook. On the left, it shows the most recent workbooks that have been worked on, so we're going to open up one of those. To adjust all of the columns and rows simultaneously, the first thing we need to do is select the whole workbook.
    Was this step helpful? Yes | No| I need help
  3. 3
    To do that, we're going to click on the 'select all' icon, which is where the cursor is (the white plus symbol)
    .
    It's a little triangle in the upper left-hand corner of the worksheet. That will select the entire page.
    Was this step helpful? Yes | No| I need help
  4. 4
    First of all, we're going to modify the columns, so we will hover the cursor between two columns
    .
    The cursor is in between column A and column B, in this case.
    Was this step helpful? Yes | No| I need help
  5. 5
    If we left-click, it will show the "Width" with the number, which is basically the measurement and the pixel amount
    .
    Was this step helpful? Yes | No| I need help
  6. 6
    Left-click, hold it, then drag it to the right or left to modify the column width
    .
    Was this step helpful? Yes | No| I need help
  7. 7
    Release the mouse, and all of the columns will be that width
    .
    Was this step helpful? Yes | No| I need help
  8. 8
    We can do the same thing with the rows while it is selected
    .
    Hover the cursor between two rows and it will turn into a double arrow. Left-click to see the height and pixel amount.
    Was this step helpful? Yes | No| I need help
  9. 9
    Now hold the left mouse button and adjust the height to the wanted height
    .
    Was this step helpful? Yes | No| I need help
  10. 10
    Once we're at the height that we wish to leave it at, we simply let go of the left mouse button, and all of the rows will be adjusted to the same height
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    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
  12. 12
    We can also click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  13. 13
    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
  14. 14
    That is how you modify the column width or row height simultaneously 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.
    Was this step helpful? Yes | No| I need help

Video: Modify Columns and Rows in Microsoft Excel 2013 Modify Column Width and Row Height Simultaneously

Insert and Delete Columns and Rows

Hello, welcome to VisiHow. We are going to continue the series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we're going to focus on how to insert and delete rows and columns in a spreadsheet or workbook.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first thing we want to do is open Microsoft Excel 2013
    .
    If you haven't used Microsoft Excel 2013 before and this is your first time, we strongly recommend that you check out this article on how to navigate Microsoft Excel: http://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well: http://visihow.com/Create_Project_from_a_Blank_Microsoft_Excel_2013_Workbook. We have Excel pinned to the taskbar, so we will click it. It's the green book icon with a white 'x' on it. If you're not sure where it is, simply go to the search function and type in "Excel", and it should bring it up.
    Was this step helpful? Yes | No| I need help
  2. 2
    Once Excel opens, we're going to see the landing page
    .
    This page shows the templates and the option for a blank workbook. In this particular case, we're going to open an existing workbook. On the left, it shows the most recent workbooks that have been worked on, so we're going to open up one of those.
    Was this step helpful? Yes | No| I need help
  3. 3
    The first way we can insert a column or row is to select a row or column by clicking on the number
    .
    In this case, we're going to add a row.
    Was this step helpful? Yes | No| I need help
  4. 4
    If we want to insert another row, we need to click on "Insert" at the top, then click on "Insert Sheet Rows"
    .
    Was this step helpful? Yes | No| I need help
  5. 5
    It places a row above the selected row, so the row that was number 1 becomes number 2
    .
    Was this step helpful? Yes | No| I need help
  6. 6
    To delete that row, click on "Delete", which is beside "Insert" in the "HOME" tab of the ribbon, then click on "Delete Sheet Rows"
    .
    Was this step helpful? Yes | No| I need help
  7. 7
    The row has been deleted
    .
    This delete function can be used to remove any row.
    Was this step helpful? Yes | No| I need help
  8. 8
    For example, if Diane is no longer with the company, we can select that row and click on "Delete", then "Delete Sheet Rows"
    .
    That's the first way to insert and delete rows.
    Was this step helpful? Yes | No| I need help
  9. 9
    Another way to do it is right-click on a row and click on "Insert" in the menu
    .
    It will insert a row above.
    Was this step helpful? Yes | No| I need help
  10. 10
    To delete the row, simply right-click it again and click "Delete"
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    The same thing works for columns, so we can right-click on a column and click on "Insert"
    .
    Was this step helpful? Yes | No| I need help
  12. 12
    That will insert a new column on the left side
    .
    Was this step helpful? Yes | No| I need help
  13. 13
    To delete that column, right-click again and click on "Delete
    .
    Was this step helpful? Yes | No| I need help
  14. 14
    We can also use the "Insert" and "Delete" functions in the "HOME" tab in the ribbon at the top
    .
    Was this step helpful? Yes | No| I need help
  15. 15
    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
  16. 16
    We can also click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  17. 17
    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
  18. 18
    That is how to insert and delete rows and columns 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.
    Was this step helpful? Yes | No| I need help

Video: Modify Columns and Rows in Microsoft Excel 2013 Insert and Delete Columns and Rows

Merge and Center Cells

Hello and welcome to VisiHow. We are going to continue with our series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we are going to focus on how to merge and center cells in the program.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first thing we want to do is open Microsoft Excel 2013
    .
    If you haven't used Microsoft Excel 2013 before and this is your first time, we strongly recommend that you check out this article on how to navigate Microsoft Excel: http://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well some of the other Excel videos. We have Excel pinned to the taskbar, so we will click it. It's the green book icon with a white 'x' on it. If you're not sure where it is, simply go to the search function and type in "Excel", and it should bring it up.
    Was this step helpful? Yes | No| I need help
  2. 2
    Once Excel opens, we're going to see the landing page
    .
    This page shows the templates and the option for a blank workbook. In this particular case, we're going to open an existing workbook. On the left, it shows the most recent workbooks that have been worked on, so we're going to open up one of those.
    Was this step helpful? Yes | No| I need help
  3. 3
    Once that's opened, we can see that we have a title in the top left-hand corner, and it's primarily in the left cell
    .
    It's not spanning, it's not very nice, it's just kind of in the corner. We want to make this look a little more professional by spanning it across the cells in the chart, in this particular table.
    Was this step helpful? Yes | No| I need help
  4. 4
    We're going to left-click, and drag across the area that we want to span this
    .
    There are a couple ways we can do this.
    Was this step helpful? Yes | No| I need help
  5. 5
    The easiest is to go to the "HOME" tab at the top in the ribbon, and tap on the arrow next to the "Merge and Center" option
    .
    We can select different styles. "Merge and Center", "Merge Across", "Merge Cells", and so on. We want to "Merge and Center".
    Was this step helpful? Yes | No| I need help
  6. 6
    As we can see, it has now spanned across
    .
    It's basically become one big cell across these other cells, in this particular table. That is one way we can do it.
    Was this step helpful? Yes | No| I need help
  7. 7
    Another way we can do this is to select the area again by clicking and dragging, then we're going to right-click and click on "Format Cells"
    .
    Was this step helpful? Yes | No| I need help
  8. 8
    Now we're going to click on "Alignment", the second tab at the top
    .
    Was this step helpful? Yes | No| I need help
  9. 9
    We'll see there is a "Horizontal" and "Vertical" option
    .
    So, for "Horizontal", we're going to click on the drop-down menu and click "Center".
    Was this step helpful? Yes | No| I need help
  10. 10
    Under "Text Control", we are going to click on "Merge Cells"
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    Once that's done, we can click "OK"
    .
    Was this step helpful? Yes | No| I need help
  12. 12
    As we can see, we have merged and centered it by using the format menu
    .
    Was this step helpful? Yes | No| I need help
  13. 13
    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
  14. 14
    We can also click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  15. 15
    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
  16. 16
    That is how you merge and center 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: Modify Columns and Rows in Microsoft Excel 2013 Merge and Center Cells

Hide and Unhide

Hello, welcome to VisiHow. We are going to continue the series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we are going to focus on how to hide and unhide rows and columns. The reason that we would want to hide or unhide a row or column would be because we don't want it to be visible but we want it available if we ever need to view that data again, whereas when we delete something, it's permanently gone. There are two ways we can do this.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first way is to select the column or row that we want to hide by clicking on the letter or number
    .
    We have selected column E.
    Was this step helpful? Yes | No| I need help
  2. 2
    We will then make sure we are in the "HOME" tab up top, and click on the arrow below "Format"
    .
    Was this step helpful? Yes | No| I need help
  3. 3
    Go down and hover the mouse over "Hide & Unhide" which is under the "Visibility" section
    .
    We will click on "Hide Columns" to hide column E.
    Was this step helpful? Yes | No| I need help
  4. 4
    Now, column E is hidden
    .
    It's still available there if we need it, but we don't want to see that particular column.
    Was this step helpful? Yes | No| I need help
  5. 5
    If we do want to unhide it, we can click on the "Format" arrow again, hover over "Hide & Unhide", and click on "Unhide Columns"
    .
    Was this step helpful? Yes | No| I need help
  6. 6
    The same thing can be done by clicking on the column or row to select it, then right-clicking and selecting "Hide" or "Unhide"
    .
    Was this step helpful? Yes | No| I need help
  7. 7
    We can do the exact same thing with a row
    .
    Was this step helpful? Yes | No| I need help
  8. 8
    We can also use the "Format" tool to hide & unhide a row
    .
    Was this step helpful? Yes | No| I need help
  9. 9
    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
  10. 10
    We can also click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    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
  12. 12
    That is how to hide and unhide columns and rows 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: Modify Columns and Rows in Microsoft Excel 2013 Hide and Unhide

Move Information

Hello, welcome to VisiHow. We are going to continue the series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we will show you how to move information from one row to another and one column to another. It's a very simple process.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first thing we're going to do is select the column or row that we want to move the information from
    .
    In this example, we will take Lucy's information from row 6 and move it somewhere else.
    Was this step helpful? Yes | No| I need help
  2. 2
    Once the row is selected, we can either go up to the "HOME" tab and select "Cut" or press Ctrl + X to cut
    .
    Was this step helpful? Yes | No| I need help
  3. 3
    We can also right-click the row and select "Cut"
    .
    Was this step helpful? Yes | No| I need help
  4. 4
    Whenever we cut things in Excel, it doesn't disappear right away like other programs
    .
    It outlines the selected area and has a border with moving dashes. Now we need to select the row we're going to move it to.
    Was this step helpful? Yes | No| I need help
  5. 5
    We're going to select the row we want to move it to and press "Paste" at the top, press Ctrl + V to paste, or right-click the row and select "Paste"
    .
    In this example, we're pasting to row 13.
    Was this step helpful? Yes | No| I need help
  6. 6
    We'll see that all of the information has moved down
    .
    We will move this row back. by undoing it.
    Was this step helpful? Yes | No| I need help
  7. 7
    We can do the same thing with columns; we click on the column we want to move the information from and choose one of the 3 methods to "Cut" the information
    .
    Was this step helpful? Yes | No| I need help
  8. 8
    If we're trying to cut a merged cell, it won't allow us
    .
    Was this step helpful? Yes | No| I need help
  9. 9
    We need to select the information by clicking and dragging, then cut it
    .
    Was this step helpful? Yes | No| I need help
  10. 10
    Now, choose one of the 3 methods to paste it
    .
    We will move it over to column L.
    Was this step helpful? Yes | No| I need help
  11. 11
    It has now moved over to column L
    .
    Was this step helpful? Yes | No| I need help
  12. 12
    We will undo it by clicking the undo button at the top-left
    .
    Was this step helpful? Yes | No| I need help
  13. 13
    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
  14. 14
    We can also click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  15. 15
    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
  16. 16
    That is how to move information from column to column and from row to row 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: Modify Columns and Rows in Microsoft Excel 2013 Move Information

Changing Reference Style

Hello, welcome to VisiHow. We are going to continue the series on how to modify columns and rows in Microsoft Excel 2013. In this tutorial, we are going to focus on how to change the reference styles.

Was this helpful? Yes | No| I need help

Steps

  1. 1
    The first thing we need to do is open Excel
    .
    We already have it opened to a blank workbook. 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 as well: 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 step helpful? Yes | No| I need help
  2. 2
    We can see that we have columns and rows in our workbook
    .
    The columns are the letters at the top, and the rows are the numbers on the side. This particular reference style is known as "A1" style. This is because it names the cells according to their location. So, Column A & Row 1 would be "A1". If it is Column B Row 1, it's "B1".
    Was this step helpful? Yes | No| I need help
  3. 3
    We will notice as we click around, that the reference at the top left area, under the clipboard, shows us which cell we're on
    .
    There are many reasons someone would change this. Some people find that numerically is easier, and with some companies it is standard.
    Was this step helpful? Yes | No| I need help
  4. 4
    In order to change the reference style, we're simply going to click on the "FILE" tab
    .
    Was this step helpful? Yes | No| I need help
  5. 5
    Click on "Options" at the bottom, in the green section on the left-hand side
    .
    Once that window opens up for us, we're going to see several tabs on the left-hand side.
    Was this step helpful? Yes | No| I need help
  6. 6
    We want to click on "Formulas" to look at the formula options
    .
    Was this step helpful? Yes | No| I need help
  7. 7
    We will notice that we have the option of changing our "A1" reference style to "R1C1 reference style"
    .
    It's currently not checked, so we'll click the box to check it.
    Was this step helpful? Yes | No| I need help
  8. 8
    Then, we want to click on "OK"
    .
    Was this step helpful? Yes | No| I need help
  9. 9
    We will immediately notice that it has changed to R1C1, which basically means Row 1 Column 1
    .
    Was this step helpful? Yes | No| I need help
  10. 10
    Now, if we click around to different cells, the reference has changed to a row identifier and column identifier instead of a letter and number
    .
    Was this step helpful? Yes | No| I need help
  11. 11
    Right now, we've clicked on Row 12 (R12) and Column 8 (C8)
    .
    We can see how some people might find this easier, instead of going by the letters of the alphabet and numbers.
    Was this step helpful? Yes | No| I need help
  12. 12
    If we decide we don't like this reference style and we want to change it back to the old way, we can click on "FILE"
    .
    Was this step helpful? Yes | No| I need help
  13. 13
    Go back to the "Options" by clicking on it
    .
    Was this step helpful? Yes | No| I need help
  14. 14
    Click on the "Formulas" tab
    .
    Was this step helpful? Yes | No| I need help
  15. 15
    Uncheck the box next to "R1C1" reference style
    .
    Was this step helpful? Yes | No| I need help
  16. 16
    Click on "OK"
    .
    This is an immediate change. Changing the reference style at any stage in your workbook will not affect the workbook. It's just going to affect how it is viewed, although we would recommend sticking with one reference style so we don't get confused.
    Was this step helpful? Yes | No| I need help
  17. 17
    That's it
    .
    That's how you change the reference style 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.
    Was this step helpful? Yes | No| I need help

Video: Modify Columns and Rows in Microsoft Excel 2013 Changing Reference Style

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: Eng, Crystal, Colette Cole

Share this Article:

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

x

Thank Our Volunteer Authors.

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