Move an entire row or column without displacing your data (2000/2002/2003/2004/2007)

by Kara Soos

Application:

Microsoft Excel 2000/2002/2003/2004/2007

Operating Systems:

Microsoft Windows, Macintosh

When you’re shuffling around rows or columns of data, you probably do a lot of copying and pasting. This method is fine in many cases, but here’s a quicker alternative.

You can move an entire row or column of data to a new position without replacing the existing data. Just select the row or column by clicking on its he