Modify Columns and Rows in Microsoft Excel 2013
Edited by Colette Cole, Crystal, Eng, Inukshuk and 1 other
25 Parts:
...More
Contents
- 1 Modify Column Width
- 2 Steps
- 3 Video: Modify Columns and Rows in Microsoft Excel 2013 Modifying Column Width
- 4 Modify Row Height
- 5 Steps
- 6 Video: Modify Columns and Rows in Microsoft Excel 2013 Modify Row Height
- 7 Modify Column Width and Row Height Simultaneously
- 8 Steps
- 9 Video: Modify Columns and Rows in Microsoft Excel 2013 Modify Column Width and Row Height Simultaneously
- 10 Insert and Delete Columns and Rows
- 11 Steps
- 12 Video: Modify Columns and Rows in Microsoft Excel 2013 Insert and Delete Columns and Rows
- 13 Merge and Center Cells
- 14 Steps
- 15 Video: Modify Columns and Rows in Microsoft Excel 2013 Merge and Center Cells
- 16 Hide and Unhide
- 17 Steps
- 18 Video: Modify Columns and Rows in Microsoft Excel 2013 Hide and Unhide
- 19 Move Information
- 20 Steps
- 21 Video: Modify Columns and Rows in Microsoft Excel 2013 Move Information
- 22 Changing Reference Style
- 23 Steps
- 24 Video: Modify Columns and Rows in Microsoft Excel 2013 Changing Reference Style
- 25 Comments
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.
Steps
- 1If 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: https://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.To begin, open Microsoft Excel 2013.
- 2For 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.If you do not know where Excel is located on your computer, simply use the Search function.
- 3On 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.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.
- 4You'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.As you can see, I've already started my workbook.
- 5The 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.The first way is one of the most commonly used and convenient ways of doing it.
- 6The 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.As I move the cursor over, the number increases and the column gets bigger.
- 7When the column is highlighted, it is selected.Another way to adjust the column width is by selecting the column you want to adjust by left-clicking on the letter.
- 8Go up to the ribbon and click on the "Home" tab.
- 9A little menu will pop up, where you can select "Column Width". This will open up a new window.Find the section that says "Cells" and click on "Format".
- 10This 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.In the new window, there is a number in the text box.
- 11You can also decrease the width by going back to "Format" then "Column Width" and typing in a smaller number.The column has been extended.
- 12AutoFit 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.Another way to modify the column width is to go back to "Format" and click "AutoFit Column Width".
- 13Another 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".
- 14The same box will come up, where you can enter the size or number you would like to adjust it to.
- 15Click 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.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.
- 16You can also go to "File" in the top left and then click "Save" or "Save As".
- 17If you have any questions or comments on this video, please leave them in the section below. Thank you for watching VisiHow.This concludes our tutorial on how to adjust the column width when using Microsoft Excel 2013.
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: https://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well: https://visihow.com/Create_Project_from_a_Blank_Microsoft_Excel_2013_Workbook. Then, come back for this one. Let's begin.
Steps
- 1We 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.The first thing we want to do is open Microsoft Excel 2013.
- 2Let it load.
- 3This 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.When we get to the starting page of Excel 2013, we're going to see the landing page.
- 4Once we have the workbook open, we're going to move the cursor between the rows that we want to modify.
- 5We are going to left-click, and it will show the height.
- 6The numbers will change with the row height.We can left-click, hold it, and drag it up or down.
- 7Once we're satisfied with the row height, we simply release the mouse button and the row height will be changed.
- 8This is in the "Home" tab.The other way is to click on "Format" at the top, and click on "Row Height" in the "Cell Size" section.
- 9We can change the number and hit "Enter" or click "OK" to change the row height.
- 10Another way to change the row height is to select the row by clicking on the number, right-click, and click "Row Height".
- 11That will open up the same window where we can change the number and hit "Enter" or click "OK" to change the row height.
- 12We 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.
- 13We can also click on "FILE".
- 14Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.Then click on "Save".
- 15Thank you for watching VisiHow. If you have any questions or comments, please feel free to leave them in the comment section below. Take care.That is how you modify the row height in Microsoft Excel 2013.
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.
Steps
- 1We 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: https://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well: https://visihow.com/Create_Project_from_a_Blank_Microsoft_Excel_2013_Workbook.The first thing we want to do is open Microsoft Excel 2013.
- 2This 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.Once Excel opens, we're going to see the landing page.
- 3It's a little triangle in the upper left-hand corner of the worksheet. That will select the entire page.To do that, we're going to click on the 'select all' icon, which is where the cursor is (the white plus symbol).
- 4The cursor is in between column A and column B, in this case.First of all, we're going to modify the columns, so we will hover the cursor between two columns.
- 5If we left-click, it will show the "Width" with the number, which is basically the measurement and the pixel amount.
- 6Left-click, hold it, then drag it to the right or left to modify the column width.
- 7Release the mouse, and all of the columns will be that width.
- 8Hover the cursor between two rows and it will turn into a double arrow. Left-click to see the height and pixel amount.We can do the same thing with the rows while it is selected.
- 9Now hold the left mouse button and adjust the height to the wanted height.
- 10Once 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.
- 11We 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.
- 12We can also click on "FILE".
- 13Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.Then click on "Save".
- 14Thank 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.That is how you modify the column width or row height simultaneously in Microsoft Excel 2013.
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.
Steps
- 1If 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: https://visihow.com/Navigate_Microsoft_Excel_2013. Take a look at this article on how to create a workbook as well: https://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.The first thing we want to do is open Microsoft Excel 2013.
- 2This 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.Once Excel opens, we're going to see the landing page.
- 3In this case, we're going to add a row.The first way we can insert a column or row is to select a row or column by clicking on the number.
- 4If we want to insert another row, we need to click on "Insert" at the top, then click on "Insert Sheet Rows".
- 5It places a row above the selected row, so the row that was number 1 becomes number 2.
- 6To delete that row, click on "Delete", which is beside "Insert" in the "HOME" tab of the ribbon, then click on "Delete Sheet Rows".
- 7This delete function can be used to remove any row.The row has been deleted.
- 8That's the first way to insert and delete rows.For example, if Diane is no longer with the company, we can select that row and click on "Delete", then "Delete Sheet Rows".
- 9It will insert a row above.Another way to do it is right-click on a row and click on "Insert" in the menu.
- 10To delete the row, simply right-click it again and click "Delete".
- 11The same thing works for columns, so we can right-click on a column and click on "Insert".
- 12That will insert a new column on the left side.
- 13To delete that column, right-click again and click on "Delete.
- 14We can also use the "Insert" and "Delete" functions in the "HOME" tab in the ribbon at the top.
- 15We 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.
- 16We can also click on "FILE".
- 17Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.Then click on "Save".
- 18Thank 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.That is how to insert and delete rows and columns in Microsoft Excel 2013.
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.
Steps
- 1If 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: https://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.The first thing we want to do is open Microsoft Excel 2013.
- 2This 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.Once Excel opens, we're going to see the landing page.
- 3It'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.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.
- 4There are a couple ways we can do this.We're going to left-click, and drag across the area that we want to span this.
- 5We can select different styles. "Merge and Center", "Merge Across", "Merge Cells", and so on. We want to "Merge and Center".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.
- 6It's basically become one big cell across these other cells, in this particular table. That is one way we can do it.As we can see, it has now spanned across.
- 7Another 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".
- 8Now we're going to click on "Alignment", the second tab at the top.
- 9So, for "Horizontal", we're going to click on the drop-down menu and click "Center".We'll see there is a "Horizontal" and "Vertical" option.
- 10Under "Text Control", we are going to click on "Merge Cells".
- 11Once that's done, we can click "OK".
- 12As we can see, we have merged and centered it by using the format menu.
- 13We 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.
- 14We can also click on "FILE".
- 15Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.Then click on "Save".
- 16Thank 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.That is how you merge and center cells in Microsoft Excel 2013.
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.
Steps
- 1We have selected column E.The first way is to select the column or row that we want to hide by clicking on the letter or number.
- 2We will then make sure we are in the "HOME" tab up top, and click on the arrow below "Format".
- 3We will click on "Hide Columns" to hide column E.Go down and hover the mouse over "Hide & Unhide" which is under the "Visibility" section.
- 4It's still available there if we need it, but we don't want to see that particular column.Now, column E is hidden.
- 5If we do want to unhide it, we can click on the "Format" arrow again, hover over "Hide & Unhide", and click on "Unhide Columns".
- 6The same thing can be done by clicking on the column or row to select it, then right-clicking and selecting "Hide" or "Unhide".
- 7We can do the exact same thing with a row.
- 8We can also use the "Format" tool to hide & unhide a row.
- 9We 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.
- 10We can also click on "FILE".
- 11Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.Then click on "Save".
- 12Thank 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.That is how to hide and unhide columns and rows in Microsoft Excel 2013.
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.
Steps
- 1In this example, we will take Lucy's information from row 6 and move it somewhere else.The first thing we're going to do is select the column or row that we want to move the information from.
- 2Once the row is selected, we can either go up to the "HOME" tab and select "Cut" or press Ctrl + X to cut.
- 3We can also right-click the row and select "Cut".
- 4It 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.Whenever we cut things in Excel, it doesn't disappear right away like other programs.
- 5In this example, we're pasting to row 13.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".
- 6We will move this row back. by undoing it.We'll see that all of the information has moved down.
- 7We 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.
- 8If we're trying to cut a merged cell, it won't allow us.
- 9We need to select the information by clicking and dragging, then cut it.
- 10We will move it over to column L.Now, choose one of the 3 methods to paste it.
- 11It has now moved over to column L.
- 12We will undo it by clicking the undo button at the top-left.
- 13We 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.
- 14We can also click on "FILE".
- 15Another way is to hold the "Ctrl" key and then press the "S" button on the keyboard.Then click on "Save".
- 16Thank 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.That is how to move information from column to column and from row to row in Microsoft Excel 2013.
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.
Steps
- 1We 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: https://visihow.com/Navigate_Microsoft_Excel_2013, as well as this article on how to create a workbook as well: https://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.The first thing we need to do is open Excel.
- 2The 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".We can see that we have columns and rows in our workbook.
- 3There are many reasons someone would change this. Some people find that numerically is easier, and with some companies it is standard.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.
- 4In order to change the reference style, we're simply going to click on the "FILE" tab.
- 5Once that window opens up for us, we're going to see several tabs on the left-hand side.Click on "Options" at the bottom, in the green section on the left-hand side.
- 6We want to click on "Formulas" to look at the formula options.
- 7It's currently not checked, so we'll click the box to check it.We will notice that we have the option of changing our "A1" reference style to "R1C1 reference style".
- 8Then, we want to click on "OK".
- 9We will immediately notice that it has changed to R1C1, which basically means Row 1 Column 1.
- 10Now, if we click around to different cells, the reference has changed to a row identifier and column identifier instead of a letter and number.
- 11We can see how some people might find this easier, instead of going by the letters of the alphabet and numbers.Right now, we've clicked on Row 12 (R12) and Column 8 (C8).
- 12If 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".
- 13Go back to the "Options" by clicking on it.
- 14Click on the "Formulas" tab.
- 15Uncheck the box next to "R1C1" reference style.
- 16This 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.Click on "OK".
- 17That'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.That's it.
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
Article Info
Categories : Microsoft Suites
Recent edits by: Inukshuk, Eng, Crystal
