Show And Highlight Formulae In Excel - The Excel Hub
We cover how to display and highlight formulae in Excel. In our example, we have a budget planner and want to quickly identify which formulae are used in this sheet. Firstly, we can display the formulae for all cells that contain formulae instead of values. The alternative option is to use a shortcut. Hold down the control key and the grave accent (`) which is usually found in the top left of most keyboards. This tool makes it easy to view all the formulae in your sheet without having to inspect each individual cell. The second tool will allow you to select all the cells that contain formulae. The purpose of this is that you may want to highlight these cells for auditing purposes.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Show And Highlight Formulae In Excel ...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Display All Cells Containing Formulae: (0:24)
Shortcut: (1:01)
Select All Cells Containing Formulae: (1:32)
Select All Cells Containing Values: (2:25)