Join Dennis Taylor for an in-depth discussion in this video Move and insert rows and columns of data with a simple drag, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] We're looking at the first sheet…in the Chapter One file, it's called Move Data.…The data has just been sent to us,…and we want to rearrange the order of the columns.…For example, we might want to put the phone number…next to the department.…Another is between columns C and D.…But, rather than inserting a new column,…which certainly isn't wrong, and then moving the data,…and then possibly getting rid of the empty column,…why not do this in a single action?…Simply select, in this case, the entire column,…click column F, and then point to the left edge.…
As you do, you'll see a four-way arrow.…Let's hold down the Shift key now and,…with the left mouse button, drag that left edge leftward.…Drag it right to here, you'll see the I-beam indicator.…Let go of the mouse first, then the key.…We've moved the entire column,…we didn't have to insert a new column.…We could go left-to-right,…we can move multiple columns at the same time.…At a later time, you're reconsidering…and you want these two columns to be moved to the right.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes