Fortunately, Excel enables users to instantly fill an entire row or selection of cells with the same formula with just a few keystrokes, with or without formatting.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Yet Excel can also copy formatting styles without copying cell contents, letting you apply the copied style to tables you've already filled.