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?
Highlighted

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies