The Table format (Home> Format As Table) option is a good feature of Excel. I am using it in Excel 2013.
But when I put a formula and try to copy it across, it does not work. Trouble comes when you want to repeat different sets of formulas etc.
Does anybody know a solution to this. I know that by dragging the formula, it works, but when you have thousands of rows, its terrible to drag.
Edit 1: Putting manual referencing also works, but its cumbersome, and we don't use excel for doing it manually.
Edit 2: A sample file uploaded. Link. In the file I have data in Table format. I put a Subtotal formula in B1, and copied it to C1 and D1. The references do not change in C1 and D1.