Home

Ctrl-R Reassigned to Something Else?

%3CLINGO-SUB%20id%3D%22lingo-sub-691024%22%20slang%3D%22en-US%22%3ECtrl-R%20Reassigned%20to%20Something%20Else%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691024%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20ctrl-d%20and%20ctrl-r%20all%20the%20time%20in%20Excel%20365.%20Today%20when%20I%20tried%20to%20use%20ctrl-r%20a%20dialogue%20popped%20up%20and%20said%2C%20%22Reference%20Added%20Successfully%22.%20If%20I%20try%20it%20again%20another%20popup%20says%2C%20%22Reference%20Already%20Exists%22.%20It's%20not%20filling%20cells%20to%20the%20right%20of%20the%20cell%20I%20want.%20Ctrl-d%20works%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20going%20into%20options%20under%20customize%20ribbon%20to%20check%20out%20the%20shortcut%20settings%2C%20but%20there's%20no%20place%20to%20view%20shortcuts%20there%20anymore.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat's%20this%20reference%20I'm%20now%20adding%20and%20how%20can%20I%20revert%20the%20ctrl-r%20shortcut%20back%20to%20Right%20Fill%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-691024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691801%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl-R%20Reassigned%20to%20Something%20Else%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691801%22%20slang%3D%22en-US%22%3EDo%20you%20have%20any%20.xlsm%20files%20open%20or%20Addins%20installed%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692666%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl-R%20Reassigned%20to%20Something%20Else%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692666%22%20slang%3D%22en-US%22%3E%3CP%3EThere's%20a%20tools%20plugin%20that's%20related%20to%20the%20work%20I%20do%2C%20it's%20been%20installed%20since%20the%20day%20I%20was%20upgraded%20to%20Office%20365.%20I%20would%20say%2075%25%2B%20of%20the%20files%20I%20work%20with%20are%20.xlsm%20files.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Bibliophibian95
New Contributor

I use ctrl-d and ctrl-r all the time in Excel 365. Today when I tried to use ctrl-r a dialogue popped up and said, "Reference Added Successfully". If I try it again another popup says, "Reference Already Exists". It's not filling cells to the right of the cell I want. Ctrl-d works fine.

 

I tried going into options under customize ribbon to check out the shortcut settings, but there's no place to view shortcuts there anymore.

 

What's this reference I'm now adding and how can I revert the ctrl-r shortcut back to Right Fill?

2 Replies
Do you have any .xlsm files open or Addins installed?

There's a tools plugin that's related to the work I do, it's been installed since the day I was upgraded to Office 365. I would say 75%+ of the files I work with are .xlsm files. @Wyn Hopkins 

Related Conversations