Comments on: How To Apply a Formula to an Entire Column in Google Sheets

By: Carolyn

Carolyn — Wed, 15 Feb 2023 14:37:39 +0000

I’m looking to run an =FREQUENCY function that is pulling data that is numeric and alpha. The function is working for the numeric cells but not anything that has letters.

By: Christopher Daniel

Christopher Daniel — Tue, 13 Dec 2022 03:28:57 +0000

In reply to pippa. Try Option + D

By: Christopher Daniel

Christopher Daniel — Tue, 13 Dec 2022 00:23:34 +0000

In reply to Robert Tolmach. Hi Robert. That would depend on the function(s) being applied with the ARRAYFORMULA and how large the range is. Usually, an ARRAYFORMULA will process faster.

By: Robert Tolmach

Robert Tolmach — Sun, 20 Nov 2022 18:52:21 +0000

It would be useful if you indicated whether arrayformula uses less memory or processes faster than the other approaches, which repeat the formula in every cell.

By: pippa

pippa — Thu, 20 Oct 2022 08:19:05 +0000

Hi, Command D does not work for this on a mac. It opens to save a bookmark! Any other suggestions

By: Ciosek

Ciosek — Thu, 29 Sep 2022 14:57:01 +0000

i have a question. Because here we are only using number.

But what is we want to use UPPER on a list already present ? I’m wondering if there is a way to just do “in the column/row i want to use this formula in every cell?”

By: Jason

Jason — Fri, 09 Apr 2021 20:51:24 +0000

Very helpful for a spreadshidiot like myself.