Use this Excel quick fill handle trick to insert partial rows and columns Your email has been sent Learn the many ways to insert entire and partial rows and columns in Excel, including a fill handle ...

Copy all of the cells from the original column to the first new column. Select the character that divides the data. Depending on your data, this could be a space, a comma, a dash or another character.