Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

double copy

ResolvedVersion 2013

ALI AKBAR has attended:
Excel Advanced course

Double copy

can we have a option of doing two copy paste at a time i.e use two different shortcuts to copy two things at one time

RE: double copy

Hi Ali

Thank you for your question. It sounds like you are looking to be able to hold two different values in the clipboard so you have the option which one to paste.

You can achieve this result by viewing the items stored in Excel's clipboard (it stores the last 24 things you have copied) and directly choosing which one should be pasted into the spreadsheet.

To look at what is in your clipboard go to the Home tab and click the small symbol to the right of the group label "clipboard" (below the cut and copy buttons).

A panel will open showing previews of the things you have copied. click on one of them and it will be pasted into your spreadsheet.

I hope this helps - let me know if you have any further questions.

Kind regards,
Andrew

Tue 10 Mar 2015: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.