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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
paste

ResolvedVersion 2003

Neil has attended:
Excel Intermediate course

Paste

I often have 2 Excel screens open on my pc (opened as separate applications).
If I try to copy data from one Excel file to paste in another, Excel will only allow me to paste in bit map (or other image) format rather than as data.
How do I solve this?
Thanks

RE: Paste

Hi Neil, Thank you for the post, welcome to the forum, in response to your question...

I am having problems replicating your difficulty, as a norm Excel is totally compatible with Excel and you should therefore be able to cut/copy and paste (even drag and drop from one file to another) with impunity.
However if this is not working, and in your case it seems not to be; I can only assume you are using the Insert>Object, Browse and Link option, this is creating an embedded file which requires you to double click to edit. If I am wrong, please come back and we can try something else. regards Pete

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

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.