Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there Mark and welcome
Can you tell me exactly how you need help please?
Can you please both provide the actual file and explain the exact steps your doing
What you do is select the cells you want to copy
Hold CTRL and select the cells you want to paste to so both lines are selected
Then you click on Fill in the home tap then Right if the blank cells are to the right and it does it correctly
You cannot do a normal copy and paste on a filtered column
If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.