VBA & Macro Problems

Fix Ctrl+Shift+R Not Calculating Selected Range in Excel

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is attempting to calculate a specific selected range of cells using the Ctrl+Shift+R shortcut, which works on one computer but fails on another. They need to restore or assign this shortcut.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to use a keyboard shortcut to calculate only a highlighted range of cells rather than the entire worksheet or workbook.
Observed behavior: The Ctrl+Shift+R shortcut does not execute the calculation on the current computer because it is a custom macro-assigned shortcut rather than a built-in Excel feature.

Before you start

Ensure that the Developer tab is enabled in your Excel ribbon, as you will need access to the VBA Editor to create and assign the custom macro.

Solution 1Recommended

Create a Custom VBA Macro and Assign the Shortcut

Since Ctrl+Shift+R is not a default Excel shortcut, you need to recreate the macro that performs this action and manually assign the shortcut key to it.

To ensure this shortcut works across all your Excel files, you should save the macro in your Personal Macro Workbook (PERSONAL.XLSB). This hidden workbook opens every time you start Excel.

Open the VBA Editor

Open Excel and press Alt+F11 to launch the Visual Basic for Applications (VBA) Editor.

Insert the Calculation Code

In the VBA Editor, insert a new module in your PERSONAL.XLSB workbook and paste the following code: Sub CalcSelection() ActiveWindow.RangeSelection.Calculate End Sub

Open the Macros Dialog

Return to your Excel workbook and press Alt+F8 to open the Macro dialog box.

Assign the Shortcut Key

Select the 'CalcSelection' macro from the list, click 'Options', and type an uppercase 'R' (Shift+R) in the shortcut key field to assign Ctrl+Shift+R. Click OK and save your personal workbook.

Built-in Calculation Shortcuts: If you do not want to use a macro, you can use Excel's native calculation shortcuts: press F9 to calculate all open workbooks, or Shift+F9 to calculate only the active worksheet.

Advanced Spreadsheet Features

Easily Manage Macros and Shortcuts with WPS Spreadsheet

WPS Spreadsheet fully supports VBA macros, allowing you to create custom scripts and assign personalized keyboard shortcuts to automate tasks like calculating specific cell ranges effortlessly.

1. Access the Developer Tools: Open WPS Spreadsheet and navigate to the 'Developer' tab on the top ribbon.
2. Create Your Custom Script: Click on 'Macros' to record a new macro or launch the VBA Editor to write your custom calculation script.
3. Assign the Shortcut: Use the Macro Options menu within WPS to assign your preferred keyboard combination, such as Ctrl+Shift+R, directly to the script.
4. Save as a Macro-Enabled File: Save your spreadsheet in a macro-compatible format to retain the custom shortcut for future editing sessions.

Full support for creating, editing, and running VBA macros.Easily assign and manage custom keyboard shortcuts to speed up your workflow.Highly compatible with Microsoft Excel (.xlsx, .xls, .xlsb) formats and macro files.Lightweight, fast, and completely free to download.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Ctrl+Shift+R work on my work computer but not at home?

Ctrl+Shift+R is not a built-in default shortcut in Excel. It was likely configured as a custom macro shortcut in the Personal Macro Workbook (PERSONAL.XLSB) on your specific work computer.

How do I calculate an entire worksheet instead of just a selected range?

You can quickly calculate the entire active worksheet by pressing Shift+F9. To calculate all open workbooks at once, simply press the F9 key.

Where should I save my macro so it works in all Excel files?

To make a macro globally available across all your files, save it in the Personal Macro Workbook (PERSONAL.XLSB). This hidden file opens automatically in the background every time you launch Excel.

Excel & Data Problems