Thread: Converting formulas from cell references to numbers
View Single Post
 
Old 07-20-2022, 03:18 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Take the formula such as =Q6+R6+S6+T6+U6
In the formula bar, double-click on say Q6 to select that single reference:
2022-07-20_231308.png
then press the key F9 on the keyboard. Excel will replace the reference with its value. If you select more than one reference in the formula it will try and calculate the bit of formula that you've selected.
Here I've done it with Q6:
2022-07-20_231348.png
and here I've double clicked on all but one reference, one at a time and pressed F9 each time and got:
2022-07-20_231441.png


Any use?
Reply With Quote