You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.

Learn how to remove formula in Excel and keep the text. Use Paste Special option to delete formulas without removing values in Excel.