Home

I paste a copied value and then want to insert cells, Excel will paste the insert into inserted cell

%3CLINGO-SUB%20id%3D%22lingo-sub-197405%22%20slang%3D%22en-US%22%3EI%20paste%20a%20copied%20value%20and%20then%20want%20to%20insert%20cells%2C%20Excel%20will%20paste%20the%20insert%20into%20inserted%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197405%22%20slang%3D%22en-US%22%3E%3CP%3EOk%2C%20so%20I%20thought%20I%20was%20pretty%20good%20at%20Excel%20until%20I%20had%20this%20issue.%26nbsp%3B%20I%20copy%20a%20cell%20and%20then%20paste.%26nbsp%3B%20Then%20went%20to%20add%20a%20row.%26nbsp%3B%20Well%2C%20I%20was%20surprised%20when%20the%20pasted%20value%20ending%20up%20in%20the%20whole%20row.%26nbsp%3B%20I%20am%20using%20Office%20365%20and%20have%20searched%20for%20a%20solution%2C%20didn't%20find%20one.%26nbsp%3B%20Went%20to%20Support%20and%20conntected%20with%20help%20who%20wanted%20me%20to%20repair%20online%20my%20version%20as%20Safe%20mode%20wouldn't%20work.%26nbsp%3B%20Since%20it%20is%20not%20my%20office%20I%20had%20our%20company%20IT%20do%20this%20(repair%20was%20what%20they%20did).%26nbsp%3B%20However%2C%20this%20was%20not%20the%20fix.%26nbsp%3B%20It%20fixed%20the%20ability%20to%20open%20Excel%20in%20Safe%20mode%2C%20but%20not%20my%20clearing%20clipboard%20issue.%26nbsp%3B%20So%20am%20stuck.%26nbsp%3B%20I%20know%20on%20non-365%20you%20could%20copy%20paste%20and%20then%20paste%20more%20if%20you%20chose%20to%20and%20then%20when%20you%20didn't%20want%20the%20clipboard%20you%20hit%20Delete%20and%20good%20to%20go%2C%20insert%20cells%20or%20rows%20with%20no%20dire%20consequences.%26nbsp%3B%20Please%20help!%26nbsp%3B%20Is%20there%20a%20way%20to%20clear%20the%20clipboard%20(outside%20of%20leaving%20the%20clipboard%20open%20and%20manually%20clearing%20it%20(which%20is%20ineffective%20and%20terrible%20for%20productivity)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197405%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EClipboard%20clear%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPaste%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197522%22%20slang%3D%22en-US%22%3ERe%3A%20I%20paste%20a%20copied%20value%20and%20then%20want%20to%20insert%20cells%2C%20Excel%20will%20paste%20the%20insert%20into%20inserted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197522%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Linda%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20what%20John%20has%20said%20about%20hitting%20%3CSTRONG%3EESC%3C%2FSTRONG%3E%20to%20cease%20the%20pasting%20issue%20(you'll%20know%20something%20is%20is%20currently%20copied%20if%20you%20see%20a%20broken%20box%20around%20a%20cell%20or%20range%20of%20cells)%2C%20you%20can%20also%20clear%20the%20%3CSTRONG%3EExcel%20clipboard%3C%2FSTRONG%3E%20of%20any%20recent%20copied%20data%20that%20you%26nbsp%3Bhave%20captured.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20In%20the%20%3CSTRONG%3EHome%3C%2FSTRONG%3E%20tab%2C%20click%20onto%20the%20expanding%20option%2C%20bottom%20right%20corner%20of%20the%20%3CSTRONG%3EClipboard%3C%2FSTRONG%3E%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20474px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34833iF42D44BAE53CB518%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard.png%22%20title%3D%22clipboard.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EClick%20the%20little%20icon%20to%20open%20the%20Clipboard%20side%20pane.%20This%20will%20show%20you%20the%20recent%20things%20that%20you%20have%20previously%20copied.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20396px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34834i50C8609D62ABA1F0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard1.png%22%20title%3D%22clipboard1.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EAs%20you%20can%20see%2C%20John%20Doe%20was%20the%20last%20cell%20I%20had%20copied%20and%20still%20has%20the%20rotating%20broken%20line%20box%20around%20the%20cell%20telling%20me%20it%20is%20active%20in%20memory%20to%20paste.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2.%20From%20the%20%3CSTRONG%3EClipboard%3C%2FSTRONG%3E%20side%20pane%2C%20you%20can%3A%3C%2FP%3E%3CP%3Ea.%20%3CSTRONG%3EPaste%20All%3C%2FSTRONG%3E%20-%20Everything%20in%20%3CSTRONG%3EClipboard%3C%2FSTRONG%3E%20memory%20will%20paste%20to%20a%20cell%20location%20that%20you%20select.%3C%2FP%3E%3CP%3Eb.%20%3CSTRONG%3EClear%20All%3C%2FSTRONG%3E%20-%20Clears%20the%20%3CSTRONG%3EClipboard%3C%2FSTRONG%3E%20of%20all%20data.%3C%2FP%3E%3CP%3Ec.%20%3CSTRONG%3EClear%20a%20single%20item%3C%2FSTRONG%3E%20-%20Hover%20your%20mouse%20over%20the%20item%20in%20the%20%3CSTRONG%3EClipboard%3C%2FSTRONG%3E%20side%20pane%2C%20and%20you%20can%20%3CSTRONG%3EDelete%3C%2FSTRONG%3E%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20424px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34835iF2770168D01170D2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard2.png%22%20title%3D%22clipboard2.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EClick%20onto%20the%20item%20to%20immediate%20paste%2C%20or%20hover%20over%20the%20item%2C%20drop%20down%20the%20list%20and%20you%20can%20Delete%20the%20item%20if%20you%20wish.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHopefully%20that%20also%20helps%20to%20understand%20the%20ways%20you%20can%20manage%20your%20Clipboard%20data.%20Also%26nbsp%3Baccessing%20previously%20copied%20cells%20can%20help%20with%20repetitive%20tasks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197423%22%20slang%3D%22en-US%22%3ERe%3A%20I%20paste%20a%20copied%20value%20and%20then%20want%20to%20insert%20cells%2C%20Excel%20will%20paste%20the%20insert%20into%20inserted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197423%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Linda!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20do%20several%20things.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E1.%3C%2FSTRONG%3E%20You%20can%20use%3CEM%3E%3CSTRONG%3E%20Ctrl%20%2B%20C%3C%2FSTRONG%3E%3C%2FEM%3E%20for%20copying%20and%20%3CEM%3E%3CSTRONG%3ECtrl%20%2B%20V%3C%2FSTRONG%3E%3C%2FEM%3E%20for%20pasting.%26nbsp%3B%20When%20you%20want%20to%20finish%20the%20clipboard%20thing%2C%20you%20could%20use%20the%20%3CEM%3E%3CSTRONG%3EEsc%3C%2FSTRONG%3E%3C%2FEM%3E%20key%2C%20and%20Done!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E2.%3C%2FSTRONG%3E%20You%20can%20use%20%3CEM%3E%3CSTRONG%3ECtrl%20%2B%20C%3C%2FSTRONG%3E%3C%2FEM%3E%20for%20copying%20and%20%3CEM%3E%3CSTRONG%3ECtrl%20%2B%20V%3C%2FSTRONG%3E%3C%2FEM%3E%20for%20pasting.%26nbsp%3B%20If%20you%20have%20the%20last%20pasting%20thing%2C%20you%20can%20paste%20%3CEM%3E%3CSTRONG%3Ewith%20Enter%20instead%20of%20Ctrl%20%2B%20V%3C%2FSTRONG%3E%3C%2FEM%3E%2C%20for%20clearing%20Clipboard.%26nbsp%3B%20Done!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20tips%20work%20for%20you.%26nbsp%3B%20Blessings!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-943105%22%20slang%3D%22en-US%22%3ERe%3A%20I%20paste%20a%20copied%20value%20and%20then%20want%20to%20insert%20cells%2C%20Excel%20will%20paste%20the%20insert%20into%20inserted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-943105%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3BYeah.%20Ok.%20But%20when%20I%20do%20an%20insert%20I%20want%26nbsp%3B%3CEM%3E%3CSTRONG%3Einsert%3C%2FSTRONG%3E%3C%2FEM%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3Enot%20flippin%20%3CEM%3E%3CSTRONG%3Epaste%3C%2FSTRONG%3E%3C%2FEM%3E!%20This%20design%20%22feature%22%20makes%20no%20sense%20at%20all%20to%20me%20and%20users%20should%20be%20able%20to%20turn%20it%20off.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Linda A.
Regular Visitor

Ok, so I thought I was pretty good at Excel until I had this issue.  I copy a cell and then paste.  Then went to add a row.  Well, I was surprised when the pasted value ending up in the whole row.  I am using Office 365 and have searched for a solution, didn't find one.  Went to Support and conntected with help who wanted me to repair online my version as Safe mode wouldn't work.  Since it is not my office I had our company IT do this (repair was what they did).  However, this was not the fix.  It fixed the ability to open Excel in Safe mode, but not my clearing clipboard issue.  So am stuck.  I know on non-365 you could copy paste and then paste more if you chose to and then when you didn't want the clipboard you hit Delete and good to go, insert cells or rows with no dire consequences.  Please help!  Is there a way to clear the clipboard (outside of leaving the clipboard open and manually clearing it (which is ineffective and terrible for productivity)?

3 Replies
Highlighted

Hi, Linda!

 

You could do several things.

 

1. You can use Ctrl + C for copying and Ctrl + V for pasting.  When you want to finish the clipboard thing, you could use the Esc key, and Done!

 

2. You can use Ctrl + C for copying and Ctrl + V for pasting.  If you have the last pasting thing, you can paste with Enter instead of Ctrl + V, for clearing Clipboard.  Done!

 

Maybe this tips work for you.  Blessings!

Highlighted

