Home Computer Repair How To Swap Two Rows in Microsoft Excel

How To Swap Two Rows in Microsoft Excel


Microsoft Excel is the ideal app for handling large amounts of data. You can use it to get a great deal of work done in no time, as long as you know which functions to use. But it can be hard to master because there are many features and commands to learn.

Mistakes happen easily during data entry, and you will probably need to swap rows (or columns) sooner or later. Fortunately, this is one of the easiest things you can do in Excel. Keep reading to learn how to swap two rows in two different ways. You can use the same methods to swap columns as well.

The Imaginary Problem

To illustrate these methods, we have created an Excel file pretending we are a system administration service that keeps track of active servers. We filled in a few rows to give you an idea of how things work. Let’s pretend that the information for Computer 7 and Computer 5 has been mixed up and that you want to correct the mistake.