How To Swap Values Between Cells, Rows, Or Columns In MS Excel

When selecting text in MS Word, you might have accidentally clicked at the wrong time, or released the mouse button when you didn’t intend to and ended up rearranging text. Swapping text, when done accidentally is annoying but a swap function is nevertheless very useful and if you think about an application like MS Excel, a swap function is a must have. With MS Excel, you have cells filled with data that you may need to swap between cells, or even between rows and columns. Fortunately MS Excel has a swap function that lets you swap date in cells easily. Here’s how it works.

Open the Excel file you want to swap cells, column, or rows in.

Select the cell, row, or column you want to swap the contents of, and hold down the Shift key. Next, click at the rightmost border of the cell, and drag it outwards. Do not release the Shift key.

You can see in the image below that as you drag the cursor out, it changes to a different shape depending on where the cursor is position.

When the cursor becomes a thick horizontal ‘I’ shape at the bottom of the adjacent cell, it will swap the value of the cell with the cell below that line. Likewise, if you move it to the top of the adjacent cell and it turns into a thick horizontal ‘I’ shape at the top, the value of the cell will be swapped with the cell above the adjacent one.

If, however, you drag it to the right of the adjacent cell and the cursor transforms into a thick ‘I’, contents of the selected cell will be swapped out with those in the adjacent cell as shown in the image above.

To swap values between rows and columns, select an entire row or column, and then hold down Shift before dragging your cursor out to the row or column you want to swap its values with.

Release the Shift key and the mouse button once you’ve got the cursor positioned over where you want to swap the contents of the cell/row/column to.

قالب وردپرس

About Kelli Smith

Kelli Smith
Kelli runs customer support and creates content for Skillcrush, a digital skills training and education platform with friendly instructors, an active student community, and laser focus on helping you achieve your career goals with technology. She has an MBA and successfully ran an international company and her own freelancing business before pursuing her passion for tech by taking advanced web development classes. Kelli loves listening to tech podcasts at 2x speed, looking for cute Corgi photos online and teaching and performing country line dancing—as a true Texan living in Finland would do. Say hi on Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *