Hi, I am trying to find out how do you apply a formula from a single
cell to multiple cells. I am trying format painter, where I click a
cell, then the format painter icon, then another cell; but it won't
paste the cell for some reason.

Like for instance, a cell in B2 needs to be posted in cells C2 to H2.
How do I do that? Or like I want a formula in F13 that will take all
the data from row 2 and multiple it to row 19, and post a sum to row
13.
Or when i need to put a new data in order to keep track of items I
sell, whats the best way?