One way to make these multiple tables is to copy a table, pasting it elsewhere and then changing the new table's contents. Yet Excel can also copy formatting styles without copying cell contents ...

Then, you’d use the fill handle to copy that formula to F4:F6. If you define your data range as a table, Excel will automatically copy the formula in F3 to F4:F6 for you. To do so, you must ...