<p class="q-text qu-display--block qu-wordBreak--break-word qu-textAlign--start">Use the following macro to reset all the options.</p>
<p class="q-text qu-display--block qu-wordBreak--break-word qu-textAlign--start">Press Alt + F11 on your keyboard. Then from the menu bar on top, select Insert &gt; Module.</p>
<p class="q-text qu-display--block qu-wordBreak--break-word qu-textAlign--start">Paste the following code block there, then click the run button on top (the tiny right-pointing green triangle).</p>
<div class="q-relative qu-py--tiny qu-borderRadius--small qu-bg--gray_ultralight QTextCode___StyledRelative-sc-1j2dh40-0 iXxNjC">
<div class="CssComponent-sc-1oskqb9-0 QTextCode___StyledCssComponent-sc-1j2dh40-1  jrABmp">Sub Reset_Cells()&nbsp;</div>
<div class="CssComponent-sc-1oskqb9-0 QTextCode___StyledCssComponent-sc-1j2dh40-1  jrABmp">CommandBars("Cell").Reset&nbsp;</div>
<div class="CssComponent-sc-1oskqb9-0 QTextCode___StyledCssComponent-sc-1j2dh40-1  jrABmp">CommandBars("Row").Reset&nbsp;</div>
<div class="CssComponent-sc-1oskqb9-0 QTextCode___StyledCssComponent-sc-1j2dh40-1  jrABmp">CommandBars("Column").Reset&nbsp;</div>
<div class="CssComponent-sc-1oskqb9-0 QTextCode___StyledCssComponent-sc-1j2dh40-1  jrABmp">End Sub&nbsp;</div>
</div>
<p class="q-text qu-display--block qu-wordBreak--break-word qu-textAlign--start">The second line resets the cut/copy/insert options for cells, the third resets it for rows and the fourth resets it for columns. Hence, this should enable the controls everywhere.</p>

Use the following macro to reset all the options.

Press Alt + F11 on your keyboard. Then from the menu bar on top, select Insert > Module.

Paste the following code block there, then click the run button on top (the tiny right-pointing green triangle).

Sub Reset_Cells() 
CommandBars("Cell").Reset 
CommandBars("Row").Reset 
CommandBars("Column").Reset 
End Sub 

The second line resets the cut/copy/insert options for cells, the third resets it for rows and the fourth resets it for columns. Hence, this should enable the controls everywhere.

Cut Key in excel is greyed out

Microsoft Teams Auto Start how to turn on/off

Refresh Microsoft Account in O365 apps

Setting up the FCI email signature

Stop spam calendar invites in MS Outlook

Using the Phish Alert Button in MS Outlook

Adding the Vacation Calendar to Outlook

Remove an Outlook Profile/Account (Windows)

Remove an email account from a mobile device

Set up Office 365 email on a mobile device

Set up your Office 365 mailbox in Outlook

Set up office 365 on your laptop or pc

MS Office 365

Welcome to the FCI IT Department!  How may I help?