|
|
#4
07-20-2022, 03:18 PM
|
||||
|
||||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA or Formulas to parse out numbers based on criteria | durwood | Excel Programming | 2 | 09-17-2019 06:59 PM |
| Rounding numbers in formulas | Lamont | Excel | 3 | 01-09-2019 08:19 AM |
 Converting xls(x) with formulas to pdf
|
rheaney | Excel | 2 | 11-22-2016 03:30 PM |
| Fields and References Don't Show as Numbers | peytontodd | Word | 2 | 05-31-2014 07:05 PM |
|
Cell formulas & formatting
|
kungfauxn00b | Word Tables | 3 | 04-05-2011 04:54 AM |
Windows 10 
Office 2019
Threaded Mode