Note that you need to keep the Shift key pressed till the entire group of selected cells is part of your selection. While the steps outlined above were performed in Microsoft Excel 2010, they will also work in other versions of Microsoft’s spreadsheet application, such as Excel 2013, Excel 2016, and Excel for office 365Īs mentioned earlier, you can move rows in Excel by clicking the first row that you wish to move, holding the Shift key on your keyboard, then clicking the bottom row that you want to move.
EXCEL SHIFT CELLS RIGHT HOW TO
More Information on How to Move a Row in Excel 2010 Our guide continues below with additional discussion on moving rows in Excel. Note that you can select a range of multiple rows by clicking the top row that you wish to move, then holding the Shift key on your keyboard and clicking the bottom row that you wish to move. Step 2: Locate the row number of the row that you want to move, then click the row number once to select the entire row. Step 1: Open the spreadsheet containing the row that you want to move. But you can continue below to move a row in Excel and see how the functionality works, which can give you a clearer understanding of how rows and columns interact within the context of your entire Excel spreadsheet. You can read here to learn how to move columns in Excel as well. The steps that are required to move a row in Microsoft Excel 2010 are very similar to the steps required to move a column. How Do You Move a Row in Excel? (Guide with Pictures) Our tutorial continues below with additional information on moving a row in Excel 2010, including pictures of these steps. Right-click the selected row number, then click the Insert Cut Cells option.Click the row number under where you would like to insert the row that you just cut.Right-click the selected row, then click the Cut option.Select the row number that you want to move.4 Additional Sources How to Move Entire Row in Excel 2010
0 kommentar(er)
