|
|
#3
04-18-2020, 10:39 PM
|
||||
|
||||
Instead of overtyping, you can simply copy the results returned by the formulae and use Paste Special>Values. An entire column or row could be done in a moment.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula for blank cells | datadummy | Excel | 2 | 09-11-2017 10:19 PM |
| Help with Subtotal(103, ) formula and blank cells | zhl203 | Excel | 1 | 07-30-2014 03:40 PM |
 Can I pre-populate cells with a formula?
|
Box | Excel | 1 | 05-03-2014 11:55 PM |
|
Formula works on most cells
|
gbaker | Excel | 1 | 04-26-2014 12:31 AM |
| Copying a formula that uses pivottable cells | Paul46 | Excel | 0 | 02-08-2014 07:04 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode