0

Cannot find this anywhere I look. Lot of SEO spam on Google Sheets.

I have a table that has a ton of different styles:

Header
small font
BIG FONT
bold font
italic font

The "small font" cell is a formula. I would like to "drag" the small font formula all the way down while maintaining the styling of all of the cells. If I do this, it makes all the cells "small font" styling too.

In Excel you can do this by right-clicking the "Fill Down" square and having multiple drag options.

I am open to other solutions of doing this quickly, but copying and then "Special Pasting" the formula only is a bit slow to productivity.

1 Answer 1

1

In Google Sheets, you can use an array formula instead of manually filling down copies of the same formula separately in every cell.

So, instead of filling down a formula like =A2 + B2 in cells C2:C10, insert this array formula in cell C2:

=arrayformula( A2:A10 + B2:B10 )

The formula will automatically fill cells C2:C10 without modifying their formatting.

1
  • Not exactly what the OP was asking for, because cells whose values were calculated using an ArrayFormula (except the original cell) show just their values in Formula box, as opposed to the a formula used to calculate them. But I'm assuming this is the best answer because Sheets just doesn't provide a way to drag a formula without also copying formatting.
    – Matt
    Mar 14 at 16:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.