How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard
Richard, Software Engineer
Category: Microsoft
Satisfied Customers: 38424
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Question Here...
Richard is online now

I need some Exel help lease. Can anyone do that?

Resolved Question:

Hi, I need some Exel help lease. Can anyone do that?
Submitted: 1 year ago.
Category: Microsoft
Expert:  Richard replied 1 year ago.

Hi there Mark and welcome

Can you tell me exactly how you need help please?

Customer: replied 1 year ago.
Im doing the accounts and Im I using a filter to break out all the various payments I make. I'm selecting visible cells only but when I paste them the results are all over the place.
Expert:  Richard replied 1 year ago.

Can you please both provide the actual file and explain the exact steps your doing

Customer: replied 1 year ago.
Here's the file. I have put in a data filter and selected all Paypal entries. Then I'm using Home/Find and Select (far right) Go To Special/select visible cells. Then Im using copy and paste but they come out all over the place.
Expert:  Richard replied 1 year ago.

thanks

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.

Thank you

Richard and 3 other Microsoft Specialists are ready to help you