Forum Discussion
Ronald_B_Wildman
Feb 02, 2024Copper Contributor
Escel
In Excel, how do I apply a constant reduction (minus) factor of 15.0 to all cells in all columns except for columns 1, 2, and 3. There are 13 columns populated in the worksheet A thru M.
SergeiBaklan
Feb 02, 2024MVP
As variant
- put reduction factor in any cell (Q1) and copy that cell
- select desired range to which it'll be applied
- Paste->Paste Special->Subtract->Ok
Ctrl+Z if you'd like to return back right after that.