Hi Linda

 

In addition to what John has said about hitting ESC to cease the pasting issue (you'll know something is is currently copied if you see a broken box around a cell or range of cells), you can also clear the Excel clipboard of any recent copied data that you have captured.

 

1. In the Home tab, click onto the expanding option, bottom right corner of the Clipboard section.

 

Click the little icon to open the Clipboard side pane. This will show you the recent things that you have previously copied.Click the little icon to open the Clipboard side pane. This will show you the recent things that you have previously copied.

As you can see, John Doe was the last cell I had copied and still has the rotating broken line box around the cell telling me it is active in memory to paste.As you can see, John Doe was the last cell I had copied and still has the rotating broken line box around the cell telling me it is active in memory to paste.

2. From the Clipboard side pane, you can:

a. Paste All - Everything in Clipboard memory will paste to a cell location that you select.

b. Clear All - Clears the Clipboard of all data.

c. Clear a single item - Hover your mouse over the item in the Clipboard side pane, and you can Delete it.

 

Click onto the item to immediate paste, or hover over the item, drop down the list and you can Delete the item if you wish.Click onto the item to immediate paste, or hover over the item, drop down the list and you can Delete the item if you wish.

Hopefully that also helps to understand the ways you can manage your Clipboard data. Also accessing previously copied cells can help with repetitive tasks.

 

Best wishes!

 

Cheers

Damien

Highlighted

@Damien Rosario Yeah. Ok. But when I do an insert I want insert not flippin paste! This design "feature" makes no sense at all to me and users should be able to turn it off.

Related Conversations
Adding a line onto a pre-designed Gantt chart
hoffmanwolff in Excel on
0 Replies
Getting #Value!
ranjit995 in Excel on
2 Replies
pratica 1002380750 - query web
Ben_Hur in Excel on
1 Replies
Custom Sheet View is not working in Office 365
RonanK in Excel on
1 Replies
help with macris & VBA
Adil_813 in Excel on
0 Replies
How to count average in certain time range
rutilusss in Excel on
1 Replies