Home

HELP: cell copied is deselected when clicking on formula bar.

%3CLINGO-SUB%20id%3D%22lingo-sub-253388%22%20slang%3D%22en-US%22%3EHELP%3A%20cell%20copied%20is%20deselected%20when%20clicking%20on%20formula%20bar.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253388%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EMY%20PROBLEM%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20behaviour%20of%20excel%20seems%20different%20today%2C%20I%20can%E2%80%99t%20copy%20and%20paste%20a%20value%20directly%20on%20the%20formula%20bar%20any%20longer.%3C%2FP%3E%3CP%3EWhen%20I%20copy%20a%20cell%2C%20it%20appears%20the%20usual%20dashed%20line%20to%20highlight%20that%20the%20cell%20is%20copied.%20As%20soon%20I%20click%20the%20Formula%20Bar%2C%20when%20any%20cell%20is%20selected%2C%20the%20dashed%20line%20disappears%2C%20and%20by%20clicking%20ctrl%2BV%20no%20value%20is%20pasted%20on%20the%20formula%20bar.%3C%2FP%3E%3CP%3EI%E2%80%99m%20using%20Office%20365%2C%20desktop%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHOW%20I%20TRIED%20TO%20SOLVE%20THE%20ISSUE%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20have%20just%20tried%20to%20restart%20the%20computer%3B%20I%20don%E2%80%99t%20know%20what%20else%20to%20try.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWHAT%20I%20USED%20TO%20DO%20AND%20WHY%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EWhen%20I%20need%20to%20copy%20a%20value%20(not%20formulas)%20from%20cell%20X%20to%20cell%20Y%2C%20I%20used%20to%20copy%20the%20cell%20X%20and%20paste%20the%20value%20directly%20on%20the%20formula%20bar%20of%20cell%20Y.%20I%20know%20that%20I%20could%20use%20Paste%20Special%20to%20paste%20only%20values%2C%20but%20the%20behaviour%20is%20different%2C%20and%20I%20prefer%20to%20copy%20directly%20on%20formula%20bar.%20For%20example%2C%20if%20in%20cell%20X%20the%20value%20is%201%2C000000005%2C%20and%20the%20cell%20is%20formatted%20to%20show%20only%202%20decimals%2C%20I%20have%20two%20different%20value%20in%20cell%20Y%20if%20I%20paste%20to%20formula%20bar%20and%20or%20use%20Paste%20Special%3B%20if%20I%20copy%20and%20paste%20the%20value%20in%20cell%20Y%20with%20paste%20special%2C%20the%20value%20of%20cell%20Y%20is%201%2C000000005%2C%20and%20I%20need%20to%20format%20the%20cell%20to%20show%20only%202%20decimals%3B%20on%20the%20contrary%20if%20I%20copy%20and%20paste%20on%20formula%20bar%20of%20cell%20Y%2C%20the%20pasted%20value%20is%20exactly%201%2C00%2C%20regardless%20of%20how%20I%20format%20cell%20Y.%20Sometimes%20I%20need%20the%20original%20value%2C%20sometimes%20I%20need%20the%20value%20already%20rounded%3B%20that%E2%80%99s%20why%20I%20don%E2%80%99t%20want%20to%20use%20paste%20special%2C%20but%20I%20would%20like%20to%20paste%20on%20formula%20bar.%20Moreover%2C%20by%20copying%20values%20on%20formula%20bar%2C%20instead%20of%20using%20paste%20special%20I%20also%20save%20a%20few%20clicks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-253388%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECopy%20and%20Paste%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecopy%20cell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPaste%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254210%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%3A%20cell%20copied%20is%20deselected%20when%20clicking%20on%20formula%20bar.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254210%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20to%20be%20able%20to%20copy%20cells%2C%20then%20right%20click%20and%20%22insert%22%20a%20new%20row%20or%20column%20prior%20to%20pasting%20somewhere%20else%20on%20the%20sheet%20or%20on%20another%20sheet.%20This%20functionality%20is%20gone%20within%20the%20past%2024%20hours.%20Now%2C%20when%20cells%20are%20copied%2C%20right%20clicking%20brings%20up%20a%20menu%20where%20%22insert%22%20is%20no%20longer%20an%20option.%20There%20is%20only%20%22insert%20copied%20cells%22%20which%20does%20not%20accomplish%20inserting%20a%20new%20row%20or%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOh%20well%20time%20to%20break%20an%20old%20habit%20I%20guess.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254133%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%3A%20cell%20copied%20is%20deselected%20when%20clicking%20on%20formula%20bar.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254133%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20absolutely%20right%20that%20this%20behavior%20has%20changed%20just%20in%20the%20last%20few%20days.%20I%20use%20this%20technique%26nbsp%3BALL%20THE%20TIME%26nbsp%3Bto%20paste%20values%20directly%20into%20cells%20without%20using%20Paste%20Special.%20Today%20it%20does%20not%20work.%20Really%20hoping%20this%20is%20not%20a%20planned%20%22improvement.%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253830%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%3A%20cell%20copied%20is%20deselected%20when%20clicking%20on%20formula%20bar.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253830%22%20slang%3D%22en-US%22%3E%3CP%3EThanks...%20I%20am%20pretty%20sure%20I%20could%20do%20that%20few%20weeks%20ago%2C%20because%20it%20was%20part%20of%20one%20of%20my%20weekly%20routine%20I%20have%20been%20doing%20since%20April.%3CBR%20%2F%3E%3CBR%20%2F%3EFew%20weeks%20ago%20I%20was%20working%20with%20my%20Surface%2C%20with%20Win%2010%20(maybe%20not%20the%20very%20last%20update)%20and%20Office%20365.%20I%20detected%20the%20change%20of%20behavior%20now%20that%20I%20use%20a%20different%20laptop%2C%20but%20still%20with%20WIn%2010%20(now%20withe%20the%20latest%20update)%20and%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20again%2C%20thank%20you%20very%20much%20for%20tryng%20to%20replicate%20the%20issued%20on%20your%20systems%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253488%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%3A%20cell%20copied%20is%20deselected%20when%20clicking%20on%20formula%20bar.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253488%22%20slang%3D%22en-US%22%3EI%20have%20both%20Excel%202010%20and%202016%20installed%20on%20a%20Windows%2010%20box.%20With%20neither%20version%20can%20I%20paste%20a%20copied%20cell%20into%20the%20formula%20bar.%3CBR%20%2F%3EI%20also%20have%20Excel%202010%20on%20Windows%207.%20That%20combination%20also%20does%20not%20allow%20this%20way%20of%20working.%20Whether%20this%20is%20something%20which%20is%20due%20to%20an%20update%20of%20Windows%20or%20of%20Office%20I%20do%20not%20know.%3C%2FLINGO-BODY%3E
Highlighted
Marco Amicucci
New Contributor

