Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Escel

Copper Contributor

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.

2 Replies

@Ronald_B_Wildman 

 

To make the change in the existing columns, you must first calculate the change elsewhere, then paste it over the original data. 

 

This formula (adjusted for the corrected number of rows in your spreadsheet):

 

=D2:M11-15

 

flexyourdata_0-1706896253104.png

 

Calculates the new values:

flexyourdata_1-1706896284003.png

 

I've put the formula below the original data to make the image size more sensible, but you can put the formula wherever you want. 

 

You can then copy and paste values to replace the original values. Or not, if you prefer. 

 

@Ronald_B_Wildman 

As variant

image.png

- 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.