Hi
susang,
To refresh the format of cells in
Microsoft Excel, you can use the following shortcut key combination:
- Select the cells that you want to refresh the format for.
- Press the keys Ctrl + 1 on your keyboard. This will open the "Format Cells" dialog box.
- Without making any changes, click "OK" or press "Enter" on your keyboard. This will refresh the format of the selected cells.
Alternatively, you can also use the
"F2" key to edit the cell, then press
"Enter" to refresh the format. This is the method you mentioned in your question.
I hope this helps! Let me know if you have any other questions.