Modify Columns and Rows in Microsoft Excel 2013

Edited by Colette Cole, Crystal, Eng, Inukshuk and 1 other

...More
Ad

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

Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas5 9.jpg

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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas52 412891.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas55 346705.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas110 485753.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas142 459409.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas184 486464.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas203 223468.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas217 153152.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Go up to the ribbon and click on the "Home" tab.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas227 827799.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas242 977155.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas259 309493.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas264 398178.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas298 717484.jpg
    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".
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas312 764121.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas321 155244.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas342 782525.jpg
    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".
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas359 28535.jpg
    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.
    Modifying Columns and Rows MS EXCEL 2013 1 of 8.mp4-canvas386 88.jpg
    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

How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas119 081988.jpg

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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas51 681976.jpg
    Was this step helpful? Yes | No | I need help

  2. 2
    Let it load.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas73 386295.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas92 126457.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas119 951015.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We are going to left-click, and it will show the height.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas126 711241.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas139 703913.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas150 148112.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas172 258733.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas177 292921.jpg
    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".
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas196 119417.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas200 204495.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas228 221728.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    We can also click on "FILE".
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas231 699679.jpg
    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.
    How to modify columns and rows in MS Excel 2013 part 2 of 8 Modify Row Height.mp4-canvas234 659513.jpg
    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

How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas115 145305.jpg

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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas46 721434.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas78 762104.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas104 338175.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas125 744843.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas134 641293.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas150 848136.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    Release the mouse, and all of the columns will be that width.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas166 271172.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas196 755609.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas205 117759.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas215 773929.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas228 711787.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    We can also click on "FILE".
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas240 261047.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 3 of 8 Simultaneously.mp4-canvas242 980877.jpg
    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

How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas119 927524.jpg

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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas44 681417.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas68 295941.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas87 792392.jpg
    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".
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas98 594515.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas106 650345.jpg
    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".
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas127 107423.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas134 509627.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas144 012182.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas157 537357.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    To delete the row, simply right-click it again and click "Delete".
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas171 766804.jpg
    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".
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas185 109973.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    That will insert a new column on the left side.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas186 622524.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    To delete that column, right-click again and click on "Delete.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas193 704751.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas202 94051.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas240 917011.jpg
    Was this step helpful? Yes | No | I need help

  16. 16
    We can also click on "FILE".
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas248 922052.jpg
    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.
    How to Modify Columns and Rows in Microsoft Excel 2013 part 4 of 8 insert and delete columns and rows.mp4-canvas251 939843.jpg
    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

How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas0.jpg

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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas42 785019.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas81 96024.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas104 573169.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas118 768457.jpg
    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".
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas139 443971.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas153 904795.jpg
    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".
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas172 750271.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas181 202396.jpg
    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".
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas193 707469.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Under "Text Control", we are going to click on "Merge Cells".
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas198 897286.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    Once that's done, we can click "OK".
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas201 962115.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas203 966326.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas211 591832.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    We can also click on "FILE".
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas219 933334.jpg
    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.
    How to Modify Columns and Rows in MS Excel 2013 pt 5 of 8 Merge and Center 1.mp4-canvas232 892524.jpg
    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

How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas5 3.jpg

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.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas46 698576.jpg
    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".
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas61 317109.jpg
    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.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas68 794665.jpg
    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.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas78 830374.jpg
    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".
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas102 627226.jpg
    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".
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas116 204047.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    We can do the exact same thing with a row.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas128 634558.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    We can also use the "Format" tool to hide & unhide a row.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas141 340451.jpg
    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.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas150 459535.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    We can also click on "FILE".
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas155 017604.jpg
    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.
    How to modify columns and rows In Ms Excel 2013 part 6 of 8 hide and unhide.mp4-canvas156 405017.jpg
    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

How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas4.jpg

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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas28 460886.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas43 061643.jpg
    Was this step helpful? Yes | No | I need help

  3. 3
    We can also right-click the row and select "Cut".
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas51 274469.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas55 468894.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas74 689038.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas85 516037.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas112 76667.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas118 099172.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    We need to select the information by clicking and dragging, then cut it.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas123 710491.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas130 237086.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    It has now moved over to column L.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas140 295127.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    We will undo it by clicking the undo button at the top-left.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas144 849509.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas161 448166.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    We can also click on "FILE".
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas163 765374.jpg
    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.
    How to Modify Columns and Rows In MS Excel 2013 pt 8 of 8 .mp4-canvas165 311944.jpg
    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

How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas0.jpg

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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas19 227963.jpg
    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".
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas48 608639.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas88 073851.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas108 93437.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas114 835322.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We want to click on "Formulas" to look at the formula options.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas123 929997.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas146 936547.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Then, we want to click on "OK".
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas150 107035.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas156 837281.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas167 929924.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas179 980492.jpg
    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".
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas195 665308.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    Go back to the "Options" by clicking on it.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas201 744928.jpg
    Was this step helpful? Yes | No | I need help

  14. 14
    Click on the "Formulas" tab.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas204 720742.jpg
    Was this step helpful? Yes | No | I need help

  15. 15
    Uncheck the box next to "R1C1" reference style.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas207 835214.jpg
    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.
    How To Modify Columns And Rows In Ms Excel 2013 Pt 7 Of 8 Changing Reference Style.mp4-canvas212 731224.jpg
    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

    Advertisement

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

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 "Modify Columns and Rows in Microsoft Excel 2013"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Inukshuk, Eng, Crystal

Share this Article:

Thanks to all authors for creating a page that has been read 377 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