MY PROBLEM

The behaviour of excel seems different today, I can’t copy and paste a value directly on the formula bar any longer.

When I copy a cell, it appears the usual dashed line to highlight that the cell is copied. As soon I click the Formula Bar, when any cell is selected, the dashed line disappears, and by clicking ctrl+V no value is pasted on the formula bar.

I’m using Office 365, desktop version.

 

HOW I TRIED TO SOLVE THE ISSUE

I have just tried to restart the computer; I don’t know what else to try.

 

WHAT I USED TO DO AND WHY

When I need to copy a value (not formulas) from cell X to cell Y, I used to copy the cell X and paste the value directly on the formula bar of cell Y. I know that I could use Paste Special to paste only values, but the behaviour is different, and I prefer to copy directly on formula bar. For example, if in cell X the value is 1,000000005, and the cell is formatted to show only 2 decimals, I have two different value in cell Y if I paste to formula bar and or use Paste Special; if I copy and paste the value in cell Y with paste special, the value of cell Y is 1,000000005, and I need to format the cell to show only 2 decimals; on the contrary if I copy and paste on formula bar of cell Y, the pasted value is exactly 1,00, regardless of how I format cell Y. Sometimes I need the original value, sometimes I need the value already rounded; that’s why I don’t want to use paste special, but I would like to paste on formula bar. Moreover, by copying values on formula bar, instead of using paste special I also save a few clicks.

4 Replies
Highlighted
I have both Excel 2010 and 2016 installed on a Windows 10 box. With neither version can I paste a copied cell into the formula bar.
I also have Excel 2010 on Windows 7. That combination also does not allow this way of working. Whether this is something which is due to an update of Windows or of Office I do not know.
Highlighted

Thanks... I am pretty sure I could do that few weeks ago, because it was part of one of my weekly routine I have been doing since April.

Few weeks ago I was working with my Surface, with Win 10 (maybe not the very last update) and Office 365. I detected the change of behavior now that I use a different laptop, but still with WIn 10 (now withe the latest update) and Office 365.

 

But again, thank you very much for tryng to replicate the issued on your systems

Highlighted

You are absolutely right that this behavior has changed just in the last few days. I use this technique ALL THE TIME to paste values directly into cells without using Paste Special. Today it does not work. Really hoping this is not a planned "improvement."

Highlighted

I used to be able to copy cells, then right click and "insert" a new row or column prior to pasting somewhere else on the sheet or on another sheet. This functionality is gone within the past 24 hours. Now, when cells are copied, right clicking brings up a menu where "insert" is no longer an option. There is only "insert copied cells" which does not accomplish inserting a new row or column.

 

Oh well time to break an old habit I guess.