Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Only Recalculate or Refresh Selected Cells in Excel?
Recalculating the entire workbook can be time-consuming and ineffective when working with large Excel spreadsheets that contain a variety of formulas and data. However, Excel has a strong feature that lets you update only particular cells or ranges of cells, which can save you a lot of time and effort.
In this article, we'll look at many techniques for updating a subset of cells in Excel so that computations are accurate and current without having to recalculate the entire file. These methods will enable you to improve productivity and optimise your workflow, whether you need to change a single cell or a group of cells. So let's get started and discover how to use Excel's selective recalculation feature to increase productivity and simplify spreadsheet jobs!
Only Recalculate or Refresh Selected Cells
Here, we will first create a VBA module and then run it to complete the task. So let us see a simple process to learn how you can only recalculate or refresh selected cells in Excel.
Step 1
Consider an Excel sheet where the data in the sheet is similar to the below image.
First, select the range of cells, then right-click on the sheet name and select View Code to open the VBA application.
Select Cells > Right Click > View Code.
Step 2
Then click on Insert and select Module, then copy the below code into the text box.
Insert > Module > Copy.
Code
Public Sub RecalculateSelection() If TypeName(Selection) = "Range" Then Selection.Calculate End Sub
Then click F5 to run the module. Then selected cells will be recalculated.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can only recalculate or refresh selected cells in Excel to highlight a particular set of data.
289 Views
