Inside Microsoft Excel

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

Inside Microsoft Excel

by Kara Hiltz

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 header, hold down the key, and then hover your cursor over the row[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)