Quickly Refresh a Sheet (Worksheet) in Excel

- Written by Puneet

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.

refresh-a-sheet

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.

function-changes-value-when-sheet-refresh-everytime

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.

keyboard-shortcut-to-referesh

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

f9-for-calculate-entire-workbook

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.
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.

vba-to-refresh-sheet

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.

Get the Excel File

Download