Quickly Refresh a Sheet (Worksheet) in Excel

In Excel, you can refresh a worksheet manually. You usually don’t need to refresh it manually as, by default, you have the “Automatic” update option selected.

But there are ways that you can use to refresh a sheet manually, and in this tutorial, we will learn these methods. In the below example, we have used the RAND function, which changes its value when you refresh the sheet.

Using the Keyboard Shortcut

You can use the Shift + F9 key (or Shift + Fn + F9) to refresh a sheet instantly. It’s quick, and you use it multiple times if you need.

You can also use the F9 key, which will calculate the entire workbook instead of the active sheet.

Using the Calculate Sheet Option

1. Go to the sheet which you want to refresh.
2. Open the Formula Tab.
3. Go to the Calculation group of options.
4. Click on the “Calculate Sheet” option.

When you click the option, it refreshes the active sheet, and all your formulas get recalculated.

Using a VBA Code to Refresh a Sheet

Yes, you can use a to refresh a worksheet. All you need to do is to open the visual basic editor, insert a new module, and then paste the below code.

Sub Macro1()
ActiveSheet.Calculate
End Sub

And once you paste it, you can run the code to refresh the worksheet with a single click.

The code we have above refresh the active sheet. But if you want to refresh a specific sheet, you can write a code like the one below:

Sub Macro1()
Sheets("Sheet1").Calculate
End Sub

Now the above code only refreshes the “Sheet1”; if you want to change the name, you can change it directly from the code itself.