What happens to standard formatting applied within a Quick View when the sheet or workbook is refreshed?

• A. The formatted cells will revert to what was applied prior to the standard formatting being applied.
• B. The user will be prompted to save the formatting against the Quick View.
• C. The formatting will still be retained in the Quick View.
• D. The formatted cells will be lost within the Quick View.

Answer: (A)

When you apply standard formatting inside a Quick View, it behaves as a temporary overlay. A refresh reloads the data and reapplies the underlying, saved formatting, so those ad-hoc changes aren’t kept. The cells revert to the formatting that existed before you applied the Quick View formatting. If you need persistent formatting, you’d have to save it at the base sheet level or in a persistent view.