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
- Go to the sheet which you want to refresh.
- Open the Formula Tab.
- Go to the Calculation group of options.
- 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.
Get the Excel File
DownloadExcel Basics / Excel Worksheet
More Tutorials
- Consolidate Data from Multiple Worksheets
- Rename Sheet in Excel
- Group Worksheets in the Excel
- View Two Sheets Side by Side in Excel
- Add a Worksheet in Excel
- Change Tab Color in Excel (Worksheet Tab)
- Add Title to a Worksheet in Excel
- Copy or Move a Sheet (Worksheet)
- Select All the Worksheets (Sheets)