💻 Software
How to tell if an Excel cell has a formula or is hardcoded?
Fresh7 days ago
Mar 15, 202683770 viewsConfidence Score0%
0%
Problem
Does anyone have a special tip (non-VBA strongly preferred) to tell systematically if a cell has a hardcoded value or is a derived formula? Am dealing with some data that has messy subtotals embedded in it and am trying to see if I can separate out the raw lines.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to tell if an Excel cell has a formula or is hardcoded?
Low Risk
Select the cells in question, press Ctrl+G and then select to get the following dialog box: Then specify the type of cells you want and click and only those types of cells will remain selected.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix