Filter the data so that it shows the cells that you want to paste
Highlight the data and press ALT + ; to select only the filtered data
If you are pasting into an adjacent column – select also the cells to the left or right
Go to the menu/ribbon and on the right click “Fill”
Now click “Left” or “right” depending on where the column is
Sarah Palin Karen Bill U.S. Credit Downgrade al-Qaeda Pirates of the Caribbean Hurricane Irene Costa Concordia Disaster Kathy Long Anthony Weiner Schwarzenegger Jeremy Lin U.S. Debt Ceiling Japan Disaster Wikileaks Katie Taylor Alicia Ashley Dawn George Libyan Conflict Petraeus Affair Lance Armstrong Champions' League Becky Smith Michele Bachmann iPad UK Riots David Cameron Laila Ali Marathons Kony Justin Bieber
littlebigcompany1
therealsupermum
thismomloves
