How to add buttons to excel to refresh the worksheet?

The default is automatic refresh. You can also press F9 directly to refresh.

If necessary, add a button, double-click the click event program entry button, and enter Calculate. Return to the worksheet, exit VBA editing state, and then use the button.

The VBA program looks like this

Private subcommand button 1_Click ()

calculate

End joint

Supplement 1:

This is a button. Don't you know how to do it? I suggest you add the ID of your confidant, hehe.