Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #342, your Monday morning espresso, in spreadsheet form!

Whew, it's been quite the week in my household.

Last week I had sinus surgery to alleviate some long-standing sinus issues I've had. It was a nearly 6-hour surgery so I was completely out-of-it for a day or two afterwards.

When I came round they asked if I wanted a drink.

I said "some water" but I couldn't speak clearly because of the bandages etc.

The nurse thought I asked for a "mimosa", which made all the medical staff erupt with laughter.

The recovery is going well and I'm getting a little better each day. I should breathe better when all is said and done. Perhaps I'll even sound different next time you hear my voice in a workshop or recording.

Have a great week!

➜ News

I.
​Oooh, nice! Group by view aggregation now available for tables in Google Sheets 🤩

​Read more here (the 3rd update) >>​

Brought to you by: Wisesheets Stop Wasting Time Copying Stock Data Everyone knows that research is key to great investing. But copying financial data into a spreadsheet for every single stock you want to analyze, wastes hours of your time. Wisesheets lets you pull decades of stock financials, dividend data, options, crypto, and more directly into Google Sheets. Compare thousands of stocks at a glance, screen for companies, build custom models, and keep track of your portfolio all in one place. With Wisesheets, you can save time and focus on what really matters—finding high-return investments. Get Your Free Trial

➜ Sheets Tip #342: Multiply an entire column quickly

Sometimes we find ourselves needing to multiply an entire column of numbers.

Maybe you want to scale everything up by a factor of 10 or make all the numbers negative, for example. (I recently needed to do this when I wanted to display a chart series as negative values.)

Excel has a handy feature built into the paste-special operation that lets you perform the multiplication as you paste the numbers. It's super easy.

Unfortunately, in Sheets, we don't have that feature.

We have to work a little harder, but there are two quick formulas that do it.

Method 1: ArrayFormula

Suppose our data is in column A, then we can use this formula to multiply it by -1 (or any value we choose):

In our Sheet:

Method 2: MMULT

Alternatively, we can use a single MMULT formula like this one that multiplies by 10 (or any value we choose):

In our Sheet:

Important Last Step

Don't forget to change this new column to values, if you no longer require a live formula.

Copy the new column.

Right click and select Paste Special > Values

Bingo!

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Kids and their impeccable logic...​