Forum Discussion
Using the same formula down a column with gaps in rows
SergeiBaklan Hi Sergei, thanks for getting back to me. I've not used excel tables before, and it does look promising to be able to control the formula. However, when I select whole columns to be in the range, then the file size is still around the same as just copying the formula down.
Also, do the columns in the table have to be next to each other, or assign for example columns A, C, E to a table?
Sorry, I didn't catch. Table allows you to add formulas automatically. How file size linked to that?
SergeiBaklan if I make an excel table using cells =$A$1:$C$1000, then the file size is 18 KB. If I make an excel table using cells =$A:$C (i.e. the whole of columns A, B & C), then the file size is 8,547 KB. Ideally, if the formulas copied down when a new row has data, then the file size is still small and doesn't take long to open, and I don't have to edit the tables when the data goes over what it is set to (e.g. changing the table from cells =$A$1:$C$1000 to =$A$1:$C$2000).
But you don't need to make the table for entire future range. Make, for example, for A1:C2, put required formula in C2. After that add data row by row when needed, table will be expanded, and formula will be kept in column C.
SergeiBaklan thanks for the help. I think I was thinking too small, I tried to have a few columns in several tables, but however if I put all columns into the table, as there will always be data in column A then the table replicates down.
As I had never used excel tables, this solved the problem, thanks very much.