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
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?
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
Multiple people editing a file
planner9967 in Microsoft Teams on
3 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies