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
Highlighted
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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies