There are cases where I want to change the format (such as the font) for an entire range of cells, or even an entire worksheet. Sometimes the font does not update.
Example: Let’s say I want to change the font to Arial in the entire worksheet. If cell A1 is already Arial, then the font is not changed anywhere. However, if cell A1 is some other font, then all of the other cells in the range will change as intended.
Work Around: Change the font of the first cell in the selected range to something else before making the change to the entire range.
The problem with the work around is that you may not realize that it is needed. You may think that you are changing the font in all cells, but you might not be.