Move Rows and Columns With Cut and PasteĪnother quick way to move rows or columns in Excel is to cut and paste them from one location to another. This method also lets you move multiple adjacent rows or columns at once. Step 4: Keep holding the Shift key and drag and drop the column or row to its new position. Step 3: Hold down the Shift key on your keyboard and click and hold the right or left border of the column (or the top or bottom border of the row). If you want to move a row, click on its row number on the far left. Step 2: Select your column by clicking the column header. Step 1: Open your Excel spreadsheet and navigate to the column or row you want to move. All you have to do is drag and drop the row or column to your preferred location. However, if you aren’t careful then the data cells may get merged and duplicated. The easiest way to move a row or column in Excel is with your mouse. Stick around till the end if you’re interested in a bonus tip. This guide will walk you through handy methods to move rows and columns in Microsoft Excel. However, rearranging data isn’t as easy when you’ve to move entire rows or cells in a worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |